Date:         Tue, 6 Sep 2005 21:04:37 +0300
Reply-To:     Nina Harris <sas@MAILINATOR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nina Harris <sas@MAILINATOR.COM>
Subject:      limiting sql rows by calculated monotonic()
Comments: To: sas-l@uga.edu
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
              reply-type=original

are there better ways of doing this?

the goal is to "look and analyze" at the data coming from a hundred million
row table first before running a full throttle query

* this is here just to generate some sample data
 in real life this would not exist as the sql connection would provide the
data;
data a;do x=1000 to 500 by -1;output;end;


proc sql;
 create table b as select *, monotonic() as _m_ from a
 where calculated _m_ < 10
 order by x
;
quit;
data _null_;set b;put(_all_)(=);run;