Proc summary: give a list of variables to var

NewUsrStat — Mon, 21 Aug 2023 10:21:25 GMT

Hi guys,

suppose to do a proc summary and you have a list of variables ending with "_0" you want to give to var. How can you indicate all that variables at once? They are not in a specified order to use "fromthefirst--tothelast".

Thank you in advance

Re: Proc summary: give a list of variables to var

PeterClemmensen — Mon, 21 Aug 2023 10:30:19 GMT

There is no short way of specifying variables with a common suffix.

Do something like this, put them in a macro vairable and use that in your Proc Summary

data have;
input ID One_0 SecondVar Two_0 One Three_0 Three;
datalines;
1 1 2 3 1 2 3
2 4 5 6 4 5 6
3 7 8 9 7 8 9
4 1 2 3 1 2 3
5 4 5 6 4 5 6
;

%let suffix=_0;
 
proc sql noprint;
   select name into :vars separated by ' ' 
   from dictionary.columns 
   where upcase(libname)=upcase('work') 
     and upcase(memname)=upcase('have')
     and upcase(substr(name,length(name)-(length("&suffix")-1),length("&suffix")))=upcase("&suffix");
quit;
 
%put &vars;

topic Re: Proc summary: give a list of variables to var in New SAS User

Proc summary: give a list of variables to var

Re: Proc summary: give a list of variables to var