BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ilikesas
Barite | Level 11

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User
3)
proc univariate data=have outtable=want noprint;
var a b c;
run;

View solution in original post

4 REPLIES 4
Reeza
Super User

Try the ODS table and Google STACKODS option. 

Astounding
PROC Star

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.

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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