HI all,   I am trying to run multiple programs without calling %run_check for each dataset manually. I have create another macro %prgrun with do loop.:   %macro run_check(dsn); proc printto log="&dsn.log"; run; proc printto print="&dsn.lst"; run; %include "&dsn.sas"; %mend;   %macro prgrun; %let dqclist=sd1044#sd1131#sd1121; %do i= 1 %to %eval(%sysfunc(count(&dqclist,#))+1); %let dqc=%scan(&dqclist,&i,#);   %run_check(/u1/stat/dqc/XXXX/prog/&dqc..);   %end; %mend;   options symbolgen mlogic merror serror; %prgrun;     I was expecting to run all 3 programs sd1044, sd1131 and sd1121. However, I see that only first program in the loop runs i.e. sd1044.   Can you please take look at it? Not sure why other 2 programs don't run?   Thank you. ... View more

Hi,   I have code below to create one excel file with different sheets for different datasets. In below code, %dqcreadin macro creates &p21id and &title macro variables. It also create DQCOUT dataset in  work library which I am deleting by suing proc datasets step.    In addition to expected datasets, it also creates additional sheets: for each dataset, sheet for values of &p21id and &title    %macro excel;   ods listing close; ods tagsets.excelxp file='&path/test.xls' ;   %let datasets=AE#DM; %do i = 1 %to %eval(%sysfunc(count(&datasets,#))+1); %let dsn=%scan(&datasets,&i,#);   %dqcreadin(id=&dsn); proc datasets library=work; delete dqcout; run; ods tagsets.excelxp options(sheet_name="&dsn" embedded_titles='yes' embedded_footnotes='yes' );   title j=l "&p21id &title"; proc print data=&dsn; run;   footnote1 j=l font=arial height=10pt "&lineland"; footnote2 j=l font=arial height=10pt "Source: &sysin -- &p21id -- &_uid.V&sysver &sysdate9.:&systime. Source data:SDTM. Data Transfer: &datadate";   %end;   ods tagsets.excelxp close; ods listing; %mend;   Can anyone help me to find out how we can control ODS tagsets.excelxp to create sheets for only "proc print" of &dsn?   Thank you. ... View more

Hi all,   I am trying to run many SAS programs by using below macro. I have not defined path of program since they are present in same folder where I am running macro:   %macro run_check(prg); proc printto log="&prg.log"; run; proc printto print="&prg.lst"; run; %include "&prg.sas"; %mend;   options symbolgen merror mlogic; %run_check(SD0036.);       But it shows below ERROR in log file of SD0036.sas: WARNING: Physical file does not exist, XXXXXXX/SD0036.sas. ERROR: Cannot open %INCLUDE file SD0036.sas.   I am not sure why 'Dot' comes after 'SD0036.sas' name in log.   Please let me now how to fix this issue.   Thank you. ... View more