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??