topic proc sql avg multiple variables in SAS Programming

proc sql avg multiple variables

gzr2mz39 — Tue, 08 Nov 2011 23:23:53 GMT

I have 10 questions from a survey. Each question has possible values 1-5.

I would like to create the following subscale averages:

questions 1, 2

questions 3, 4, 5

questions 6, 7, 8, 9

questions 10

So, this means there would be a total of 4 means (mean1, mean2, mean3, mean4).

Does anyone know how to do this with proc sql?

Thank you.

FriedEgg — Tue, 08 Nov 2011 23:51:24 GMT

data foo;

call streaminit(12345);

array q[10];

do id=1 to 100;

do i=1 to 10;

q=abs(mod(int(rand('CAUCHY')*10),10));

end;

output;

end;

drop i;

run;

proc sql;

select avg(q1+q2)/2 as avg1, avg(q3+q4+q5)/3 as avg2, avg(q6+q7+q8+q9)/4 as avg3, avg(q10) as avg4 from foo;

quit;

Ksharp — Wed, 09 Nov 2011 03:01:59 GMT

What does your data look like? and what output do you want?

Ksharp