This macro will extract laboratory data from MSDD tables. More...

Detailed Description

This macro will extract laboratory data from MSDD tables.

Create the correct variable name for RAWLABDATETYPE/LABDATETYPE, RAWLABRESULT/LABRESULT and RAWCARESETTING/CARESETTINGPRINCIPAL based on the lab_var parameter.
Lab extraction based on lookup - LAB01:
- Map ms_test_name, ms_test_sub_category, specimen_source, ms_result_unit, result_type, fast_ind, and pt_loc combination from code.
  - NOTE: Codes in the combo inputfiles not mapping to lab_lookup will be discarded.
- Extract lab records.
- Apply results criteria (if applicable).
Lab extraction based on LOINC - LAB02:
- Apply results criteria (if applicable).
Lab extraction based on PX - LABXX (XX not in (01 02)):
- Extract lab records.
- Apply Results Criteria (if applicable).
Remove the true duplicates as a record could have been extracted three time using three different criteria.

Program inputs

&DATAFILE. (Dataset to extract records from.)
&LOOKFILE. (Dataset containing the list of codes to extract.)
indata.&LABTABLE. (Dataset with lab result data.)
indata.&PROCTABLE. (Dataset with procedure data.)
infolder.&LABCODESMAP. (Dataset for lab result extraction.)

Program outputs

&OUTFILE. (Dataset containing the extracted records.)
work._dups (Dataset containing duplicated codes from infolder.&LABCODESMAP.)
work._map (Dataset containing unique codes from infolder.&LABCODESMAP.)

Usage

%ms_extractlabs(DATAFILE=worktemp.labextract,
                LOOKFILE=_ITGroupParamLabs, 
                MINDATE=,
                OUTFILE=_ITlabs);

Parameters

[in]	DATAFILE	Name of the dataset to extract records from.
[in]	LOOKFILE	Name of the sas dataset containing the list of codes to extract.
[in]	MINDATE	Extract all claims occuring on or after this date.
[out]	OUTFILE	Name of the output dataset containing the extracted records.
[in]	LAB_VAR	Raw if combo(RAWLABDATETYPE, RAWLABRESULT and RAWCARESETTING) otherwise blank and will use LABDATETYPE, LABRESULT and CARESETTINGPRINCIPAL.
[in]	DATAFILEWHERE	Additional where criteria to apply to &datafile lab extraction. Must be in this format: str(where=(***)).

SAS Macros Dependencies

None.

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

	QRP