3.3 Groups File
The Groups file is optional. This file must be specified if tables or figures are requested (using the Table File and/or Figure File) or if OUPTVIEWSDATA=Y and REPORTTYPE=T1 or T2L1 in the Create Report file. This file defines the cohort or analysis groups to include in the report and their order. Table 3.5 contains detailed specifications for this file.
Parameter | Field Name | Description |
---|---|---|
GROUP/ANALYSISGRP to include in report | GROUP | Name of each cohort or analysis to include in report. |
Note 1: GROUP must correspond to values of COHORTGRP/ANALYSISGRP included in distributed input files. | ||
Note 2: for Type 6 (Manufacturer-Level Product Utilization and Switching Pattern) reports, include COHORTGRP values if requesting medical product utilization tables and/or ANALYSISGRP values if requesting switching tables. | ||
Note 3: all GROUP values must be unique from all other GROUP and ANALYSISGRP values. The same GROUP cannot be used in more than one run of the query request package. | ||
Format: SAS character $40; no special characters (e.g., commas, periods, hyphens, spaces, etc.) allowed, and underscores must be used to mark spaces. | ||
Example: insulin | ||
Group Display Order | ORDER | Unique number for each group. This is used to determine the order of groups in the report. All groups should receive a unique ORDER value. ORDER values should start at 1 and be contiguous. |
Format: Numeric | ||
Example: 1 | ||
RunID Corresponding to GROUP | RUNID | RunID assigned to the run that corresponds to the group name listed in GROUP. |
Format: SAS character $5 | ||
Example: r01 | ||
Distribution of Exposure or Outcome Codes | CODEDIST | Identifier for whether to report distribution of index-defining codes, outcome-defining codes, or both for specified GROUP (if requesting code distribution results). |
Valid values are:
|
||
Note 1: leave blank if DISTINDEX = N or if code distribution output is not requested. | ||
Format: SAS character $7 | ||
Example: EXP | ||
Limit of Code Combinations to Output | TOPNCODEDIST | Option to restrict code distribution results to the top N most frequent code combinations, where N is the number of results desired. |
Note 1: if CODEDIST is blank, then TOPNCODEDIST should be left blank. | ||
Note 2: if CODEDIST is specified and TOPNCODEDIST is left blank, the code distribution results will be restricted to all combinations that contain the 25 most frequent unique codes. | ||
Format: Numeric | ||
Example: 10 | ||
Include in Figure | INCLUDEINFIGURE | Option to specify whether GROUP should be included in L1 figure(s). |
Valid values are:
|
||
Format: SAS character $1 | ||
Example: Y | ||
Include Negative Time | INCLUDENEGATIVETIME | Option to specify whether to include negative time to switch, negative product uptake, and negative duration in Type 6 tables and figures. |
Valid values are:
|
||
Format: SAS character $1 | ||
Example: Y |