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!
