adding values with matching variable name

[jesspurse]

Hi, I have data with number of hours worked and county FIPS code. There are 3214 observations, and I want to add all the hours worked together for each county.

data ctyhoursworked1;
set data;
keep hoursworked CountyC1;
run;
proc sort data=ctyhoursworked1 out=ctyhoursworked2 nodupkey;
by CountyC1;
run;

This gives me the number of observations in each county but does not add each observation value together. CSV file from the first command is attached.

[novinosrin]

I think you are after proc means/summary/sql

[Astounding · Accepted solution]

Get rid of NODUPKEY.  It will remove some observations, and you need all of the observations to add up the HOURSWORKED values.

Actually get rid of the entire PROC SORT.  It isn't needed to add up numbers.  Here's a possibility:

proc summary data=have nway;

var hoursworked;

class CountyC1;

output out=want (keep=CountyC1 total_hoursworked) sum=total_hoursworked;

run;

[jesspurse]

Thanks! This worked perfectly.