topic Re: assign sum group wise in SAS Programming

assign sum group wise

thanikondharish — Thu, 23 Aug 2018 16:19:02 GMT

data have;
input mem $ frequency percent;
datalines;
M 240 24.0
M 320 32.0
F 120 12.0
M 80 8.0
C 68 6.8
M 42 4.2
C 130 13.0
;
run;

HOW TO DO SUM BY MEM(GROUP VARIABLE) WISE IN DATA STEP BLOCK?

GROUP VARIABLE IS MEM LIKE SEE BELOW

EX1:

mem	frequency	percent
C	68	6.8
C	130	13
C	198	19.8
F	120	12
M	42	4.2
M	80	8
M	240	24
M	320	32
M	682	68.2

EX2:

mem	frequency	percent
C	68	6.8
C	130	13
TOTAL	198	19.8
F	120	12
M	42	4.2
M	80	8
M	240	24
M	320	32
TOTAL	682	68.2

Re: assign sum group wise

PeterClemmensen — Thu, 23 Aug 2018 16:42:22 GMT

I don't understand what your desired result would look like?

Though probs for providing sample data in the form of a data step! 🙂

Re: assign sum group wise

novinosrin — Thu, 23 Aug 2018 16:49:26 GMT

@PeterClemmensen OP wants the by group sum in green

mem	frequency	percent
C	68	6.8
C	130	13
C	198	19.8
F	120	12
M	42	4.2
M	80	8
M	240	24
M	320	32
M	682	68.2

EX2:

mem	frequency	percent
C	68	6.8
C	130	13
TOTAL	198	19.8
F	120	12
M	42	4.2
M	80	8
M	240	24
M	320	32
TOTAL	682	68.2

to be computed using datastep and output to 2 different datasets one having the group's name at the end of each by group and the other having Total as the label. Straight forward retain(sum statement) and reinitialise to zero at the top of each by group. I am just too lazy, may be you can chime in 🙂

Re: assign sum group wise

Reeza — Thu, 23 Aug 2018 17:14:15 GMT

@novinosrin Or go back a few steps and get the totals from whatever proc generated the freq/percent in the first place rather than manually modify it. Just a caution with adding percents, you can't always just 'add' them depending on the context and interpretation.

Re: assign sum group wise

novinosrin — Thu, 23 Aug 2018 17:17:05 GMT

@Reeza Absolutely. That's great attention to detail. Nice.