The SAS Output Delivery System and reporting techniques

excelxp & multiple tabs

Reply
N/A
Posts: 0

excelxp & multiple tabs

I'm trying to create a report with multiple tabs for each proc report step but instead keep getting multiple workbooks. I've read several postings but none seem to solve my problem. Currently I am running SAS 9.2 and already downloaded the most recent excelxp tagset definitions. Below is my code. Any ideas on how to get this to work would be greatly appreciated.

ods tagsets.excelxp
file="file.xls"
style=sansprinter;

ods tagsets.excelxp options(sheet_interval='none' sheet_name='First sheet');

proc report data=&lib..file1 nowd;
column stat_cd year_range, (accounts loans);
define year_range / across ;
define stat_cd / group;
define accounts / analysis format=18.;
define loans / analysis format=18.;
run;

ods tagsets.excelxp options(sheet_interval='none' sheet_name='Second sheet');

proc report data=work.file2 nowd;
column stat_cd year_range, (accounts loans);
define year_range / across ;
define stat_cd / group;
define accounts / analysis format=18.;
define loans / analysis format=18.;
run;

ods tagsets.excelxp options(sheet_interval='none' sheet_name='Third sheet');
proc report data=work.file3 nowd;
column stat_cd year_range, (accounts loans);
define year_range / across ;
define stat_cd / group;
define accounts / analysis format=18.;
define loans / analysis format=18.;
run;

ods tagsets.excelxp close;
N/A
Posts: 0

Re: excelxp & multiple tabs

Posted in reply to deleted_user
hello,

use newfile=none on the ods tagsets.excelxp
file="file.xls"
style=sansprinter;



Marius
N/A
Posts: 0

Re: excelxp & multiple tabs

Posted in reply to deleted_user
It works fine now. Thanks!
Ask a Question
Discussion stats
  • 2 replies
  • 165 views
  • 0 likes
  • 1 in conversation