topic Re: Calculating mean in SAS Programming

Calculating mean

Magdalena56 — Sun, 03 Nov 2019 14:11:12 GMT

Hi! I am stuck with the following: trying to calculate mean population for each state in 1910-2010 using sashelp.us_data. I also want to keep the following variables displayed: statename, avg_population and population_xxxx.

data usa;
set sashelp.us_data;
avg_population=mean(of population_1910-population_2010);
keep statename avg_population population_1910-population_2010;
run;

avg_population creates new variables such as population_1911, 1912 etc.

Anyone can help?

Thanks a lot!

Re: Calculating mean

Shmuel — Sun, 03 Nov 2019 14:18:44 GMT

Please post sample data - few observations and relevant variables - of sashelp.us_data,

as it is not available on SAS UE.

Re: Calculating mean

Magdalena56 — Sun, 03 Nov 2019 14:22:26 GMT

Thanks! Posting sample data:

Re: Calculating mean

unison — Sun, 03 Nov 2019 15:35:40 GMT

This might work, I also don't have US_DATA in UE.

data usa(keep=statename population: avg_population);
	set sashelp.us_data;
	avg_population = mean(of POPULATION:);
run;

-unison

edit to simplify.

Re: Calculating mean

Magdalena56 — Sun, 03 Nov 2019 15:21:34 GMT

It worked well but to simplify I did (based on your suggestion):

data usa;
set sashelp.us_data;
avg_population=mean(of POPULATION: );
keep avg_population statename population_1910-population_2010;
run;

Thanks a lot!

Re: Calculating mean

Kurt_Bremser — Sun, 03 Nov 2019 15:33:21 GMT

Please do not post pictures of data, as that would force us to waste time typing data off the screen item by item.

Post data in a data step with datalines like

data have;
input string $ date :yymmdd10. number;
format date yymmddd10.;
datalines;
A 2019-11-02 1
B 2019-11-03 2
;