As said I have created the macro variables &n1, &n2, &n3.
Can you explain how can I add them to my armcode variable?
*Counting and referencing Distinct subjects for arms;
proc sql;
select max(0, count(distinct usubjid)) into :n1 trimmed
from test
where armcode = 1;
select max(0, count(distinct usubjid)) into :n2 trimmed
from test
where armcode = 2;
select max(0, count(distinct usubjid)) into :n3 trimmed
from test
where armcode = 3;
quit;
%put &n1 &n2 &n3;
They resolve to 3, 0, 0.
Now before the proc report how do I add them to the armcode variable?
... View more
