Date:         Tue, 6 Sep 2005 14:05:36 -0400
Reply-To:     "Droogendyk, Harry" <harry.droogendyk@RBC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Droogendyk, Harry" <harry.droogendyk@RBC.COM>
Subject:      Re: limiting sql rows by calculated monotonic()
Content-Type: text/plain; charset="iso-8859-1"

See outobs= option on PROC SQL statement.

-----Original Message-----
From: owner-sas-l@listserv.uga.edu
[mailto:owner-sas-l@listserv.uga.edu]On Behalf Of Nina Harris
Sent: Tuesday, September 06, 2005 2:05 PM
To: sas-l@uga.edu
Subject: limiting sql rows by calculated monotonic()


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;
__________________________________________________________________________________________________________________________________

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations.
Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent.
Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite.
Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.