Good morning,
I wonder how I can to save the number of row in my record and then use that number in later section of my code.
Thank you for your help.
JHN
*I store the row count of file Namelist here;
sql noprint;select count(*) into :ROW_CT from namelist; quit;
*How can I call it here?;
Data test;
do I=1 to ROW_CT
*OR;
Data test;
if _n_< ROW_CT/2;
Hi,
You can access the value of a macro variable by prefixing it with an &, e.g.:
Data test;
do I=1 to &ROW_CT
*OR;
Data test;
if _n_< &ROW_CT/2;
Regards,
Amir.
Also note that you might be able to skip the SQL to count the observations and instead use the NOBS= option on the set statement.
data want ;
set have nobs=nobs ;
if _n_ < nobs/2 ;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.