topic Re: Calculating the sum of two records and just keeping the sum record. in SAS Programming

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

RAVI2000 — Thu, 18 Nov 2021 19:04:39 GMT

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

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

PaigeMiller — Thu, 18 Nov 2021 19:08:51 GMT

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

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

HB — Thu, 18 Nov 2021 20:20:10 GMT

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