You can use the merge column post the code to sum the sales accordingly. data have; input year company $1. takeover :$1. sales; datalines; 1 A . 100 1 B . 120 1 C . 130 1 D . 140 1 E . 150 2 A . 105 2 B . 125 2 C . 135 2 D . 145 2 E . 155 3 B A 240 3 C . 140 3 D . 150 3 E . 160 4 B . 245 4 C D 300 4 E . 170 ; run; data have1; set have; select; when(year=1 and company in('A','B'))do; merge="AandB in 1"; end; when(year=1 and company in ('C','D'))do; merge="CandD in 2"; end; when(year=1 and company="E") do; merge="E in 1"; end; when(year=2 and company in('A','B'))do; merge="AandB in 2"; end; when(year=2 and company in ('C','D'))do; merge="CandD in 2"; end; when(year=2 and company='E')do; merge="E in 2"; end; otherwise; end;
... View more