Summary statistics by range

[Terrencefung]

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.

[Terrencefung]

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

thank you very much

[Reeza · Accepted solution]

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;

[Terrencefung]

Thank you Rezza, but how I can create the categories for em?

[Reeza]

Use if then else in a data step. 

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

See example 2.