11-03-2011 01:59 PM
I have a data set that contains the number of times alumni were involved in different events. Each alumni has an ID ("emplID"). I need to create a new variable in the data set, "score", that shows how many times each alumni was involved in an event. Any entry is weighted as a 1, a monetary donation > 500 is weighted as a 2. And "social event" attendance is weighted as .5. "Volunteerism" is weighted as a 2.
How do I combine all these to get one count output??
11-03-2011 03:00 PM
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?