ms_computeutilization.sas File Reference

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

Detailed Description

This macro computes drug and medical utilization.

• If UTILFILE (created in ms_processinputfiles) is specified, then compute utilization metrics.
  • If UTILFILE is not specified, then set empty variables.
• Anchor/Reference:
  • Extract window values for data extraction censoring.
    
  • Identify top level evaluation period for medical and drug utilization.
    
  • EpisodeEndDt should not preceed an IndexDt in Start-End evaluation window.
    
    • Indexdt takes precedence as the start of evaluation window.
    • EpisodeEndDt takes precedence as the end of evaluation window.
      
• 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 or EpisodeEndDt to evaluation period.
  • 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._ads_&DATA._eval(&PERIODIDSTART.-1) (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.utilfile (Dataset with medical or drug utilization metrics specification.)

Program outputs

• dplocal.&RUNID._&DATA. (Dataset containing medical/drug utilization variables.)
• work.&ANCHORTYPE.utilanchorfrom (Dataset containing period for medical and drug utilization (start of evaluation window).)
• work.&ANCHORTYPE.utilanchorto Dataset containing period for medical and drug utilization (end of evaluation window).;
• work._allutil (Dataset combinining util for multiple groups.)
• work._newpatients (Dataset containing new patients identified in look.)
• work._utilrx (Dataset containing extracted dispensing table codes in drug utilization window.)

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)