Source
9
9
**Table 1. GROUPSFILE specification**
10
10
11
11
| **Parameter** | **Field Name** | **Description** |
12
12
| --- | --- | --- |
13
13
|GROUP/ANALYSISGRP to include in report|GROUP|Name of each cohort or analysis to include in report. <br> <br> **Note 1:** GROUP must correspond to values of COHORTGRP/ANALYSISGRP included in distributed input files. <br><br> **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.<br><br> **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.<br><br>**Format:** SAS character $40; no special characters (e.g., commas, periods, hyphens, spaces, etc.) allowed, and underscores must be used to mark spaces. <br> **Example:** insulin|
14
14
|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. <br><br> **Format:** Numeric <br> **Example:** 1|
15
15
|RunID Corresponding to GROUP|RUNID|RunID assigned to the run that corresponds to the group name listed in GROUP. <br> <br> **Format:** SAS character $5<br> **Example:** r01|
16
16
|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). <br><br> Valid values are: <ul><li> **EXP:** exposure </li><li> **HOI:** health outcome of interest</li><li> **EXP HOI:** exposure and health outcome of interest </ul></li><br>**Format:** SAS character $7 <br> **Example:** EXP|
17
17
|Limit of Code Combinations to Output|TOPNCODEDIST|Option to restrict code distribution results to the top N most frequent code combinations, where TOPNCODEDIST = N. <br><br>**Format:** Numeric <br> **Example:** 10|
18
18
|Include in Figure|INCLUDEINFIGURE|Option to specify whether GROUP should be included in L1 figure(s). <br><br> Valid values are: <ul><li> **Y:** Include in figure <li> **N:** Do not include in figure </ul></lu><br> **Format:** SAS character $1 <br> **Example:** Y|
19
-
|Include Negative Time|INCLUDENEGATIVETIME|Option to specify whether to include negative time in Type 6 tables and figures. <br><br> Valid values are: <ul><li> **Y:** Include negative time <li> **N:** Do not include negative time </ul></lu><br> **Format:** SAS character $1 <br> **Example:** Y|
19
+
|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. <br><br> Valid values are: <ul><li> **Y:** Include negative time <li> **N:** Do not include negative time </ul></lu><br> **Format:** SAS character $1 <br> **Example:** Y|
20
20
21
21
22
22
<br>
23
23
<br>
24
24
________________________________________________________________
25
25
26
26
27
27
<br>