topic Re: Mean by group in SAS Procedures

Mean by group

sanrim — Sun, 15 Sep 2019 21:33:45 GMT

Hi, I am trying to find mean by group of my data. I have one indicator variable (named CR) taking value of either 0 or 1. I have another variable of deciles (named decile) taking value from 0 to 9. I am trying to find out the mean of CR within each decile. I did the following:

proc means data= DATA. CR mean;

var CR;

by decile;

run;

quit;

Can you please let me know what am I doing wrong since I am not getting the desired output?

Thank you.

Re: Mean by group

PaigeMiller — Sun, 15 Sep 2019 21:53:40 GMT

Looks like the code should work. What is wrong with the results? Please be very specific and show us the results so we can see what you are seeing.

Re: Mean by group

Astounding — Sun, 15 Sep 2019 23:51:39 GMT

The main thing you're doing wrong is not reading the log to see what messages SAS is giving you. Nobody here can figure that out, so it would be a good idea to post the log.

Here's a small list of relevant items to consider:

You have a space in the middle of DATA. CR where there shouldn't be any spaces
Is the name of your data set CR?
Is your data set saved permanently? If so, do you know how to write a LIBNAME statement to refer to the folder where it resides?

Re: Mean by group

PeterClemmensen — Mon, 16 Sep 2019 05:53:33 GMT

@sanrim hi and welcome to the SAS Community 🙂

Can you post some sample of your data and what you want the desired result to look like? Makes it much easier for you to demonstrate what you mean and much easier for us to provide a usable code answer.

Re: Mean by group

sanrim — Mon, 16 Sep 2019 15:08:01 GMT

Thank you for the reply. I was able to solve the issue by sorting the deciles in ascending order.