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);
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.