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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.