topic Re: summing two rows in SAS Programming

summing two rows

geneshackman — Fri, 22 Mar 2024 20:30:17 GMT

Should be very simple. I want to sum rows, so instead of each county having two rows, by group 1 and group 2, I get one row by county, with sum, within each county, of group1 and group2. I'm sure it's simple, but I could use help. Thanks very much.

countyA	Group1	23
countyA	Group2	14
CountyB	Group1	34
CountyB	Group2	10
CountyC	Group1	12
CountyC	Group2	18
CountyD	Group1	10
CountyD	Group2	12

CountyA	sum	37
CountyB	sum	44
CountyC	sum	30
CountyD	sum	22

Re: summing two rows

PaigeMiller — Fri, 22 Mar 2024 20:36:56 GMT

proc summary data=have nway;
    class county;
    var yourvarname;
    output out=want sum=;
run;

Re: summing two rows

ballardw — Fri, 22 Mar 2024 20:37:22 GMT

Do you want a data set or a report for people to read:

Proc summary data=have nway;
   class countynamevariable;
   var numbertoaddvariablename;
   output out=want (drop=_type_ _freq_) sum=;
run;

the drop removes some automatic variables that describe the data.

Note if you have multiple variables to sum (or get a mean, std deviation, max, min median) add them to the VAR statement.

Re: summing two rows

geneshackman — Fri, 22 Mar 2024 20:42:11 GMT

Thanks very much!

Re: summing two rows

geneshackman — Fri, 22 Mar 2024 20:44:17 GMT

Thanks very much, Ballardw and Paige.