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.
On Wed, 20 Mar 2002 23:14:13 +0000, Dave Meyer <dmeyer@HOAGHOSPITAL.ORG>
>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:
>select distinct id_num, membnam,
>min(start_dt) as start format=mmddyy8.,
>max(end_dt) as end format=mmddyy8.
>group by id_num, grp
>If i hit "break" to stop it, I get the following error message:
>NOTE: The query requires remerging summary statistics back with the
>ERROR: User asked for termination
>NOTE: PROCEDURE SQL used:
> real time 10:22.00
>Posted via Mailgate.ORG Server - http://www.Mailgate.ORG