BookmarkSubscribeRSS Feed
s_manoj
Quartz | Level 8

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

3 REPLIES 3
pau13rown
Lapis Lazuli | Level 10

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;

Tom
Super User Tom
Super User

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;
s_manoj
Quartz | Level 8
Thank you for replay,
multiple outputs in the sense.. multiple datasets of variable specific.
thank you.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 3043 views
  • 7 likes
  • 3 in conversation