ms_attrition_enrollment.sas File Reference

This macro creates a dataset containing demographic and enrollment flags for attrition. More...

Detailed Description

This macro creates a dataset containing demographic and enrollment flags for attrition.

• Prepare raw eligibility-type data for waterfall (all types).
  
  • Keep the last look.
    
  • Shave outside.
    
  • For cohorts restricted to linked mothers, remove mothers with children who do not meet enrollment criteria.
    
  • Get coverage and agestrat.
    • If ms_attrition_enrollment is called prior to scenario loop, coverage and agestrat will be the same for all groups.
      
    • Assign demographic variables if ms_attrition_enrollment is called prior to scenario loop.
      • Demographics criteria:
        • Sex values.
        • Race values.
        • Hispanic values.
        • Calculate age and age strata.
          
          • Patient eligible age must overlap at least StartDate - EndDate.
            

Program inputs

• &MONITORINGFILE. (Dataset that defines the relevant query periods for execution.)
• indata.&ENRTABLE. (Dataset with enrollment data.)
• indata.&MILTABLE. (Dataset with mother-infant linkage data.)
• infolder.&COHORTFILE. (Dataset used to define enrollment and demographic requirements, type of cohort identification strategy.)
• work.demogs (Dataset including START and END dates to calculate age for each observation and a text string defining the age stratifications.)
• work.demogsmissing (Dataset including a START date and a constant date parameter to calculate age for each observation and a text string.)
• work.multidemogs (Dataset containing mutliple demographic entries.)

Program outputs

• work._agegroupforattrition (Dataset with patient's eligible age that overlaps at least start date or end date.)
• work._infantexcluded (Dataset containing mothers with children who do not meet enrollment criteria.)
• work._keep1 (Dataset containing the age group for each observation using start date to measure age.)
• work._keep2 (Dataset containing the age group for each observation using end date to measure age.)
• work._look (Dataset containing start and end date from the query period.)
• worktemp._bdatesforattrition (Dataset containing one birth date per patient.)
• worktemp._enrforattrition (Dataset containing containing one record per patient.)

Usage

%ms_attrition_enrollment(OUTDATA=worktemp._keep);

Parameters

[out]

OUTDATA

Name of the output dataset.

SAS Macros Dependencies

• ms_agestrat.sas
• ms_delpatients.sas
• ms_periodsoverlap.sas

Note

This macro reports member level data.

Author

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