topic How to do a weighted count? in SAS Procedures

How to do a weighted count?

acm246 — Wed, 09 Nov 2011 17:14:11 GMT

I have a data set with a list of ID numbers and type of involvement. The types are either "event attendance" or "leadership". I need to create a count for each ID that weights each 'event attendance' as .5 and each "leadership" as 2. How do I do this?

How to do a weighted count?

Tom — Wed, 09 Nov 2011 17:58:56 GMT

Code a new variable and sum that.

data want ;

set have;

if involvement='event attendence' then wt=.5;

else if involvement='leadership' then wt=2;

run;

How to do a weighted count?

ballardw — Wed, 09 Nov 2011 20:02:20 GMT

continuing from last post:

Proc freq data=want;

table involvement;

weight wt;

run;

How to do a weighted count?

Peter_C — Wed, 09 Nov 2011 21:58:31 GMT

and the sql alternative

proc sql ;

create table summary as select id, sum(

case

when involvement='event attendence' then .5

when involvement='leadership' then .2

else 0

end ) as weighted_count

from your_data

group by ID

;

quit ;