QRP
 
Loading...
Searching...
No Matches
ms_createclaimsfiles.sas File Reference

This macro extracts and saves claims for identified cohort for HDPS/MFU. More...

Detailed Description

This macro extracts and saves claims for identified cohort for HDPS/MFU.

  • Capture HDPSAnchorVars names.
  • List all groups.
  • Create array of potential HDPS/MFU anchoring windows, select minimum and maximum dates across all of them.
  • Keep only patients in groups where HDPS is required and all groups for MFU.
  • Determine minimum and maximum windows.
  • For enrollment considered absolute value of window, obtain true maximum window.
  • Set default anchor dates:
    • IndexDt for non-type 4.
    • Minimum and maximum dates defined for type 4.
  • Create DX ICD claims dataset, separate out based on code type.
  • Create PX ICD claims dataset, separate out based on code type.
  • Create drug class dataset, and keep RX codes.
  • Add DrugClass information for HDPS.
  • Compute lab table for MFU only.
Program inputs
  • dplocal.&RUNID._mstr&PREG. (Dataset containing one record per individual per index date for every cohort (i.e., one row per pregnancy episode).)
  • dplocal.&RUNID._mstr_mi (Dataset for Type 4 analyses produced for exposed and comparator/unexposed pregnant cohorts.)
  • infolder.&DRUGCLASSFILE. (Dataset required for the use of drug utilization metrics.)
  • infolder.&MFUFILE. (Dataset for most frequent utilization (MFU) assessment.)
  • infolder.&PSESTIMATIONFILE. (Dataset with the parameters for estimating a PS model and is required for PS-based analyses.)
  • work.&DATALIB_DIA. (Dataset for diagnosis claims.)
  • work.&DATALIB_DIS. (Dataset for dispensing claims.)
  • work.&DATALIB_LAB. (Dataset for lab claims.)
  • work.&DATALIB_PROC. (Dataset for procedure claims.)
  • work.&RUNID._mstr&PREG. (Dataset containing enrolment episodes.)
  • work.&RUNID._mstr_mi (Dataset containing inclusion/exclusion codes.)
Program outputs
  • dplocal.&RUNID._claims_cpt (Dataset containing all codes for CPT.)
  • dplocal.&RUNID._claims_dxot (Dataset containing all codes for other diagnosis.)
  • dplocal.&RUNID._claims_hcpcs (Dataset containing all codes for HCPCS.)
  • dplocal.&RUNID._claims_icddx09 (Dataset containing all codes for ICD-9-CM diagnosis.)
  • dplocal.&RUNID._claims_icddx10 (Dataset containing all codes for ICD-10-CM diagnosis.)
  • dplocal.&RUNID._claims_icdpx09 (Dataset containing all codes for ICD-9-CM procedure.)
  • dplocal.&RUNID._claims_icdpx10 (Dataset containing all codes for ICD-10-CM procedure.)
  • dplocal.&RUNID._claims_lab (Dataset containing all codes for labs.)
  • dplocal.&RUNID._claims_pxot (Dataset containing all codes for other procedure.)
  • dplocal.&RUNID._claims_rx (Dataset containing all codes for dispensings.)

Usage

%ms_createclaimsfiles();
Parameters
None.

SAS Macros Dependencies

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