topic Re: how to get a mean of a variable for each subject in a repaet data set in SAS Programming

how to get a mean of a variable for each subject in a repaet data set

xinjian — Mon, 13 Jul 2015 18:53:05 GMT

Dear all,

here is my data set:

A B C

1 3 120

1 6 110

1 9 140

2 3 110

2 6 105

3 3 118

4 3 160

4 6 170

4 9 180

4 12 110

A is ID, B is month, C is systolic blood pressure. I want to average blood pressure for each ID. Is there a simple way?

Thanks,

Xinjian

dcruik — Mon, 13 Jul 2015 18:55:53 GMT

I would use the MEANS procedure with a class variable:

proc means data=have mean nway noprint;

var C;

class A;

output out=want (drop=_TYPE_ _FREQ_)

mean=Avg_Blood_Pressure;

run;

Hope this helps!

stat_sas — Mon, 13 Jul 2015 19:42:25 GMT

proc sql;

select a as id,avg(c) as average_blood_pressure format=8.2 from have

group by a;

quit;

xinjian — Mon, 13 Jul 2015 19:56:23 GMT

I really appreciate your help.

Also, thank you, dcruik, for your quick response, and different version to solve this problem.