ms_cidatablest4.sas File Reference

This macro creates characteristics and medication of interest tables for pregnancy analyses (type 4). More...

Detailed Description

This macro creates characteristics and medication of interest tables for pregnancy analyses (type 4).

• If t4cida table is requested, call the ms_cidatables macro to generate the HOI summary table.
  
• Loop through groups.
  
  • t4_preg and t4_nopreg tables:
    
    • If createbaseline is set to Y for some cohortgrp, add covariates to _concepi_mstr file.
      
    • Square table.
      • Merge _ConcEpisodes with _Square to obtain squared table.
    • Summarize data.
      
    • List covariates and put into macro variable.
      
      • Initialize missing variables to prevent warnings.
    • Create final output.
      • The output tables will be stratified by the levels provided in the USERSTRATA inputfile.
    • Save to msoc.
  • t4_cida_nopreg_gestwk and _t4_cida_nopreg_gestwk tables:
    • The only available stratification for gestwk tables is moiname*gestwk.
      
    • Square gestational week.
      • Only square gestwk during evaluation period.
        
    • Square gestwk_char.
      
    • Create 1 row per gestational week to calculate overlap.
      
    • Calculate MOI stats.
      
    • Overlap dispensings.
      
    • Create 1 row per gestational week to calculate overlap.
    • Calculate PregStats.
      
    • To calculate PregEpisodes, each episode terminates during the gestational week.
    • To calculate PrePatients, each patient terminates in the gestational week of their longest episode.
      
    • If postpregdays is specified, compute patients/episodes in the post-pregnancy weeks.
      
    • Merge with _MOI_by_gestwk to assign to each MOI.
    • Create final output.
      • The output tables will be stratified by the levels provided in the USERSTRATA inputfile.
    • Save to msoc.
  • t4_cida_elig table:
    
    • Traditional stratification (eligdays) is continuous and will not be squared. However, adding ability to output non-squared custom stratification.
    • Loop through groups and calculate eligible table.
      • Square table.
        • Merge squared table with _alldeliveries.
      • Summarize data.
      • List all stratification.
      • Create final output.
        • The output tables will be stratified by the levels provided in the USERSTRATA inputfile.
      • Save to msoc.

Program inputs

• dplocal.&RUNID._alldeliveries (Dataset with all deliveries contained in &RUNID._mstr, plus those that do not meet the enrollment eligibility criterion.)
• dplocal.&RUNID._concepi_mstr_&FILE._tri (Dataset with trimester statistics for each pregnancy outcome and medical product of interest.)
• dplocal.&RUNID._mstr_&FILE. (Dataset with one record per individual per index date for every GROUP.)
• dplocal.&RUNID._mstr_mi (Dataset for Type 4 analyses produced for exposed and comparator/unexposed pregnant cohorts.)
• infolder.&COHORTFILE. (Dataset used to define enrollment and demographic requirements, type of cohort identification strategy.)
• infolder.&MICOHORTFILE. (Dataset for Type 4 analysis with pregnancy cohorts among pregnancies matched to an infant specification.)
• infolder.&TYPE4FILE. (Dataset required for a pregnancy episodes identification strategy.)
• infolder.&USERSTRATA. (Dataset with ouput tables and stratifications specification.)

Program outputs

• msoc.&RUNID._t4_cida_elig (Dataset for Type 4 analysis where episodes and number of patients reported will include those that are eligible and ineligible, due to enrollment requirements.)
• msoc.&RUNID._t4_cida_nopreg (Dataset for Type 4 analysis capturing a matched non-pregnant cohort (patients were known to be non-pregnant).)
• msoc.&RUNID._t4_cida_nopreg_gestwk (Dataset for Type 4 analysis capturing a cohort of individuals with episodes not ending in a pregnancy outcome.)
• msoc.&RUNID._t4_cida_preg (Dataset for Type 4 analysis capturing pregnancy episodes ending in a live birth or non-live birth outcome.)
• msoc.&RUNID._t4_cida_preg_gestwk (Dataset for Type 4 analysis capturing a cohort of individuals with pregnancy episodes ending in a pregnancy outcome (live birth or non-live birth outcome).)

Usage

%ms_cidatablest4();

Parameters

None.

SAS Macros Dependencies

• ms_squaredtableshell.sas

Note

When t4cida is requested in USERSTRATA input file, this macro calls ms_cidatables to generate HOI summary tables.

Author

Sentinel Coordinating Center (info@.nosp@m.sent.nosp@m.inels.nosp@m.yste.nosp@m.m.org)