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!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.