LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2002, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 20 Mar 2002 21:57:58 -0500
Reply-To:   Sigurd Hermansen <hermans1@WESTAT.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Sigurd Hermansen <hermans1@WESTAT.COM>
Subject:   Re: PROC SQL
Comments:   To: dmeyer@HOAGHOSPITAL.ORG

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

Back to: Top of message | Previous page | Main SAS-L page