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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.