topic Re: list of variable in summary in SAS Programming

list of variable in summary

Rakeon — Thu, 09 Oct 2014 19:00:20 GMT

Hi to all,

I have to use the proc summary with a lot of ID variables.

How can I save the list of variables in the macro variable?

is there one way to have a macro variables with a list of variable of dataset but without the list in the VAR ?

proc summary data = one

var a b;

id &listvariable.; in this macro variable, how can i put the list of variable of the data set one without the a,b variable into the VAR field?

output = have;

run;

Re: list of variable in summary

stat_sas — Thu, 09 Oct 2014 19:07:33 GMT

proc contents data=one out=varnames(keep=name);
run;

proc sql;
select name into :listvariable separated by ' ' from varnames
where name not in ('a','b');
quit;

%put &listvariable;

Re: list of variable in summary

Rakeon — Thu, 09 Oct 2014 19:18:50 GMT

thanks!!!

Re: list of variable in summary

ballardw — Thu, 09 Oct 2014 19:19:02 GMT

Need to use the upper case versions of the variable names I believe.

Re: list of variable in summary

stat_sas — Thu, 09 Oct 2014 19:45:07 GMT

Hi ballardw,

In proc contens output dataset variable names appearing in the same case as appeared in sources dataset. As per your suggestion it would be better to use upcase function and use upper case variable names. Please advise If I did not understand your question correctly.

Regards,

Re: list of variable in summary

Rakeon — Sat, 11 Oct 2014 06:55:58 GMT

hi ballardw,

I also got the problems with the names of variable,

and I resolved with yor suggestion.

thanks you!!