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.
    
  • 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)