Hi, thanks so much for your help and informing me of proper etiquette as I am still learning.. I tried to use the macro using the instructions you provided to paste share into here but ran into some issues so I am just going to paste what I have here.   I tried a few variations of what you you suggested and I was able to get total number of votes for each state. But what if I want so summarize total number of rep+lib votes for each state? DATA PARTYSORT (keep=state county party total_votes); set NEWMIT; run; PROC SUMMARY nway data=PARTYSORT; class party; format $partyf.; output out=sum_data sum=; run;  I apologize if I'm being a bit difficult. ... View more

Thanks so much for your reply. I am new to stats and sas and appreciate your kindness.   I am using data from a big set originally called NewMIT hence the NEWMIT set.   DATA PARTYSORT (keep=state county party total_votes); set NEWMIT; run; *this gives me close to what I want but also gives every single party sum for each state. I want to see rep and lib only eventually and those two added together; proc freq data=partysort; table state*party; weight total_votes; run; *tried this but it just gives total votes per state; PROC SUMMARY data=partysort; by state; var $partyf; output out=PROCSUM sum=; run; PROC PRINT data=procsum; run; *I've also tried a proc means by state but it doesn't list sums in the output; PROC MEANS data=partysort; class state; var total_votes; output out=sumofvotesstate sum (total_votes)=sum1; run; None of this is giving me exactly what I want, which is really just a way to summarize the fraction of votes going toward rep and lib. ... View more