https://communities.sas.com/t5/New-SAS-User/How-to-calculate-a-new-number-using-numbers-from-one-variable/m-p/901642#M40198 <P>Thiis is exactly what <A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p0jvbbqkt0gs2cn1lo4zndbqs1pe.htm" target="_self">PROC SUMMARY</A>&nbsp;(alias PROC MEANS) was designed to do:</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc summary data=have nway; vars adult_pop; class count; output out=want (drop=_type_) sum=total_adult_pop; run;</CODE></PRE> <P>&nbsp;</P> Sun, 05 Nov 2023 22:55:54 GMT mkeintz 2023-11-05T22:55:54Z https://communities.sas.com/t5/New-SAS-User/How-to-calculate-a-new-number-using-numbers-from-one-variable/m-p/901639#M40196 <P>Sorry about the complicated title. For my data (previewed below), I am looking to find the adult_pop number for each county. For example, for Rio Blanco county, I am looking for a way to ask SAS to add 4381 + 1190 + (any other adult_pop numbers for the county) and tell me the total adult_pop for the county. There are over 1,000 lines of code in the data set. What is a simple way to code this? Thanks</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-11-05 at 3.26.08 PM.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/89433i08EE24E0712DF78B/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2023-11-05 at 3.26.08 PM.png" alt="Screenshot 2023-11-05 at 3.26.08 PM.png" /></span></P> Sun, 05 Nov 2023 22:32:29 GMT https://communities.sas.com/t5/New-SAS-User/How-to-calculate-a-new-number-using-numbers-from-one-variable/m-p/901639#M40196 BLT2023 2023-11-05T22:32:29Z https://communities.sas.com/t5/New-SAS-User/How-to-calculate-a-new-number-using-numbers-from-one-variable/m-p/901642#M40198 <P>Thiis is exactly what <A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p0jvbbqkt0gs2cn1lo4zndbqs1pe.htm" target="_self">PROC SUMMARY</A>&nbsp;(alias PROC MEANS) was designed to do:</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc summary data=have nway; vars adult_pop; class count; output out=want (drop=_type_) sum=total_adult_pop; run;</CODE></PRE> <P>&nbsp;</P> Sun, 05 Nov 2023 22:55:54 GMT https://communities.sas.com/t5/New-SAS-User/How-to-calculate-a-new-number-using-numbers-from-one-variable/m-p/901642#M40198 mkeintz 2023-11-05T22:55:54Z