list of variable in summary

[Rakeon]

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;

[stat_sas · Accepted solution]

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;

[Rakeon]

thanks!!!

[ballardw]

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

[stat_sas]

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,

[Rakeon]

hi ballardw,

I also got the problems with the names of variable,

and I resolved with yor suggestion.

thanks you!!