topic Re: export multiple tab in a excel file and in only one sheet in ODS and Base Reporting

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

Tecla1 — Thu, 19 Mar 2020 10:27:54 GMT

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

EXPORT TO EXCEL MULTIPLE TABLES TO ONE XLS FILE ON SAME SHEET

Tecla1 — Thu, 19 Mar 2020 10:02:09 GMT

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.

Re: EXPORT TO EXCEL MULTIPLE TABLES TO ONE XLS FILE ON SAME SHEET

andreas_lds — Thu, 19 Mar 2020 10:17:07 GMT

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.

Re: EXPORT TO EXCEL MULTIPLE TABLES TO ONE XLS FILE ON SAME SHEET

Tecla1 — Thu, 19 Mar 2020 10:31:23 GMT

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

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

Kurt_Bremser — Thu, 19 Mar 2020 11:09:06 GMT

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

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

Kurt_Bremser — Thu, 19 Mar 2020 11:16:07 GMT

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;

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

Tecla1 — Fri, 20 Mar 2020 08:19:57 GMT

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;

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

Kurt_Bremser — Fri, 20 Mar 2020 08:51:07 GMT

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.

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

Tecla1 — Tue, 24 Mar 2020 18:07:35 GMT

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