Sentinel Routine Querying Tool Report Documentation
Public
Commits
Andrew Simon authored 415c3f85a0c
| 6 6 | |
| 7 7 | The Baseline File is optional. It should be specified if a baseline table is requested for any groups. The file enables users to customize the baseline table in the report. This file should contain 1 row per group. Table 1 contains detailed specifications for this file. |
| 8 8 | |
| 9 9 | **Table 1: BASELINEFILE specification** |
| 10 10 | |
| 11 11 | | **Parameter** | **Field Name** | **Description** | |
| 12 12 | | --- | --- | --- | |
| 13 13 | |GROUP/ANALYSISGRP/MILGRP to output|GROUP|Name of each cohort, analysis or mother-infant linkage group name to include in report. <br> <br> **Note 1:** GROUP must correspond to values of GROUP/ANALYSISGRP/MILGRP included in file distributed input files. <br><br> **Note 2:** GROUP cannot be left blank. <br><br> **Note 3:** if MILGRP is specified, both exposure and reference cohorts are included in table. <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 | |Run identifier|RUNID|RunID assigned to the run that corresponds to the group name listed in GROUP. <br> <br> **Note 1:** RUNID must be equivalent to value specified in the distributed component of the request. <br><br> **Format:** SAS character $3 <br> **Example:** r01| |
| 15 15 | |Group display order|ORDER|Order to display groups in report. If baseline tables for any groups are requested to appear on the same tab, they should be specified with the same ORDER value and BASELINEGROUPNUM must be specified. <br> <br> **Format:** Numeric <br> **Example:** 1| |
| 16 - | |Order of Baseline Tables to Appear on Same Tab|BASELINEGROUPNUM| Specifies order of baseline tables to appear on the same tab in report. BASELINEGROUPNUM order is applied to all GROUPs with the same value of ORDER. For example, the specification of GROUP, ORDER, and BASELINEGROUPNUM below would result in the GROUP A baseline table appearing on the Table 1a tab, the GROUP B and GROUP C baseline tables appearing on the Table 1b tab, and the Group D baseline table appearing on Table 1c tab.<br><br><pre>GROUP ORDER BASELINEGROUPNUM <br>A 1 .<br>B 2 1 <br>C 2 2 <br>D 3 . </pre><br>**Note 1:** for any group with a baseline table appearing on its own tab (i.e. one baseline table per tab), leave this field blank. <br><br>**Note 2:** BASELINEGROUPNUM values must be specified consecutively.<br><br> **Note 3:** if requesting two tables on the same tab, all BASELINEFILE parameter values applied to the first group are applied to the second group. <br><br> **Note 4:** BASELEINGROUPNUM functionality is restricted to groups within the same run ID.<br><br> **Note 5:** BASELEINGROUPNUM functionality cannot be used with MILGRPs.<br><br> **Format:** Numeric <br> **Example:** 1 | |
| 16 + | |Order of Baseline Tables to Appear on Same Tab|BASELINEGROUPNUM| Specifies order of baseline tables to appear on the same tab in report. BASELINEGROUPNUM order is applied to all GROUPs with the same value of ORDER. For example, the specification of GROUP, ORDER, and BASELINEGROUPNUM below would result in the GROUP A baseline table appearing on the Table 1a tab, the GROUP B and GROUP C baseline tables appearing on the Table 1b tab, and the Group D baseline table appearing on Table 1c tab.<br><br><pre>GROUP ORDER BASELINEGROUPNUM <br>A 1 .<br>B 2 1 <br>C 2 2 <br>D 3 . </pre><br>**Note 1:** for any group with a baseline table appearing on its own tab (i.e. one baseline table per tab), leave this field blank. <br><br>**Note 2:** BASELINEGROUPNUM values must be specified consecutively.<br><br> **Note 3:** if requesting two tables on the same tab, all BASELINEFILE parameter values applied to the first group are applied to the second group. <br><br> **Note 4:** BASELEINGROUPNUM functionality is restricted to groups within the same run ID.<br><br> **Note 5:** BASELEINGROUPNUM functionality cannot be used with MILGRPs.<br><br> **Format:** Numeric <br> **Example:** 1 | |
| 17 17 | |Characteristics to display under "Health Characteristics" heading|HEALTHCHAR|Used to limit characteristics included in baseline tables and to specify which characteristics to include in a "Health Characteristics" section of the tables. Include a list of characteristics to include in this section, separated by a comma. <br><br> Valid values are: <ul><li> **COVAR#:** # corresponds to COVARNUM used for each covariate included in the distributed covariate input file. <li> **COMORBIDSCORE:** Charlson/Elixhauser Combined Comorbidity Score <li> **NUMAV:** Ambulatory encounters <li> **NUMED:** Emergency department encounters <li> **NUMOA:** Other ambulatory encounters <li> **NUMIP:** Inpatient hospital encounters <li> **NUMIS:** Non-acute institutional encounters <li> **NUMCLASS:** Unique drug classes dispensed <li> **NUMGENERIC:** Generics dispensed <li> **NUMRX:** Filled prescriptions </ul></li><br> **Note 1:** if blank, a "Health Characteristics" section will not be included in baseline tables. <br><br> **Note 2:** can use "dash" notation to include range of COVAR# values in numeric order (i.e., COVAR1-COVAR9). <br><br> **Format:** SAS character - length can vary <br> **Example:** COVAR1-COVAR5, COVAR7| |
| 18 18 | |Characteristics to display under "Medical Product Use" heading|MEDPRODUSE |Used to limit characteristics included in baseline tables and to specify which characteristics to include in a "Medical Product Use" section of the tables. Include a list of characteristics to include in this section, separated by a comma.<br><br> Valid values are: <ul><li> **COVAR#:** # corresponds to COVARNUM used for each covariate included in the distributed covariate input file. <li> **COMORBIDSCORE:** Charlson/Elixhauser Combined Comorbidity Score <li> **NUMAV:** Ambulatory encounters <li> **NUMED:** Emergency department encounters <li> **NUMOA:** Other ambulatory encounters <li> **NUMIP:** Inpatient hospital encounters <li> **NUMIS:** Non-acute institutional encounters <li> **NUMCLASS:** Unique drug classes dispensed <li> **NUMGENERIC:** Generics dispensed <li> **NUMRX:** Filled prescriptions </ul></li><br> **Note 1:** if blank, a "Medical Product Use" section will not be included in baseline tables. <br><br>**Note 2:** can use "dash" notation to include range of COVAR# values in numeric order (i.e., COVAR1-COVAR9). <br><br>**Format:** SAS character - length can vary <br> **Example:** COVAR1-COVAR5, COVAR7| |
| 19 19 | |Characteristics to display under "Health Service Utilization Intensity Metrics" heading|UTILIZATIONINTENSITY|Used to limit characteristics included in baseline tables and to specify which characteristics to include in a "Health Service Utilization Intensity Metrics" section of the tables. Include a list of characteristics to include in this section, separated by a comma. <br><br> Valid values are: <ul><li> **COVAR#:** # corresponds to COVARNUM used for each covariate included in the distributed covariate input file. <li> **COMORBIDSCORE:** Charlson/Elixhauser Combined Comorbidity Score <li> **NUMAV:** Ambulatory encounters <li> **NUMED:** Emergency department encounters <li> **NUMOA:** Other ambulatory encounters <li> **NUMIP:** Inpatient hospital encounters <li> **NUMIS:** Non-acute institutional encounters <li> **NUMCLASS:** Unique drug classes dispensed <li> **NUMGENERIC:** Generics dispensed <li> **NUMRX:** Filled prescriptions </ul></li><br> **Note 1:** if blank, a "Health Service Utilization Intensity Metrics" section will not be included in baseline tables. <br><br>**Note 2:** can use "dash" notation to include range of COVAR# values in numeric order (i.e., COVAR1-COVAR9).<br><br>**Format:** SAS character - length can vary <br> **Example:** NUMAV, NUMED, NUMOA, NUMIS, NUMCLASS, NUMGENERIC| |
| 20 20 | |Characteristics to display under "Pregnancy Characteristics" heading|PREGNANCYCHAR|Used to specify which pregnancy-related characteristics to include in a "Pregnancy Characteristics" section of the baseline table. Include a list of characteristics to include in this section, separated by a comma. <br><br> Valid values are: <ul><li> **PREPOSTIND_PRE:** Preterm <li> **PREPOSTIND_TERM:** Term <li> **PREPOSTIND_POST:** Postterm <li> **PREPOSTIND_NONE:** Unknown term <li> **GA_BIRTH:** Estimated gestational age at delivery </li></ul><br> **Note 1:** only relevant for Type 4 analyses. <br><br> **Note 2:** if blank, a "Pregnancy Characteristics" section will not be included in baseline tables. <br><br> **Format:** SAS character - length can vary <br> **Example:** PREPOSTIND_PRE, PREPOSTIND_TERM, PREPOSTIND_POST, PREPOSTIND_NONE, GA_BIRTH| |
| 21 21 | |Characteristics to display under "Exposure Characteristics" heading|EXPOSURECHAR|Used to specify which pregnancy-related exposure characteristics to include in an "Exposure Characteristics" section of the baseline table. Include a list of characteristics to include in this section, separated by a comma. <br> <br> Valid values are: <ul><li> **GA_FIRST:** Gestational age of first exposure, weeks <li> **DISP_PRE:** Number of dispensings in pre-pregnancy period <li> **ADJUSTEDDISP_T1:** Number of dispensings in first trimester <li> **ADJUSTEDDISP_T2:** Number of dispensings in second trimester <li> **ADJUSTEDDISP_T3:** Number of dispensings in third trimester <li> **EXP_T1:** Exposed during first trimester <li> **EXP_T2:** Exposed during second trimester <li> **EXP_T3:** Exposed during third trimester <li> **EXP_PREGPRE:** Exposed during user-defined pre-pregnancy period </li></ul><br> **Note 1:** only relevant for Type 4 analyses. <br><br> **Note 2:** if blank, an "Exposure Characteristics" section will not be included in baseline tables. <br><br> **Format:** SAS character - length can vary <br> **Example:** GA_FIRST, DISP_PRE, ADJUSTEDDISP_T1, ADJUSTEDDISP_T2, ADJUSTEDDISP_T3, EXP_T1, EXP_T2, EXP_T3, EXP_PREGPRE| |
| 22 22 | |Infant characteristics indicator|OUTPUTINFANTCHAR|Indicator for inclusion of an infant section of the baseline table. <br> <br> Valid values are: <ul><li> **Y:** Include an infant section in the baseline table </li><li> **N:** Do not include an infant section in the baseline table </li></ul><br> **Note 1:** only relevant for Type 4 analyses. <br><br> **Format:** SAS character $1 <br> **Example:** Y| |
| 23 23 | |Indicator for inclusion of baseline table for non-pregnant cohort in L1 type 4 analyses|INCLUDENONPREGNANT|Indicator for inclusion of a non-pregnant cohort to the baseline table. <br> <br> Valid values are: <ul><li> **Y:** Include a non-pregnant cohort in the baseline table </li><li> **N:** Do not include a non-pregnant cohort in the baseline table </li></ul><br> **Note 1:** only relevant for Type 4 analyses. <br><br> **Format:** SAS character $1 <br> **Example:** Y| |
| 24 24 | |Covariate sort order|COVARSORT| Character indicator specifying the sort order for covariates in output. <br><br> Valid values are: <ul><li> **A:** Sort by alphabetical order of covariate label </li><li> **C:** Sort by numeric assignment for covariate per contents of file represented by parameter COVARNUM </li><li> **O:** Sort by order that the covariates are specified in the parameters HEALTHCHAR, MEDPRODUSE, UTILIZATIONINTENSITY </ul></li> **Format:** SAS character $1 <br> **Example:** A | |
| 25 25 | |Compute absolute and standardized difference indicator|COMPUTEBALANCE|Compute absolute and standardized difference between cohorts. <br><br> Valid values are: <ul><li> **Y:** Compute absolute and standardized difference <li> **N:** Do not compute absolute and standardized difference </li></ul><br> **Note 1:** only relevant for Type 4 analyses where INCLUDENONPREGNANT = Y or GROUP includes a MILGRP value. <br><br> **Note 2:** for L2 tables, absolute and standardized difference will always be output. <br><br> **Format:** SAS character $1 <br> **Example:** Y | |
| 26 26 | |