ms_subsetinitialextraction.sas File Reference

This macro takes a list of patIDs and subsets datasets to only those patIDs. More...

Detailed Description

This macro takes a list of patIDs and subsets datasets to only those patIDs.

1. Loop through each CODECAT used to define index, and for each codecat extract claims that define index in order to identify every patID with an index defining claim
2. Create list of patIDs
3. Subset specified dataset in DATASETSTOSUBSET parameter to only patIDs in _patidlist

Program inputs

• Dataset defined in CODESDATASET
• Datasets defined in DATASETSTOSUBSET
• Initial extracts from QRP: -worktemp._procextract -worktemp._diagextract -worktemp.drugs -worktemp.drugscomb -worktemp.encextract[av/ed/ip/is/oa] -worktemp.milextract -worktemp.deathextract -worktemp.codextract

Program outputs

• Datasets defined in DATASETSTOSUBSET

Usage

%ms_subsetinitialextraction(RESTRICTTOPATIDS=Y
                            CODESDATASET=indexdefiningcodes
                            DATASETSTOSUBSET=worktemp.drugs worktemp._procextract);

Parameters

[in]	RESTRICTTOPATIDS	Y/N indicator whether to execute ms_subsetinitialextraction macro
[in]	CODESDATASET	Name of the sas dataset containing the list of index defining codes. Should contain columns CODE, CODETYPE, CODECAT, and CARESETTINGPRINCIPAL
[in]	DATASETSTOSUBSET	Space delimited list of datasets to further subset. Must contain variable patID

SAS Macros Dependencies

• ms_caresettingprincipal.sas
• ms_extractdrugs.sas
• isdata.sas
• restrictclms.sas

Note

Compatible with codecat DX, PX, RX, EN, DH, CD, and MIL extraction. Not compatible with LB, AN, DT

Author

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