Frequency Tables - Summary Criteria

Frequency Tables - Summary Criteria - DISP1 Examples

The DISP1 is intended to be used to create frequency tables that define summary criteria, display format and denominator one row at a time. This is primarily intended to be used for disposition tables summarizing populations, or adverse event summaries tabulating frequency of different categories of events.

In order to calculate percentages correctly the input dataset must contain at least one record per subject in the relevant population, as well as applicable column values and pageby as applicable.

Preprocessing (for examples)

%table2(in=pexam0,
proc sort data=adam.adsl out=adsl(rename=(trt01a=trta trt01an=trtan));
   by usubjid;
run;
       
data adsl;
   set adsl;
   by usubjid;
   length dcdecod2 $35;
   rename efffl=fasfl;
   label trtan = 'Treatment for Period 01';
   if trta = 'Xanomeline High Dose' then trta='Xanomeline~High Dose';
   if trta = 'Xanomeline Low Dose' then trta='Xanomeline~Low Dose';
   if not mod(_n_, 71) then saffl='N';
   if saffl='N' or not mod(_n_, 77) then do;
      ittfl='N';
      cumdose=0;
   end;
   if dcdecod='COMPLETED' then dcdecod2='';
   dcdecod2 = catx(' ',propcase(dcdecod),'(c)');
run;