qrp_report

*                                           PROGRAM OVERVIEW

****************************************************************************************************

*

* PROGRAM: create_lookup.sas  

* Created (mm/dd/yyyy): 03/23/2021

*

*--------------------------------------------------------------------------------------------------

* PURPOSE: This is a standalone program executed prior to qrp_report when there are updates to the lookuptables.

*          The macro creates all files that reside in the lookuptables folder. These are lookuptables used for

*          processing, but cannot be modified by the user.

* 

*  Program inputs:                                                                                   

* 

*  Program outputs: The following lookuptables files are created:

*   -lookup_footnotes = Footnotes for baseline, effect estimates, KM/CDF, concomitant use, and censor tables

*   -lookup_attrition = Mapping QRP attrition descriptions to report descriptions

*

*  PARAMETERS:                                                                       

*            

*  Programming Notes:                                                                                

*                                                                           

*

*--------------------------------------------------------------------------------------------------

* CONTACT INFO: 

*  Sentinel Coordinating Center

*  info@sentinelsystem.org

*

***************************************************************************************************;

​

 /* Define libname for location of templatefiles folder */

  libname lookup "";

  options noquotelenmax;

  %macro create_lookup();

     data lookup.lookup_footnotes;

       attrib type         length = $10  format = $10. 

              order        length = 3    format = 3.

              description  length = $575 format = $575.;

​

       /* Footnotes for in Type 4 tables - applied to multiple tables*/

      type = "type4"; order = -2;  description = "Pregnancy is defined as a pregnancy that resulted in a live birth delivery identified using the method specified in the overview section of this report."; output;

      type = "type4"; order = -1;  description = "The non-pregnancy cohort includes patients without live birth deliveries or non-live birth outcomes during the pregnancy episode of the matched pregnant patient, who met all inclusion/exclusion criteria and were the same integer age on the last date of the matched pregnant patient's pregnancy episode."; output;

​

       /* Footnotes for baseline table */

      type = "baseline";  order = 1;  description = "All metrics are based on total number of episodes per group, except for sex, race, and Hispanic origin which are based on total number of unique patients."; output;

      type = "baseline";  order = 2;  description = "&covar_characteristic. in blue show a standardized difference greater than &sdthreshold.."; output;

      type = "baseline";  order = 4;  description = "Weighted patient characteristics tables facilitate the assessment of covariate balance after propensity score (PS) stratum weighting and should not be interpreted as a description of the unweighted population. Treated/control patients are weighted by the proportion of the total patient population included in their PS stratum divided by the proportion of the total treated/control patient population included in their PS stratum."; output;

      type = "baseline";  order = 5;  description = "Weighted patient characteristics tables facilitate the assessment of covariate balance after propensity score (PS) stratum weighting and should not be interpreted as a description of the unweighted population. Treated patients are assigned a weight of 1, and control patients are weighted by the proportion of the total treated patient population included in their PS stratum divided by the proportion of the total control patient population included in their PS stratum."; output;

      type = "baseline";  order = 6;  description = "Weighted patient characteristics tables facilitate the assessment of covariate balance after propensity score (PS) stratification and should not be interpreted as a description of the unweighted population. Treated/control patients are weighted by the proportion of the total patient population included in their PS stratum divided by the proportion of the total treated/control patient population included in their PS stratum."; output;

      type = "baseline";  order = 7;  description = "Weighted patient characteristics tables facilitate the assessment of covariate balance after inverse probability weighting and should not be interpreted as a description of the unweighted population. Treated patients are weighted by the inverse of their propensity score (PS), while reference patients are weighted by the inverse of 1 minus their PS."; output;

      type = "baseline";  order = 8;  description = "Weighted patient characteristics tables facilitate the assessment of covariate balance after inverse probability weighting and should not be interpreted as a description of the unweighted population. Treated patients are weighted by the proportion of treated patients in the trimmed population divided by the inverse of their propensity score (PS). Reference patients are weighted by 1 minus the proportion of treated patients in the trimmed population divided by 1 minus their PS."; output;

      type = "baseline";  order = 9;  description = "Weighted patient characteristics tables facilitate the assessment of covariate balance after inverse probability weighting and should not be interpreted as a description of the unweighted population. Treated patients are assigned a weight of 1. Reference patients are weighted by their propensity score (PS) divided by 1 minus their PS."; output;

      type = "baseline";  order = 10; description = "With variable ratio matching, each exposed subject is matched to a variable number of comparator subjects. The weight for each treated subject equals 1. The weight for each control subject equals the inverse of the matching ratio for that specific matched set."; output;

      type = "baseline";  order = 11; description = "Baseline period in reference to user-defined index date (start of first valid exposed pregnancy resulting in live birth delivery, exposure date, or delivery date)."; output;

      type = "baseline";  order = 12; description = "Value represents the proportion of episodes with first switch."; output;

      type = "baseline";  order = 13; description = "Value represents the proportion of first switch episodes with second switch."; output;

      type = "baseline";  order = 14; description = "Value represents standard deviation where no % follows the value."; output;

      type = "baseline";  order = 15; description = "Race data may not be completely populated at all Data Partners; therefore, data about race may be incomplete."; output;

      type = "baseline";  order = 16; description = 'Includes members classified as having an unknown race by the Data Partner and patients in race categories where the total member count is between one and ten.'; output;

​

       type = "baseline";  order = 17; description = "Pregnancy duration is not classified by term status for pregnancies ending in non-live birth outcomes."; output;     

       type = "baseline";  order = 18; description = "Gestational age estimated using a claims-based algorithm, previously validated in the Medication Exposure in Pregnancy Risk Evaluation Program (MEPREP), to identify pregnancies ending in a live birth. ICD-10-CM diagnosis codes indicative of weeks of gestation, and ICD-9-CM and ICD-10-CM diagnosis codes for pre-term and post-term deliveries, were used to calculate the length of the pregnancy episode. Codes had to occur within 7 days of a delivery date in the inpatient setting. In absence of pre-/post-term codes, pregnancy duration was set to 273 days."; output;

       type = "baseline";  order = 19; description = "Gagne JJ, Glynn RJ, Avorn J, Levin R, Schneeweiss S. A combined comorbidity score predicted mortality in elderly patients better than existing scores. J Clin Epidemiol. 2011;64(7):749-759. Sun JW, Rogers JR, Her Q, Welch EC, Panozzo CA, Toh S, Gagne JJ. Adaptation and validation of the combined comorbidity score for ICD-10-CM. Med Care. 2017;55(12):1046-1051."; output;