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.
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;
To make it clear, I would like to get a table like this one.
thank you very much
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.