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 ;
... View more
Why not use Proc format to create an informat that you can use to create a variable containing the various weights that you mentioned and then use proc summary to calculate the sum of the weighting variable for each ID?
... View more