qrp_report

***************************************************************************************************

*                                      SENTINEL PROGRAM

***************************************************************************************************

*

* PROGRAM: qrp_report.sas

* CREATED (mm/dd/yyyy): 06/14/2021

* LAST MODIFIED: 08/18/2022

* VERSION: 1.4.0

*

* PURPOSE: Aggregate QRP outputs from data partners and produce an Excel/PDF report

*

* MAJOR STEPS:

*

* KEY DEPENDENCIES/CONSTRAINTS/CAVEATS:

*

* PROGRAMMING NOTES:

*

*

*--------------------------------------------------------------------------------------------------

* CONTACT INFO:

*  Sentinel Coordinating Center

*  info@sentinelsystem.org

*

*--------------------------------------------------------------------------------------------------

*  CHANGE LOG:

*

*   Version   Date       Initials      Comment (reference external documentation when available)

*   -------   --------   --------   ---------------------------------------------------------------

*   See QRP Report Documentation Modification History for release notes   

*

***************************************************************************************************;

​

/*-----------------------------------------------------------------------------------------------*/

/* Section 1: User inputs                                                                        */

/*-----------------------------------------------------------------------------------------------*/

​

/* Location of QRP request inputfiles folder */

%let INFOLDER =;

​

/* Location of data folder */

%let DATAROOT =; 

​

/* Location of QRP report package */

%let REPORTROOT =;

​

/* Enter the name of the CREATEREPORTFILE file*/

%let CREATEREPORTFILE =; 

​

***************************************************************************************************;

*******                                 END OF USER INPUT                                    ******

*******                         DO NOT EDIT BELOW THIS LINE                                  ******

*******     (Consult with SOC or Sentinel team leader if you feel edits are required)        ******

***************************************************************************************************;

​

/*-----------------------------------------------------------------------------------------------*/

/* NOTE: This is standard SOC environment setup code -- Do Not Edit                              */

/*-----------------------------------------------------------------------------------------------*/

​

/* System options */

options nosymbolgen nomlogic;

options ls=100 nocenter ;

options obs=MAX ;

options msglevel=i ;

options mprint mprintnest ;

options errorcheck=strict errors=0;

options merror serror ;

options dkricond=error dkrocond=error mergenoby=warn;

options dsoptions=nonote2err noquotelenmax ;

options reuse=no ;

options fullstimer ;

options missing = .;

options validvarname = v7;

​

/*-----------------------------------------------------------------------------------------------*/

/* Section 2 - SOC macros for cleaning paths and libname assignments                             */

/*-----------------------------------------------------------------------------------------------*/

​

/* If reportroot is missing, assign default path */

%macro check_reportroot;

%if %symexist(reportroot) = 0 or %length(&reportroot) = 0 %then %do;

%global reportroot;

%let rc = %sysfunc(filename(fr,.));

%let reportroot = %sysfunc(pathname(&fr.));

/* Find all \ slashes and turn them into / for both Windows/Unix compatibility */

%let reportroot = %sysfunc(tranwrd(&reportroot,\,/));

/* Remove sasprograms subdirectory to get root path */

%let reportroot = %sysfunc(tranwrd(&reportroot,sasprograms,/));

%let rc= %sysfunc(filename(fr));

%end;

%mend check_reportroot;

%check_reportroot;