Calculating the sum of two records and just keeping the sum record.

[RAVI2000]

Hello everyone,

I have armcd, response and their respective counts. I want to create a new value TOTAL by adding the counts of the responses (1,2).

Thanks

[PaigeMiller · Accepted solution]

proc summary data=have;
    class armcode;
    var count;
    output out=want sum=;
run;

[HB]

Or if you want:

data table1;
   input armcode response count;
datalines;
1 1 0
1 2 1
2 1 0
2 2 0
;
run;

proc sql;
	select armcode, sum(count)
	from table1
	group by armcode
	order by armcode;
quit;

armcode
1	1
2	0