ODS Output question

[greg6363]

I'm using the ODS Output procedure to send a number of data sets (in .csv format) to a folder that resides on the UNIX box of our firm's SAS server. In PROC EXPORT, you can send a data set to an individual sheet within an Excel workbook instead of creating an individual workbook for each set. Can you do the same thing with ODS? Here's my code. Any suggestions would be greatly appreciated. Thanks.

options

missing=" ";
title

'OUTSTANDINGS BY REGION';
/*OUTSTANDINGS BY REGION (HISTORICAL3)*/

proc tabulate data=service_table out=outstandings_region format=comma10. noseps;
class serv_month region;
var nte01t_note_cpb;
table serv_month*(region ALL='Total'),
(nte01t_note_cpb='Outstandings')*f=dollar16.2 (ALL='Count');
keylabel N='#';
run;

ods listing close;
ods csv file='/sharedhome/j024543/nelnet/landon/OUTSTANDINGS_BY_REGION.CSV';
proc print data=outstandings_region;
title
'OUTSTANDINGS BY REGION';
run;
ods csv close;
ods listing;

options missing=" ";
title 'DELINQUENCY BUCKETS & PERCENTAGES';
/*DELINQUENCY BUCKETS & PERCENTAGES*/

proc tabulate data=service_table out=delq_buckets_pcts format=comma10. noseps;
class serv_month region delq_cycle;
var nte01t_note_cpb;
table serv_month*(delq_cycle ALL='Total'),
(nte01t_note_cpb= 'Outstandings')*f=dollar16.2*(sum='$' pctsum<delq_cycle ALL>='Rate'*f=tabpct.)(ALL='Count');
/*keylabel sum='$' pctsum='Rate';*/
keylabel N='#';
run;

ods listing close;
ods csv file='/sharedhome/j024543/nelnet/landon/DELQ_BUCKETS_PCTS.CSV';
proc print data=delq_buckets_pcts;
title 'DELINQUENCY BUCKETS & PERCENTAGES';
run;
ods csv close;
ods listing;

[jrai]

Use ods tagsets.excelXP file=

Specify a file name with .xml format. This will create a different sheet within the same file for each proc.