topic How to create a weighted count using frequency of observations? in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/How-to-create-a-weighted-count-using-frequency-of-observations/m-p/41216#M10648 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Thu, 03 Nov 2011 19:00:28 GMT art297 2011-11-03T19:00:28Z How to create a weighted count using frequency of observations? https://communities.sas.com/t5/SAS-Procedures/How-to-create-a-weighted-count-using-frequency-of-observations/m-p/41215#M10647 <HTML><HEAD></HEAD><BODY><P>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 &gt; 500 is weighted as a 2. And "social event" attendance is weighted as .5. "Volunteerism" is weighted as a 2.</P><P></P><P>How do I combine all these to get one count output??</P></BODY></HTML> Thu, 03 Nov 2011 17:59:46 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-create-a-weighted-count-using-frequency-of-observations/m-p/41215#M10647 acm246 2011-11-03T17:59:46Z How to create a weighted count using frequency of observations? https://communities.sas.com/t5/SAS-Procedures/How-to-create-a-weighted-count-using-frequency-of-observations/m-p/41216#M10648 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Thu, 03 Nov 2011 19:00:28 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-create-a-weighted-count-using-frequency-of-observations/m-p/41216#M10648 art297 2011-11-03T19:00:28Z