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 (May 2007, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 21 May 2007 18:08:46 +0000
Reply-To:   toby dunn <tobydunn@HOTMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   toby dunn <tobydunn@HOTMAIL.COM>
Subject:   Re: SQL ODS prevent title when select grabs no row
Comments:   To: rdevenezia@WILDBLUE.NET
In-Reply-To:   <56l4i.5$GA.187576@news.sisna.com>
Content-Type:   text/plain; format=flowed

Richard ,

Hmmmm well one could play off of how SQL executes code and Macro Execution time:

%Macro Title( NObs = ) ; %If ( &NObs > 0 ) %Then %Do ; title "Data entry errors may have occurred"; %End ; %Mend Title ;

proc sql; select * from sashelp.class as A, sashelp.class as B where A.name ne B.name and abs(a.age-b.age) < 2 and abs(a.weight-b.weight) > 80 ; %Title( Nobs = &SqlObs ) quit;

Toby Dunn

On the other hand, you have different fingers. ~ LCG

The early bird may get the worm, but the second mouse gets the cheese in the trap. ~ LCG

What happens if you get scared half to death, twice? ~ LCG

From: "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET> Reply-To: "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET> To: SAS-L@LISTSERV.UGA.EDU Subject: SQL ODS prevent title when select grabs no row Date: Mon, 21 May 2007 13:57:07 -0400

A SQL select statement (join) is used to report anomolous data. Sometimes the select results in no rows.

Is there an easy way to keep SQL from outputting a title when there are no rows ?

Example:

title "Data entry errors may have occurred"; proc sql; select * from sashelp.class as A, sashelp.class as B where A.name ne B.name and abs(a.age-b.age) < 2 and abs(a.weight-b.weight) > 80 ; quit;

-- Richard A. DeVenezia

_________________________________________________________________ More photos, more messages, more storageóget 2GB with Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_2G_0507


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