Sentinel Routine Querying Tool Report Documentation

​

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.

​

**Table 1: BASELINEFILE specification**

​

| **Parameter** | **Field Name** | **Description** |

| --- | --- | --- |

|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. For Type 6 Manufacturer-level Product Utilization and Switching Patterns analyses, only ANALYSISGRP values can be specified. <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> **Note 4:** unadjusted baseline tables will be de-duplicated by PSESTIMATEGRP (i.e., if the same PSESTIMATEGRP is specified for multiple ANALYSISGRP values in the distributed PS Estimation File, only 1 unadjusted baseline table will be output to avoid duplicate tables in the report). <br><br> **Note 5:** unweighted IPTW baseline tables will be de-duplicated by PSESTIMATEGRP (i.e., if the same PSESTIMATEGRP is specified for multiple ANALYSISGRP values in the distributed PS Estimation File, only 1 unweighted IPTW baseline table will be output to avoid duplicate tables in the report). <br><br> **Note 6:** if baseline tables are de-duplicated (as in Note 4 and Note 5), the BASELINEFILE parameter values for the first unadjusted or unweighted IPTW table specfied in ORDER will be applied to the de-duplicated baseline 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|

|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|

|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|

|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|

|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|

|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|

|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|

|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|

|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|

|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|

|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 |

|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> **Note 3:** COMPUTEBALANCE can be used with BASELINGROUPNUM <br><br> **Format:** SAS character $1 <br> **Example:** Y |

|Standardized difference threshold|SDTHRESHOLD|Threshold for Table 1 standardized difference. Any values above the amount represented by this parameter will be output with font color blue. <br><br> **Note 1:** SDTHRESHOLD value cannot differ for ANALYSISGRPs with the same PSESTIMATEGRP. <br><br> **Format:** SAS Numeric <br> **Example:** 0.1 |