Hi there, I have a series of business case testing that are done across 12-20 stored processes. Each of these have the same data gathering logic (with some filter variables, and different inputs), and then a section with each of the specific tests. I would like to take the data gathering logic out and move it to a stored process that is called by each test so that I only need to update it in one place. Base-Data The Data gathering step runs a series of ProcSQL steps creating the base datasets for the tests. It does not output anything to a report or screen. Test processes The tests run simple procSQL tests, and output ODS Excel objects (we run these from Excel using the office plugin). Here is an example test: /*Classes to Check*/
%let Classes = %NRSTR("PS","PT","PH");
/**************************************************************************************
Include the Base views that all of the tests use
***************************************************************************************/
%include "./AppointmentAuditBaseViews.sas" /source2;
/*######################## Check to see if the right dues are setup ###########################*/ proc sql; options compress=yes; create table DuesNotSetup as SELECT * FROM WORK.JobsWithDeductions WHERE AllDeductions not like "%DPE%" ; run; proc sql; insert into ReportSummary SET Title="Dues not Setup", Results =(select count(D.CKey) from DuesNotSetup D); quit; ods excel; title j=left "Dues not Setup"; footnote2 j=center color=blue height=10pt "&sysdate9"; proc report style= [just=left] data=WORK.DuesNotSetup; run; ods excel close;
/*Summary report to count how many tests are left*/
ods excel;
title j=left "Summary";
footnote2 j=center color=blue
height=10pt "&sysdate9";
proc report style= [just=left] data=WORK.ReportSummary;
run;
ods excel close;
quit; The problem that I am having is that we store the process on the metadata server, and I cannot figure out how to include a program that is stored on the metadata server, and the system throws an error around the saving of the WORK file if I save it on the drive rather than in metadata. Does anyone have any advice?
... View more