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