topic Re: Number of observations in dataset in SAS Enterprise Guide

Number of observations in dataset

noobs — Thu, 06 Feb 2014 21:56:54 GMT

Hello EG Users,

Is it possible to read length of dataset? I am interested in counting number of observations in a dataset and save it as macro variable, so that I can access it later in another data step.

data have;

input NumProduct 2.;

datalines;

;

run;

%Let havelength = 5;

data have1;

set have;

do i=1 to &havelength;

MultipleOfFive = NumProduct * 5;

output;

end;

run;

Expecting have1 to have following observations:

105

155

205

255

Any suggestions on how to calculate 5 in %Let macro statement so that even if number of observations change dynamically in dataset have, dataset have1 will get populated correctly?

thanks,

Dhanashree

Re: Number of observations in dataset

art297 — Thu, 06 Feb 2014 22:29:34 GMT

There are a number of ways to do that. e.g.:

data _null_;

if 0 then set have nobs=nobs;

call symput('havelength',nobs);

stop;

run;

Re: Number of observations in dataset

data_null__ — Thu, 06 Feb 2014 22:42:44 GMT

For your example program you don't need the value in a macro variable at all. You can also get it in any data step with something like this again not need for macro variable.

if 0 then set have(drop=_all_) nobs=nobs;

data have;
   input NumProduct :2. @@;
   datalines; 
11 21 31 41 51
;;;;
   run; 


data have1;
   set have nobs=havelength;
   do i=1 to havelength;
      MultipleOfFive = NumProduct * 5; 
      output; 
      end; 
   run; 

Re: Number of observations in dataset

noobs — Fri, 07 Feb 2014 16:54:15 GMT

That works gret.. really appreciate shedding light on use of nobs!

Thanks much