*** ICT total= sum(drugB DrugC DrugE)
*** Total=sum(DrugA DrugB DrugC drugE) (which I know I can do using output option in data setp)
*** (xx.x)percentage = xx/N
***N= Bign count for each coulnm(N=XXX)
Can anyone help me to calculate for ‘ICT Total column’ counts. (5th column)
I need to calculate 5th column count for header which is (N=XXX) and table count which is xx(xx.x).
I am currently doing as follow. But is there any other way to do this instead of doing two proc sql and data set statement.
data dataB;
set dataA;
output;
trtp='Total';
output;
run;
proc sql;
create table bign as
select count(distinct subjid) as nsize, trtp
from dataB
WHERE TRTP NE ''
GROUP BY TRTP;
quit;
proc sql;
create table aa as
select sum(nsize) as nsize, 'ICT' as trtp
from bign
where trtp not in ('Total','DrugA');
quit;
data bign1;
set bign aa;
run;
PROC SORT DATA=BIGN1;BY TRTP;RUN;
Accepted Solutions
