Hi - My current data looks like this: id name cell1 cell2 cell3 .... cell10 1 a 1 1 1 1 a 1 1 2 b 1 1 2 b 1 1 I want to sum cell1-cell10 by id and by name, the ideal output is like this, when performing calculation, for the missing data, missing + missing should be left as missing, and missing + 1 should be equal to 1: id name cell1 cell2 cell3 ... cell10 1 a 2 1 1 1 2 b 1 2 1 I tried this approach first but it is really slow and make sas stops running: proc means data =data;
var cell1-cell10;
output out = want (drop = _type_ _freq_)
sum(cell1-cell10) = cell1-cell10;
by id name;
run; I think sql might be better but my current code does not work: proc sql;
create table want as
select id, name, cell1-cell10, sum(cell1-cell10) as sum_cell1-sum_cell10
from data
group by id and name;
quit;
run; Any idea? Thanks!!!
... View more