DATA Step, Macro, Functions and more

summing up rows

Accepted Solution Solved
Reply
Contributor
Posts: 22
Accepted Solution

summing up rows

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 Smiley Happy

Shirin


Accepted Solutions
Solution
‎04-18-2013 01:41 PM
Super User
Posts: 10,505

Re: summing up rows

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

View solution in original post


All Replies
Solution
‎04-18-2013 01:41 PM
Super User
Posts: 10,505

Re: summing up rows

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 175 views
  • 1 like
  • 2 in conversation