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