QRP
 
All Files Pages
Loading...
Searching...
No Matches
ms_episoderec2.sas File Reference

This program bridges member raw enrollment episodes into continuous periods, while allowing a maximum gap between two consecutve enrollment periods. More...

Detailed Description

This program bridges member raw enrollment episodes into continuous periods, while allowing a maximum gap between two consecutve enrollment periods.

  • Sort dataset by PatId Enr_Start and Enr_End.
  • Manage chart type.
  • Change episode if maximum allowable gap is reached or if changes occur in benefit coverage.
  • Reconciliation of eligible episodes.
Program inputs
  • &INFILE. (Dataset with enrollment data.)
Program outputs
  • &OUTFILE. (Dataset containing the bridged enrollment episodes.)

Usage

%ms_episoderec2(INFILE=indata.&ENRTABLE.(keep=Patid Enr_Start Enr_End MedCov DrugCov Chart), OUTFILE=worktemp.enr_&RECONTYP.&ENROLGAP., COVERAGE=&COVERAGE., CHARTRES=&CHARTRES., ENRSTART=Enr_Start, ENREND=Enr_End, ENROLGAP=&ENROLGAP., REMOVEDUP=Yes);
Parameters
[in]INFILESAS dataset containing the raw enrollment data.
[out]OUTFILESAS output dataset containing the conciliated enrollment periods.
[in]COVERAGEDrug and Medical coverage indicator.
[in]CHARTRESChart availability indicator.
[in]ENRSTARTName of enrollment episode start date variable in INFILE.
[in]ENRENDName of enrollment episode end date variable in INFILE.
[in]ENROLGAPMaximum allowable enrollment episode gap.
[in]REMOVEDUPIndicates the removal of duplicates from the output file.

SAS Macros Dependencies

Note
- Consolidated enrollment episode start and end dates are named EStart EEnd.
  • User can use rename after if other names are preferred.
  • In the case where there is the presence of time varying variables, this procedure will keep all records of the input file.
Author
Sentinel Coordinating Center (info@.nosp@m.sent.nosp@m.inels.nosp@m.yste.nosp@m.m.org)