Hello @icrandell,
Another option: Use the COUNT function:
data want;
do until(last.id);
set have;
by id;
n1=sum(n1,count('#'||catx('##',of x1--x3)||'#','#1#'));
end;
run;
If the "x values" are only one-digit integers, the definition of n1 could be simplified to
n1=sum(n1,count(cats(of x1--x3),'1'));
The "double dash" variable list does not rely on common name prefixes, but on the variables' positions in the PDV. Alternatively, you could define and use an array.
... View more
