topic Creating Multiple outputs from a single PROC MEANS step in SAS Programming

Creating Multiple outputs from a single PROC MEANS step

s_manoj — Fri, 29 Jun 2018 05:15:49 GMT

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

Re: Creating Multiple outputs from a single PROC MEANS step

pau13rown — Fri, 29 Jun 2018 05:36:04 GMT

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;

Re: Creating Multiple outputs from a single PROC MEANS step

Tom — Fri, 29 Jun 2018 05:38:27 GMT

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;

Re: Creating Multiple outputs from a single PROC MEANS step

s_manoj — Fri, 29 Jun 2018 06:45:32 GMT

Thank you for replay,
multiple outputs in the sense.. multiple datasets of variable specific.
thank you.