topic Re: Mean of all observation in a separate column in SAS Procedures

Mean of all observation in a separate column

podarum — Fri, 15 Jun 2012 15:12:56 GMT

Hi, is there a way I can calculate the mean for a column and display it consistently throughout each observation.. here's what I mean

HAVE:

Var1 Var2

DE 3

LM .

SE 5

WANT:

Var1 Var2 MEAN

DE 3 4

LM . 4

SE 5 4

Thanks

Re: Mean of all observation in a separate column

Linlin — Fri, 15 Jun 2012 15:31:55 GMT

How about:

data have;

infile cards missover;

input Var1 :$ Var2;

cards;

DE 3

LM .

SE 5

;

proc sql;

create table want as

select *,mean(var2) as mean

from have;

quit;

proc print;run;

Linlin

Re: Mean of all observation in a separate column

podarum — Fri, 15 Jun 2012 15:44:37 GMT

Thanks Linlin, it works perfectly

Re: Mean of all observation in a separate column

Linlin — Fri, 15 Jun 2012 17:29:40 GMT

then should you mark my answer as correct answer instead of yours?

Re: Mean of all observation in a separate column

podarum — Fri, 15 Jun 2012 20:18:44 GMT

I'm not so savy in proc sql, but how could I create anew field in the same procedure that calculates the difference between Mean and Var2 ? Thanks

Re: Mean of all observation in a separate column

Linlin — Fri, 15 Jun 2012 22:08:44 GMT

Yes,sure.

data have;

infile cards missover;

input Var1 :$ Var2;

cards;

DE 3

LM .

SE 5

;

proc sql;

create table want as

select *,mean(var2) as mean,calculated mean-var2 as diff

from have;

quit;

proc print;run;

Linlin