This macro bridges member raw enrollment episodes into continuous periods, while allowing a maximum gap in enrollment. More...

Detailed Description

This macro bridges member raw enrollment episodes into continuous periods, while allowing a maximum gap in enrollment.

Determine if the dataset is sorted by PatId Enr_Start and Enr_End.
- If it is not sorted then sort.
Create enrollment episodes
If required, remove duplicates.

Program inputs

&INFILE. (Dataset with enrollment data.)

Program outputs

&OUTFILE. (Dataset containing the bridged enrollment episodes.)

Usage

%ms_episoderec(INFILE=indata.&enrtable.(keep=Patid Enr_Start Enr_End MedCov DrugCov Chart),
               OUTFILE=_ComboEnr1,
               MEDCOV=Yes,  
               DRUGCOV=No,        
               ENRSTART=Enr_Start,
               ENREND=Enr_End,
               ENROLGAP=&ENROLGAP.,
               REMOVEDUP=Yes);

Parameters

[in]	INFILE	SAS dataset containing the raw enrollment data.
[out]	OUTFILE	SAS output dataset containing the conciliated enrollment periods.
[in]	MEDCOV	Medical coverage indicator.
[in]	DRUGCOV	Drug coverage indicator.
[in]	ENRSTART	Name of enrollment episode start date variable in INFILE.
[in]	ENREND	Name of enrollment episode end date variable in INFILE.
[in]	ENROLGAP	Maximum allowable enrollment episode gap.
[in]	REMOVEDUP	Indicates the removal of duplicates from the output file.

SAS Macros Dependencies

None.

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.
The input file must have the MEDCOV and DRUGCOV variables.

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

	QRP