Need to Create Macros More Efficiently

[sasmaverick]

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!

[LinusH]

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.