Store value of number record and call it out later

Reply
Occasional Contributor JMD
Occasional Contributor
Posts: 5

Store value of number record and call it out later

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;

Super Contributor
Posts: 282

Re: Store value of number record and call it out later

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.

Super User
Super User
Posts: 6,499

Re: Store value of number record and call it out later

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;

Ask a Question
Discussion stats
  • 2 replies
  • 174 views
  • 0 likes
  • 3 in conversation