summing up rows

Shirin — Thu, 18 Apr 2013 17:35:34 GMT

Hello,

I have a data set that looks like this:

First_Name Last_name City ID Vote1 Vote2

Jennifer Law TO ID1 5 7

Sarah Ronalds OT ID2 3 4

Sarah Ronalds OT ID2 5 6

And I want this:

First_Name Last_name City ID Vote1 Vote2

Jennifer Law TO ID1 5 7

Sarah Ronalds OT ID2 8 10

I have many character variables such as First_Name and Last_Name that are repeats and I have many numercial variables like Vote1 and Vote2 which need to be summed per ID.

Many thanks

Shirin

Re: summing up rows

ballardw — Thu, 18 Apr 2013 17:41:03 GMT

I would start with

Proc summary data=<your data set name here> nway;

class First_name Last_name City ID; /* or other combination*/

var vote1 vote2 ; /* you can use variable lists, you may want _numeric_ to add all of them*/

output out=<name your output data set here> sum=;

run;

You may want to add option (drop=_type_ _freq_) after the output set as these are automatic variables added by summary (or means);

topic summing up rows in SAS Programming

summing up rows

Re: summing up rows