How to calculate a new number using numbers from one variable narrowed down by another?

[BLT2023]

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

[mkeintz · Accepted solution]

Thiis is exactly what PROC SUMMARY (alias PROC MEANS) was designed to do:

proc summary data=have nway;
  vars adult_pop;
  class count;
  output out=want (drop=_type_) sum=total_adult_pop;
run;