It may take a while for a GROUP BY query to run. Nonetheless, I suspect that you want to add a QUIT; statement after the query. QUIT has much the same function as a data step RUN. It terminates PROC SQL and instigates process of writing messages to the log. If you break the PROC SQL, it forces the process of writing messages to the log, but, of course, a QUIT works better. QUIT have any effect on the execution of the query. Sig

On Wed, 20 Mar 2002 23:14:13 +0000, Dave Meyer <dmeyer@HOAGHOSPITAL.ORG> wrote:

>Hi SAS-Lers, > >I am "one-day-old" on Proc Sql. When I run the following code on a 30 >record test data set, I get the grouping that I need/expect for my >output, but either because of a mistake in my code or something I >missed, even after the output is done (in 2 seconds) it says at the top >of my GUI that "...PROC SQL running]" Does proc sql keep running even >after the output is finished? > >Code I am using: > >proc sql; >select distinct id_num, membnam, >min(start_dt) as start format=mmddyy8., >max(end_dt) as end format=mmddyy8. >from aaa_med2 >group by id_num, grp >; > >TIA, > >Dave > >If i hit "break" to stop it, I get the following error message: > >NOTE: The query requires remerging summary statistics back with the >original data. >ERROR: User asked for termination >NOTE: PROCEDURE SQL used: > real time 10:22.00 > > > >-- >Posted via Mailgate.ORG Server - http://www.Mailgate.ORG