Find the mean for different observations

[mmea]

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

Y

[PaigeMiller]

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]

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;