export multiple tab in a excel file and in only one sheet

[Tecla1]

Good morning ,

to export data in Excel file I use "Proc export" but with this procedure I can export a each tab in a proper sheet.

In this moment I need to export more tab in only one sheet (five tab with different column).

Can you help me?

I find some topics but without a result.

Tnks for your kindly help

[Kurt_Bremser]

Use ODS EXCEL with options sheet_name='whatever' and sheet_interval='none', and a series of PROC PRINTs.

[Tecla1]

Good morning !! Tnks for your kindly help.
I do what you say but system give me this error:
ERROR: Unable to load module 'SpreadsheetML' from template store!
ERROR: No body file. EXCEL output will not be created.

what I have to do? Tnks!!!


/*prova export*/

ods excel file="\\grpi-sas-pl67\Modelli2\SEGNALAZIONI\2020\SEGNALAZIONE 2019\PERIMETRO SPEZIA\a_PROVA.xlsx"
options(sheet_name="whatever" sheet_interval="none");
/*Sheet1-2 tables*/
Title 'Table1';
proc print data=Tabel2.A_6030_01_12411851(obs=10) noobs;
run;
Title 'Table2';
proc print data=Tabel2.A_6030_02_12411851(obs=10) noobs;
run;

[Kurt_Bremser]

See http://support.sas.com/kb/56/909.html 

Your SAS needs to be updated, as you are at 9.4M0 or even older. The current version is 9.4M6.

There have been lots of useful additions/improvements in the meantime.

The SAS license includes the right to get updates at any time.

[Tecla1]

Tnks for your kindly help but sas give me an ERROR because I have an old version….
I asked for a new one !!!

Have a nice afternoon..
Tecla

[Tecla1]

Good morning,

i find some solution to this problem but was wery old… and I try without success. Can you help me?

I  need to put in the same spreadsheet more tables.

Tnks to all for your kindly help.

[andreas_lds]

Well, xls is an outdated file-format, so there will be hardly any new information on how to solve the issue you have.

And in future messages please don't write the title in upcase.

[Tecla1]

Excuse me... but this don't help me.

[Kurt_Bremser]

Quick code example, tested on 9.4M6 on AIX:

ods excel file='$HOME/sascommunity/test.xlsx' options(sheet_name="Test" sheet_interval='none') style=egdefault;

proc print data=sashelp.class noobs;
run;

proc print data=sashelp.cars noobs;
run;

ods excel close;