Help using Base SAS procedures

Summary statistics by range

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

Summary statistics by range

Hi SAS community,

i have a variable called em. It range from 0 to 1.

 

i would like to create a summary statistics table for other variables based on the ranges of em.

 

for example, I would like to get the mean of variables when the observation has 0<=em<0.025, 0.025<=em<0.050 ect.

 

could you please help me, it is urgent.

 

many thnaks.


Accepted Solutions
Solution
‎09-30-2016 03:05 AM
Super User
Posts: 19,822

Re: Summary statistics by range

Posted in reply to Terrencefung

1. Create categories for EM. Either create a new variable and recode it to the values you want or create a format and apply it to the variable. 

2. Use Proc means, include your new variable from 1 as a Class variable, or the EM variable if you used a format. 

 

Proc means data=have mean nway;

class em;

format EM em_cat.;

var var1 var2 var3;

output out = want mean= /autoname;

run;

 

View solution in original post


All Replies
Occasional Contributor
Posts: 13

Re: Summary statistics by range

Posted in reply to Terrencefung

To make it clear, I would like to get a table like this one.

 

 

thank you very much


IMG_0054.JPG
Solution
‎09-30-2016 03:05 AM
Super User
Posts: 19,822

Re: Summary statistics by range

Posted in reply to Terrencefung

1. Create categories for EM. Either create a new variable and recode it to the values you want or create a format and apply it to the variable. 

2. Use Proc means, include your new variable from 1 as a Class variable, or the EM variable if you used a format. 

 

Proc means data=have mean nway;

class em;

format EM em_cat.;

var var1 var2 var3;

output out = want mean= /autoname;

run;

 

Occasional Contributor
Posts: 13

Re: Summary statistics by range

Thank you Rezza, but how I can create the categories for em?
Super User
Posts: 19,822

Re: Summary statistics by range

Posted in reply to Terrencefung

Use if then else in a data step. 

 

 

http://www.ats.ucla.edu/stat/sas/modules/vars.htm

See example 2. 

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 358 views
  • 2 likes
  • 2 in conversation