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
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);
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);
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.