Need to Create Macros More Efficiently

sasmaverick — Wed, 18 Mar 2015 19:17:34 GMT

I am trying to create multiple macro variables based on various conditions. Below is my code. I am not sure whether this is the most efficient way.

*to get total number of obs and max value of count variable where count<5;

proc sql noprint;

select count(*),max(count)

into : count1, count2

from dataset1

where count<5

;quit;

*to get total number of obs and max value of count variable where count>=5;

proc sql noprint;

select count(*),max(count)

into : count1, count2

from dataset1

where count>=5

;quit;

*count of name where count>=5;

proc sql;

select count (distinct name) into:cnt

from dataset1

where count>=5;

quit;

*count of name where count<5;

proc sql;

select count (distinct name) into:cnt

from dataset1

where count<5;

quit;

*get names into macro where count<5;

proc sql

select distinct name into : name1-:name&sysmaxlong

from dataset1

where count<5;

quit;

repeat the above step for count>=5

Is there a shorter/more concise way for the above. Will appreciate inputs on a more efficient approach.

Thanks!

Re: Need to Create Macros More Efficiently

LinusH — Thu, 05 Nov 2015 14:44:28 GMT

Are you worried about performance?

It seems that most of these SQL can be merged into one query, by using CASE in the select clause, instead of using a where clause.