ms_mfu.sas File Reference

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.
    
    • Extract records.
  • 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.)

Usage

%ms_mfu(where=1 ,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

• ms_caresettingprincipal.sas
• ms_periodsoverlap.sas

Author

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