****************************************************************************************************
* 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 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
*--------------------------------------------------------------------------------------------------
* Sentinel Coordinating Center
* info@sentinelsystem.org
***************************************************************************************************;
/* Define libname for location of templatefiles folder */
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 or non-live birth identified using the method specified in the overview section of this report."; output;
type = "type4"; order = -1; description = "The non-pregnant cohort includes episodes with neither live nor non-live birth outcomes (including live-birth delivery, stillbirth, ectopic pregnancy, spontaneous abortion, induced abortion, or trophoblastic disease) during the pregnancy episode of the matched pregnant patient, 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 = -4; description = "Covariate included in the propensity score logistic regression model."; output;
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 = "The length of the pregnancy episode was estimated using a hierarchy of pregnancy markers. If overlapping pregnancy episodes were constructed in the same patient due to observation of multiple pregnancy markers, then the markers providing more reliable estimation of pregnancy start was selected for estimation of pregnancy start date. If no pregnancy markers were observed, then a fixed pregnancy duration was assigned by pregnancy outcome type, as described in the overview section of this report."; 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;