Store value of number record and call it out later

[JMD]

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;

[Amir]

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.

[Tom]

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;