Help using Base SAS procedures

How to create a weighted count using frequency of observations?

Reply
New Contributor
Posts: 2

How to create a weighted count using frequency of observations?

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

PROC Star
Posts: 7,487

How to create a weighted count using frequency of observations?

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?

Ask a Question
Discussion stats
  • 1 reply
  • 121 views
  • 0 likes
  • 2 in conversation