5.5 Type 5 Figure File Lookup Table Parameters

The Type 5 Figure File lookup table is optional to be specified for a Type 5 analysis. All lookup tables can be found in the Reporting Tool templatefiles folder. The user will download the Reporting Tool, select the Type 5 Figure File lookup table, and edit the relevant parameters directly in the lookup table.

The Figure file is used to specify which figures and corresponding stratifications to produce in the report. The lookup table below is used to map the requested output with the strata level variables necessary to compute the appropriate metrics. Requested strata level variables must be requested in the distributed User-defined Strata Levels Look-up file. Note that only one Figure file that includes all requested output should be specified. Table 2 contains detailed specifications for the Figure File.

Five figures can be requested, as indicated by the FIGURE parameter in the Figure File:

  • F1: t5first = Patient Entry into Study by Month
  • F2: t5first = Number of Prescription Dispensings in Patients’ First Episodes by Month Patient Entered into Study
  • F3: t5first = Total Days Supply in Patients’ First Episodes by Month Patient Entered into Study
  • F4: t5censor = Reasons for End of First Treatment Episode by Group
  • F5: t5censor = End of First Treatment Episode due to [Censoring Reason] by Group

LEVELNUM specifies the number of level ID variables required in order to produce the figure. For example, if LEVELNUM = 1, then the output defined in LEVELID1 is required to be included in the distributed results, but the output defined in LEVELID2 and LEVELID3 is optional and not necessary to output the figure.

Table 5.11: Type 5 Look-up Table Values for All Figures and Stratifications
Figure Dataset Figuresub Levelnum Levelid1 Levelid2 Levelid3 Includeinreport Xmin Xmax Xtick Ymin Ymax Ytick Includeatrisktable Censordisplay
F1 t5first overall 1 mntsfromstart N N
t5first sex 1 mntsfromstart sex N N
t5first agegroup 1 mntsfromstart agegroup N N
t5first race 1 mntsfromstart race N N
t5first hispanic 1 mntsfromstart hispanic N N
F2 t5first overall 1 mntsfromstart N N
t5first sex 1 mntsfromstart sex N N
t5first agegroup 1 mntsfromstart agegroup N N
t5first race 1 mntsfromstart race N N
t5first hispanic 1 mntsfromstart hispanic N N
F3 t5first overall 1 mntsfromstart N N
t5first sex 1 mntsfromstart sex N N
t5first agegroup 1 mntsfromstart agegroup N N
t5first race 1 mntsfromstart race N N
t5first hispanic 1 mntsfromstart hispanic N N
F4 t5censor overall 1 episodenum episodelength N N
F5 t5censor overall 1 episodenum episodelength N N
Table 5.12: T5FIGUREFILE specification
Parameter Field Name Description
Include in Report INCLUDEINREPORT Indicator to output the corresponding figure in the report.
Note 1: to output figures and PS histograms for each ANALYSISGRP both INCLUDEINREPORT and OUTPUTPSDISTRIBUTION (in the L2 Comparison File) must equal Y. If INCLUDEINREPORT = N and OUTPUTPSDISTRIBUTION = Y a warning will be written to the log and no histograms will be output. A histogram will not be output for the specified ANALYSISGRP if INCLUDEINREPORT = Y and OUTPUTPSDISTRIBUTION = N. ”
Valid values are:
  • Y: Output the figure
  • N: Do not output the figure
Format: SAS character $1
Example: Y
Minimum X-Axis Value XMIN The user can optionally specify the minimum x-axis on the CDF or KM plot.
Note 1: the default minimum x-axis value is 0.
Format: Numeric
Example: 50
Maximum X-Axis Value XMAX The user can optionally specify the maximum x-axis on the CDF or KM plot.
Note 1: the default maximum x-axis value is the maximum of the data.
Format: Numeric
Example: 100
X-Axis Tick Marks XTICK The user can optionally specify the distance between x-axis tick marks on the CDF or KM plot.
Note 1: by default there will be 6 x-axis tick marks; the code will determine the tick values.
Note 2: if XMIN = 0, XMAX = 200, and XTICK = 50, this will create x-axis tick values of 0, 50, 100, 150, and 200.
Format: Numeric
Example: 20
Minimum Y-Axis Value YMIN The user can optionally specify the minimum y-axis on the CDF or KM plot.
Note 1: the default minimum y-axis value is 0.
Format: Numeric
Example: 0.80
Maximum Y-Axis Value YMAX The user can optionally specify the maximum y-axis on the CDF or KM plot.
Note 1: the default maximum y-axis value is 1.
Format: Numeric
Example: 0.90
Y-Axis Tick Marks YTICK The user can optionally specify the distance between y-axis tick marks on the CDF or KM plot.
Note 1: the default y-axis tick value is 0.2.
Note 2: if YMIN = 0.5, YMAX = 1, and YTICK = 0.1, this will create y-axis tick values of 0.5, 0.6, 0.7, 0.8, 0.9, and 1.
Format: Numeric
Example: 0.5
Censoring Criteria to Display CENSORDISPLAY List of censoring criteria to display on the CDF or KM plot, separated by a space.
Valid values are:
  • cens_elig
  • cens_dth
  • cens_dpend
  • cens_qryend
  • cens_episend
  • cens_spec
  • cens_event
Note 1: if left blank, all censoring criteria relevant to the figure will be displayed.
Format: SAS character - length can vary
Example: cens_elig cens_dth cens_dpend cens_event
Include At-Risk Table INCLUDEATRISKTABLE Indicator specifying whether to output at-risk table below censoring figure.
Valid values are:
  • Y: Output at-risk table
  • N: Do not output at-risk table
Format: SAS character $1
Example: N