QRP
 
•All Files Pages
Loading...
Searching...
No Matches
combo_processinputfiles.sas File Reference

This macro imports the Combo and Combo Codes input files, processes them by assigning default values, and if executing as part of QRP combines codes to extract from combo and QRP. More...

Detailed Description

This macro imports the Combo and Combo Codes input files, processes them by assigning default values, and if executing as part of QRP combines codes to extract from combo and QRP.

  1. Import CombFile:
    • Set default values.
    • Convert special characters to underscores.
      • Upcase added to prevent group deduplication caused by uppercase/lowercase typos in the input file.
  2. CodesFile:
    • Temporality creating codetype for MS_ProcessWildcards.
    • Process wildcards.
    • Put non diagnosis codes back in the CodesFile.
    • Sort by RawOrder to make sure the number of RawGroups to process by the Two-By-Two Method will be calculated correctly.
    • Create lookup tables for raw record extraction.
Program inputs
  • infolder.&CODESFILE. (Dataset defining the combo codes input file.)
  • infolder.&COMBFILE. (Dataset defining the combo input file.)
  • work._diag (Lookup dataset from QRP containing diagnosis codes to extract (if running as part of QRP).
  • work._lab (Lookup dataset from QRP containing raw lab result codes to extract (if running as part of QRP).
  • work._ndc (Lookup dataset from QRP containing dispensing codes to extract (if running as part of QRP).
  • work._proc (Lookup dataset from QRP containing procedure codes to extract (if running as part of QRP).
Program outputs
  • work._diag (Lookup dataset containing diagnosis codes to extract (if running as part of QRP).
  • work._lab (Lookup dataset containing raw lab result codes to extract (if running as part of QRP).
  • work._ndc (Lookup dataset containing dispensing codes to extract (if running as part of QRP).
  • work._proc (Lookup dataset containing procedure codes to extract (if running as part of QRP).
  • work._clab (Lookup dataset containing lab result codes to extract (if running as part of QRP).
  • work._cenr (Lookup dataset containing enrollment records to extract (if running as part of QRP).
  • work._cenc (Lookup dataset containing encounter records to extract (if running as part of QRP).
  • work._cdem (Lookup dataset containing demographic records to extract (if running as part of QRP).

Usage 

%combo_processinputfiles(COMBFILE=&COMBOFILE.,
                         CODESFILE=&COMBOFILE.Codes)
Parameters
[in]COMBFILEName of the SAS dataset defining the Combo Input File.
[in]CODESFILEName of the SAS dataset defining the Combo Codes Input File.

SAS Macros Dependencies

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