topic Find the mean for different observations in New SAS User

Find the mean for different observations

mmea — Wed, 16 Dec 2020 16:00:37 GMT

Hi. I have this data set (example)

City days
X 0
X
X 5
Y 1
Y 3
Y 7

How can i make a new column with the mean days for each city even though i have missing values ?

I want this out out

City mean
X 2.5
Y 3.5

PaigeMiller — Wed, 16 Dec 2020 16:10:19 GMT

PROC MEANS or PROC SUMMARY will do the calculations and properly ignore the missings, and allow you to create the new data set.

proc summary data=have nway;
    class city;
    var days;
    output out=want mean=;
run;

Angel_Larrion — Wed, 16 Dec 2020 17:26:40 GMT

The mean function ignores missing values, so you can use it in a proc sql to obtain what you want.

proc sql;
create table want as
select city , mean(days) as mean from have
group by city;
quit;