This macro pre extracts raw diagnosis or procedure claims based solely on code match. More...

Detailed Description

This macro pre extracts raw diagnosis or procedure claims based solely on code match.

This is useful to use as a pre-extraction to avoid claim duplication.

Program inputs

&DATAFILE. (Dataset to extract records from.)
&LOOKFILE. (Dataset containing the list of codes to extract.)

Program outputs

&OUTFILE. (Dataset containing the extracted records.)

Usage

%ms_extractmeds(DATAFILE=indata.&proctable.,
                DATACODE=PX,
                DATACODETYPE=PX_codetype,
                LOOKFILE=_proc, 
                MINDATE=&studystartdate.,
                OUTFILE=worktemp._procextract(keep=PatID ADate EncType PX PX_CodeType));

Parameters

[in]	DATAFILE	Name of the dataset to extract records from.
[in]	DATACODE	Name of the variable containing the codes.
[in]	DATACODETYPE	Name of the variable containing the CodeType.
[in]	LOOKFILE	Name of the sas dataset containing the list of codes to extract. The name of the variable containing the codes must be called "code" and the one containing the codetype must be called "codetype".
[in]	MINDATE	Extract all claims occuring on or after this date.
[out]	OUTFILE	Name of the output dataset containing the extracted records.
[in]	EXTRAVARS	To add extra variables to initial proc sort nodupkey.

SAS Macros Dependencies

None.

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

	QRP