- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 11-03-2011 01:59 PM
(887 views)
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??
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?