runqrp.sas File Reference

Macro to run QRP analytic code. More...

Detailed Description

Macro to run QRP analytic code.

• Enter version for any custom code written on top of QRP.
  
• Loop through each run and execute QRP.
  
  • Determine if there are csv inputfiles that need to be converted to sas datasets.
    
  • Check if qrp_parameters has a horizontal or vertical structure.
  • Create temporary dplocal/msoc subfolders.
  • Reset all parameters:
    • Type files.
      
    • For type 4: pregnancy algorithm lookup files.
    • For type 4: HOI method.
      
    • Sequential analysis.
      
    • Baseline table files.
    • Additional analyses files: multiple events, overlap, adherence, ITS, switching, concomittant episodes.
      
    • Mother-Infant cohort file.
      
    • Treescan.
    • Propensity Score and Covariate Stratification.
      
  • Assign all parameters to macro variables.
    • Assign formats to inputfiles that were initially CSV.
    • If parameter is combofile, then assign formats for 2 files without qrp_parameter values.
  • Assign the maximum length to duplicate character variable names if a format values table exists.
    
    • Get character variables length.
  • Clean out dplocal and msoc folder for every run.
    
    • Replace dplocal, msoc, and medstemp folder contents.
  • Determine whether:
    
    1. Start at beginning of run.
    2. Start at recently completed checkpoint.
    3. Restart at beginnging of QRP or if a successful checkpoint has been passed.
  • Run CIDA.
  • Clean work library.
    
  • If a previous error has occured (&SYSCC. >4):
    • Abort.
      
    • Redirect back to main log and call log checker.
  • Add row to checkpoint file indicating complete run.
    
  • Delete temporary dplocal and msoc subfolders.
  • Delete freezedata only if its empty.
  • Delete file sas_environment.sas.
    
• Loop through each report and create report.
  
  • Check if report_parameters has a horizontal or vertical structure.
    
  • Reset all parameters.
  • Assign all parameters to macro variables.
  • Include qrp report for leave behind report.
    
• Delete checkpoint file.
  
• Run log checker.
  
  • Redirect log and call log checker.
    

Program inputs

• dplocal.&RUNID._checkpoints (Dataset with the number of checkpoints completed with timestamp.)
• infolder.qrp_parameters (Dataset to define the QRP program parameters that must be specified (run identifier, indicators for the start and end dates for the query period, an indicator of whether signal identification is being performed after CIDA module execution, and the names of all input files.)
• infolder.report_parameters (Dataset applicable for a Type 1, Type 2, Type 4, Type 5, or Type 6 analysis. It is used to request and customize a PDF "leave behind" report of the results to be produced following the execution of CIDA. The structure of this input file is such that each row contains a report parameter name (in the parameter field) and the parameter values for each report (in the report fields).)
• tmplib.format_values (Dataset containing format, informat, and lengths of variables.)

Program outputs

• work.dpinfofile (Dataset containing dp, msoc, dpname, database and includedp.)
• work.qrp_parameters (Copy of the infolder.qrp_parameters dataset in a vertical or horizontal structure.)
• work.qrp_param_content (Dataset containing the content of the infolder.qrp_parameters dataset.)
• work.report_parameters (Copy of the infolder.report_parameters dataset in a vertical or horizontal structure.)
• work.report_param_content (Dataset containing the content of the infolder.report_parameters dataset.)

Usage

%runqrp();

Parameters

All the parameters are set by the run_programs program.

SAS Macros Dependencies

• ms_cidanum.sas

Author

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