topic Re: Obtain the general mean in data set by categories in SAS Procedures

Obtain the general mean in data set by categories

jonatan_velarde — Sun, 13 Dec 2015 23:06:22 GMT

good night:

i have this table:

data have;
input Animal age weight;
cards;

1	11	10
1	21	10.2
1	31	10.21
1	41	10.22
1	45	10.45
1	50	10.6
2	43	11
2	45	11.3
2	49	11.35
2	60	11.3
2	65	12.2
2	70	12.5
2	76	12.65
2	80	13
2	95	14
2	105	16
3	25	10

;

and i need to obtain the mean of the observations, please note that the animal number 3 is alone, so i need to use this exac value to create a table like this:

Animal	Weight_Avegare
1	10.28
2	12.53
3	10.00

Thank you very much

Re: Obtain the general mean in data set by categories

Reeza — Sun, 13 Dec 2015 23:24:03 GMT

Use the CLASS or BY statement in proc means/univariate/summary or a PROC SQL.
Here's a sample of the two ways.

proc means data=have noprint;
class animal;
var weight;
output out=want1 mean(weight)=mean;
run;

proc sql;
create table want2 as
select animal, mean(animal) as mean_animal
from have
group by animal
order by animal;
quit;

Re: Obtain the general mean in data set by categories

jonatan_velarde — Sun, 13 Dec 2015 23:28:46 GMT

Good ight and thank you for the answer, but unhappily did not work. i tested and i obtained:

Animal mean_animal
1 1
2 2
3 3

Re: Obtain the general mean in data set by categories

jonatan_velarde — Sun, 13 Dec 2015 23:29:50 GMT

the correct command is:

proc means data=have noprint;
class animal;
var weight;
output out=want1 mean(weight)=mean;
run;

proc sql;
create table want2 as
select animal, mean(weight) as mean_animal
from have
group by animal
order by animal;
quit;

Thank you very much

Re: Obtain the general mean in data set by categories

Steelers_In_DC — Mon, 14 Dec 2015 16:29:30 GMT

Here is a solution:

data have;
input Animal age weight;
cards;
1    11    10
1    21    10.2
1    31    10.21
1    41    10.22
1    45    10.45
1    50    10.6
2    43    11
2    45    11.3
2    49    11.35
2    60    11.3
2    65    12.2
2    70    12.5
2    76    12.65
2    80    13
2    95    14
2    105 16
3    25    10
;

proc sql;
create table want as
select animal,avg(weight) as Weight_Average
from have
group by animal;