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;
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;
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;
thanks!!!
Need to use the upper case versions of the variable names I believe.
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,
hi ballardw,
I also got the problems with the names of variable,
and I resolved with yor suggestion.
thanks you!!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.