ms_computeutilization.sas File Reference

This macro computes drug and medical utilization. More...

Detailed Description

This macro computes drug and medical utilization.

• If MEDUTILFILE or DRUGUTILFILE (created from UTILFILE in ms_processinputfiles) is specified, then compute utilization metrics.
  • If neither MEDUTILFILE or DRUGUTILFILE exists, then set empty variables.
• Anchor/Reference:
  • Identify minimum and maximum dates to extract claims.
    • For non-Type 4 this is the minimum and maximum indexdt.
    • For type 4,this is the minimum and maximum indexdt, episodeenddt, and/or indexdt_exp depending on which dates the evaluation period is anchored.
• Medical Utilization:
  
  • Extracting encounter data.
    
  • Select and loop through each group.
    
    • Initialize for cohorts reqested in baseline tables not in utilfile
    • Process util parameters.
    • Combine util for multiple groups.
• Drug Utilization:
  • Assign IndexDt, IndexDt_Exp (type 4 only), and/or EpisodeEndDt to evaluation period depending on anchor values specified.
  • Extract dispensing table codes for patients in query and restrict to only needed dates.
    
  • Extract dispensing table codes in drug utilization window.
  • Get Generic and ClassName
  • Count number of RX, distinct Generic, and distinct ClassName.
    • merge in values from prior periods
• Update master file with medical and drug utilization data.
  
• If the drugclass file is not specified, then only medical utilization is computed.
  

Program inputs

• &DATALIB_DIS. (Dataset for dispensing claims.)
• &DATALIB_ENC. (Dataset for encounter claims.)
• &DPLOCALPOINTER..&RUNID._&DATA. (Dataset with values from prior periods.)
• dplocal.&RUNID._&DATA. (Dataset containing one record per individual per index date for every cohort specified in the CIDA module run.)
• work.&RUNID._&DATA. (Dataset containing first index date.)
• work.baselinegrps (Dataset containing list of cohorts.)
• work.medutilfile (Dataset with medical utilization metrics specification.)
• work.drugutilfile (Dataset with drug utilization metrics specification.)

Program outputs

• dplocal.&RUNID._&DATA. (Dataset containing medical/drug utilization variables.)

Usage

%ms_computeutilization();

Parameters

None.

SAS Macros Dependencies

• ms_periodsoverlap.sas
• ms_util.sas

Author

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