topic Re: Summary statistics by range in SAS Procedures

Summary statistics by range

Terrencefung — Sat, 24 Sep 2016 05:17:06 GMT

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 — Sat, 24 Sep 2016 05:20:02 GMT

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

thank you very much

Reeza — Sat, 24 Sep 2016 05:32:21 GMT

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 — Sat, 24 Sep 2016 05:49:05 GMT

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

Reeza — Sat, 24 Sep 2016 08:47:49 GMT

Use if then else in a data step.

See example 2.