Date:         Mon, 21 May 2007 13:57:07 -0400
Reply-To:     "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
Organization: Internet News Service
Subject:      SQL ODS prevent title when select grabs no row
Comments: To: sas-l@uga.edu

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