topic Re: Store value of number record and call it out later in SAS Programming

Store value of number record and call it out later

JMD — Tue, 11 Feb 2014 16:55:38 GMT

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 — Tue, 11 Feb 2014 17:13:43 GMT

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 — Tue, 11 Feb 2014 19:29:41 GMT

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;