DATA Step, Macro, Functions and more

Size of array = number of observations in the data set -How to make that work?

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Size of array = number of observations in the data set -How to make that work?

Hi!

I am new to SAS, to please forgive if this is a rather elementary question.

I have a data set that has lets say 15 observations. I am able to count them using _N_ as well as proc sql count function.

I want to declare an array of the size N where N would be equal to the number of observations...

proc sql;

select count (col1) ;

from dataset1;

quit;

array (N) $;

Thank you in advance for all you help!


Accepted Solutions
Solution
‎06-06-2013 02:21 PM
Regular Contributor
Posts: 180

Re: Size of array = number of observations in the data set -How to make that work?

To do this you have to create a macro variable and the use it in the data step:

proc sql noprint;
   select Count(*) into :dim
   from sashelp.class;
quit;

%put &dim;

data _null_;
   /* statements.... */

   array my_array(&dim) $;
   /* more statements  ....  */ 

run;

Regards,

View solution in original post


All Replies
Solution
‎06-06-2013 02:21 PM
Regular Contributor
Posts: 180

Re: Size of array = number of observations in the data set -How to make that work?

To do this you have to create a macro variable and the use it in the data step:

proc sql noprint;
   select Count(*) into :dim
   from sashelp.class;
quit;

%put &dim;

data _null_;
   /* statements.... */

   array my_array(&dim) $;
   /* more statements  ....  */ 

run;

Regards,

New Contributor
Posts: 3

Re: Size of array = number of observations in the data set -How to make that work?

Thank you so much for the quick reply! This did the trick!

Respected Advisor
Posts: 3,156

Re: Size of array = number of observations in the data set -How to make that work?

Obviously count(*) will be the most accurate approach, but it could take some time if doing it on a huge table. Then you could try to get the number of obs from Meta data instead of actually counting it on the fly:

1)

data _null_;

  call symputx('nobs', nobs);

stop;

set sashelp.class nobs=nobs;

run;

%put &nobs;

2)

proc sql;

  select nobs into :nobs from dictionary.tables where libname='SASHELP' AND MEMNAME='CLASS';QUIT;

%put &nobs;

Haikuo

New Contributor
Posts: 3

Re: Size of array = number of observations in the data set -How to make that work?

Thank you so much for your reply Haikuo! I am just learning SAS and I am very happy I found this board!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 274 views
  • 3 likes
  • 3 in conversation