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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.