This macro performs a Most Frequent Use (MFU) analysis. More...

Detailed Description

This macro performs a Most Frequent Use (MFU) analysis.

Determine the number of analyses.
Loop through analyses.
- Number of CodeCat/CodeType within analysis.
  - Parameters are set for the analysis and not unique to CodeCat/CodeType.
- List of CodeCat.
- Process DX/PX codes.
  - Break out CaresettingPrincipal into Caresetting and Principal.
  - Select all code types.
  - Stack claims datasets.
  - Extract records.
- Process RX codes.
  - Determine whether to extract 09-digit NDC codes, 11-digit NDC codes, or both.
  - Process lab codes.
    - Select code types.
    - Determine whether to restrict to N, C, or both.
    - Count SOC-defined lab codes (codetype = 01N, 01C).
      - Extract lab records.
    - Count LOINC lab codes (codetype = 02N, 02C).
      - Extract lab records.
    - Count PX lab codes.
      - Extract lab records.
- Calculate top XX and output aggregate dataset.

Program inputs

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.)
infolder.&LABCODESMAP. (Dataset for lab result extraction.)
infolder.&MFUFILE. (Dataset for most frequent utilization (MFU) assessment.)

Program outputs

msoc.&RUNID._mfu&T3OUT. (Dataset including most frequent utilization assessment, which enables users to retrieve the top XX NDCs, diagnoses, and procedures before and/or after the index date for Type 1-5 analyses.)
work._lkup03 (Dataset with counts of procedure and lab codes.)
work._map (Dataset containing unique codes from infolder.&LABCODESMAP.)
work._mfulab01 (Dataset with extracted lab records (SOC-defined lab codes (codetype = 01N, 01C)).)
work._mfulab02 (Dataset with extracted lab records (LOINC lab codes (codetype = 02N, 02C)).)
work._mfulab03 (Dataset with extracted lab records (PX lab codes).)
work._mfulb (Dataset with lab codes.)
work._mfulb_01_02 (Dataset with lab codes.)
work._rxcodes09 (Dataset with extracted 9-digit NDC codes.)
work._rxcodes11 (Dataset with extracted 11-digit NDC codes.)
work.claims_dxpx (Dataset with stack claims.)

Usage

%ms_mfu(%if %eval(&type.=2) %then %do; 
          where=previnc="Inc" 
        %end;
        %else %do; 
          where=1 
        %end;
        ,t3out=);

Parameters

[in]	WHERE	Where clause to restrict claims_dxpx for computations.
[out]	T3OUT	For Type 3 analyses, it takes the value of _an and _an_censor for analysis and analysis_censor datasets. It is blank for all non-Type 3 analyses.

SAS Macros Dependencies

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

	QRP