Hi all,
Can anyone guide me that, how to create multiple outputs from a single proc means step.
for example, I have code like:
proc means data = have;
class sex;
var age salary loan;
output out = --------;
run;
wrt to above code, I would require three outputs for age, salary, and loan separately.
Thanks in advance
my answer won't be right but it will be quick: try proc summary, or transpose data set, new variable called 'parameter' which assumes values 'age', 'salary' and 'loan' and then:
ods output ....;
proc means data=;
var var;
by parameter;
run;
What do you mean by multiple outputs?
If you want to make multiple separate datasets then add multiple OUTPUT statements.
proc summary data=sashelp.class ;
class sex ;
var age height ;
output out=xx mean(age)=age ;
output out=yy mean(height)=height ;
run;
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.