https://communities.sas.com/t5/SAS-Programming/How-to-sum-rows-of-a-variable-based-on-another-variable/m-p/943552#M369797 <P>This is awesome. Thank you so much. My boss and I thank you. xD</P> Wed, 11 Sep 2024 18:34:38 GMT joachimg 2024-09-11T18:34:38Z https://communities.sas.com/t5/SAS-Programming/How-to-sum-rows-of-a-variable-based-on-another-variable/m-p/943545#M369795 <P>Hi all. I am looking at hospitalization data and have columns for the county FIPS code that the hospital is in and the number of hospitalizations for a given month and year. I have multiple rows (hospitals) that exist in the same county. I want to sum the total number of hospitalizations per county.</P> <P>This is what I have:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; This is what I want:</P> <P>county_fips | month | year | hospitalizations&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;county_fips | month | year | hospitalizations_sum</P> <P>01001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15</P> <P>01001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P> <P>01001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P> <P>01002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P> <P>01002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4</P> <P>&nbsp;</P> <P>I am at a loss for how to make this happen. Any help is appreciated!&nbsp;</P> Wed, 11 Sep 2024 17:58:29 GMT https://communities.sas.com/t5/SAS-Programming/How-to-sum-rows-of-a-variable-based-on-another-variable/m-p/943545#M369795 joachimg 2024-09-11T17:58:29Z https://communities.sas.com/t5/SAS-Programming/How-to-sum-rows-of-a-variable-based-on-another-variable/m-p/943547#M369796 <P>PROC SUMMARY is the perfect tool for this</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc summary data=have nway; class county_fips month year; var hospitalizations; output out=want sum=<SPAN>hospitalizations_sum</SPAN>; run;</CODE></PRE> Wed, 11 Sep 2024 18:07:53 GMT https://communities.sas.com/t5/SAS-Programming/How-to-sum-rows-of-a-variable-based-on-another-variable/m-p/943547#M369796 PaigeMiller 2024-09-11T18:07:53Z https://communities.sas.com/t5/SAS-Programming/How-to-sum-rows-of-a-variable-based-on-another-variable/m-p/943552#M369797 <P>This is awesome. Thank you so much. My boss and I thank you. xD</P> Wed, 11 Sep 2024 18:34:38 GMT https://communities.sas.com/t5/SAS-Programming/How-to-sum-rows-of-a-variable-based-on-another-variable/m-p/943552#M369797 joachimg 2024-09-11T18:34:38Z