ms_createptsmasterlist.sas File Reference

This macro creates the numerator dataset based on the first 4 POV datasets. More...

Detailed Description

This macro creates the numerator dataset based on the first 4 POV datasets.

• Type 1, 2, 5, and 6 cohort definition:
  
  • Index Date Reference Cohort Criteria:
    • Index date must overlap greater monitoring period.
    • Adjust EpisodeEndDt if EpisodeEndDt > censordate (dp_maxdate or FupEndDate).
    • Adjust EpisodeEndDt when MAXCUMDOSE.
    • Adjust EpisodeEndDt if EpisodeEndDt > DeathDt.
    • Trucate episode at FUT.
      • Only adjust for FUT when FUT is prior to EpisodeEndDate.
      • FUT after EpisodeEndDt can occur if Epiosde is shortened to occur on EndDate.
    • ExpExtPer may have made the episode to go beyond elig.
    • Minimum look back enrollment duration.
    • Take death and censordate into account for post-index data availability.
    • Minimum data availability after episode end.
    • Secondary episode observation window enrollment.
    • Minimum episode duration.
    • Maximum episode duration.
    • Patient must be enrolled throughout the entire minimum episode duration.
    • Remove episodes that do not have at least one day at risk post blackout (at least one day to observe an event).
    • If PS or Covariate adjustment is performed, patient must have at least one post blackout day at risk (at least one day to observe and event) in the look of their index date.
  • Utilization summarization for episodes does not need to occur when POINT = Y because RXSUP = 0.
    
    • Summarize utilization that are overlapping selected as-treated episodes.
    • Summarize RxSup during episode (only to apply mindaysupp criterion).
      • The final summarization will be done when episode selection is finalized.
• Create prevalent type 6:
  
  • Index Date must overlap greater monitoring period.
    
  • Adjust EpisodeEndDt if EpisodeEndDt > EndDate.
    
  • Adjust EpisodeEndDt if EpisodeEndDt > DeathDt.
    
  • ExpExtPer may have made the episode to go beyond elig.
    
  • Minimum look back enrollment duration.
    
  • Take death and censordate into account for post-index data availability.
    
  • Minimum data availability after episode end.
    
  • Maximum Episode Duration.
  • Summarize RxSup during episode (only to apply mindaysupp criterion).
    • The final summarization will be done later when episode selection is finalized.
      
  • Identify prevalent/incident episodes.
• Type 3 cohort definition:
  
  • Manage all dates:
    • Calulate windows start and end dates for reuse.
    • Calculate length of lookback period for HOI INCIDENCE ASSESSMENT.
    • Calculate min/max elig requirement from Adate perspective and using LookBackLength.
      • Exclusion elig requirement is already accounted for in POV3.
  • IndexDt Reference Cohort Criteria (Exposure Event Criteria).
    
    • Minimum look back enrollment duration.
    • Take death and censordate into account for post-index data availability.
• Type 4 cohort definition:
  
  • In _pov1 and _pov3, ADate is the IndexDt (start of pregnancy episode).
    • Merging in, ADate is renamed to IndexDt in _pov4, ADate is the pregnancy outcome date.
      
    • Apply the period dates criterion to episode end date (unlike other types it is not applied to IndexDt).
    • Assign EpisodeStartDt variable.
    • Minimum look back enrollment duration.
      • When Inclusions/Exclusions, Covariates or MFU codes are anchored to INDEXDT the patient must be enrolled during the evaluation window prior to the pregnancy outcome for each of them.
      • When Inclusions/Exclusions, Covariates or MFU codes are anchored to EPISODEENDDT and the anchorfrom value is negative the patient must be enrolled during the pre pregnancy outcome window for each of them.
    • Create eligdays (# of days of enrollment prior to preg outcome date) for enrollment tables.
  • Link child enrollment end date.
    
  • For cohorts restricted to linked mothers, remove episodes where children do not meet the enrollment criteria (they must meet the enrollment criteria in their first enrollment span (the one where cenr_start occurs)).
    
  • Link mother age group to _ptsmasterlist dataset.
    
  • Link mother age group to _deliveries dataset.

Program inputs

• work._pov1 (Dataset with all potential index dates.)
• work._pov2 (Dataset with index dates that have an incidence claim in the washout period.)
• work._pov3 (Dataset with index dates meeting the inclusion/exclusioncriteria.)
• work._pov4 (Dataset with exposure episodes.)

Program outputs

• work._ptsmasterlist (Dataset with valid numerator observations.)

Usage

%ms_createptsmasterlist();

Parameters

None.

SAS Macros Dependencies

• ms_shaveoutside.sas

Author

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