Date:         Fri, 29 Sep 2006 09:53:02 -0700
Reply-To:     "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject:      Re: How to obtain obs or _N_ using SQL
Comments: To: Jake Bee <johbee@GMAIL.COM>
Content-Type: text/plain; charset="us-ascii"

Hi Jake,

You are really close:



proc sql noprint;

select count(*) into : noobs from mydata where inline='/Redirect';

quit;





Hope this is helpful.


Mark Terjeson
Senior Programmer Analyst, IM&R
Russell Investment Group


Russell
Global Leaders in Multi-Manager Investing






-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Jake Bee
Sent: Friday, September 29, 2006 9:06 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: How to obtain obs or _N_ using SQL

Is there a way to determine the obs or _N_ from a dataset using proc SQL
based on a value of the data?

ex:

proc sql;

select _N_ into : noobs from mydata where inline='/Redirect';

quit;

Thanks!

Jack