summing up rows

[Shirin]

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

[ballardw · Accepted solution]

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);