DATA Step, Macro, Functions and more

output format of proc means with chosen variables

Accepted Solution Solved
Reply
Super Contributor
Posts: 441
Accepted Solution

output format of proc means with chosen variables

Hi,

 

I have 3 variables (a,b,c) for which I want to do calulate n, mean and median and then output the result.

Here is the code and the "want" output:

 

 proc means data=have n mean median ;
var a b c ;
output out = want ;
run;

type  freq statistic a b c
    n      
    min      
    max      
    mean      
    std      

 

Since I want the n, mean and media I do the following adjustment:

 proc means data=have n mean median ;
var a b c ;
output out = want n=n mean=mean median=median ;
run;

 

But here the "want" output table is of the following form:

type  freq n mean median
         

 

here the n, mean and median become columns and I get only 1 row corresponding to variable a, statistics for variables b and c simply don't show.

So is it possible to have the original form of output but for the chosen statistics, so that the "want" output table looks like this:

 

type  freq statistic a b c
    n      
    mean      
    median      

 

Thank you!


Accepted Solutions
Solution
‎09-20-2016 08:37 PM
Super User
Posts: 10,020

Re: output format of proc means with chosen variables

3)
proc univariate data=have outtable=want noprint;
var a b c;
run;

View solution in original post


All Replies
Super User
Posts: 19,770

Re: output format of proc means with chosen variables

Try the ODS table and Google STACKODS option. 

Super User
Posts: 5,498

Re: output format of proc means with chosen variables

Switching to PROC TABULATE will make a lot of this easy:

 

proc tabulate data=have;

var a b c;

tables n mean median, a b c;

run;

 

See if it comes close enough.  You might want to add NMISS to the list of statistics, since you are no longer getting _FREQ_.  It's not clear why you would want _TYPE_ at all, so that part is not included.

Solution
‎09-20-2016 08:37 PM
Super User
Posts: 10,020

Re: output format of proc means with chosen variables

3)
proc univariate data=have outtable=want noprint;
var a b c;
run;

Respected Advisor
Posts: 3,799

Re: output format of proc means with chosen variables

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 403 views
  • 4 likes
  • 5 in conversation