Multiple tables in multiple sheets with ODS Excel

japfvg — Mon, 04 Oct 2021 22:59:39 GMT

Dear experts:

I have this issue, I need to export 13 tables in 9 sheets, trying to use this code:

ods excel file="\\mxnpr1fs0003.glb.bns.mx\mxcpr1condhb1\tmp\SUGEF_asiento_psc.xlsx"

options(sheet_name="Valida_saldos_Gio" frozen_headers='1' sheet_interval="now");
proc print data=work.a1_tabla4_valida;
run;

ods excel options(sheet_name="Ajustes_Tab_1" frozen_headers='1' sheet_interval="now");
proc print data=work.ajustes_manuales_1;
run;

ods excel options(sheet_name="Resumen_Tab_1" frozen_headers='1' sheet_interval="now");
proc print data=work.a1_resumen1;
run;

ods excel options(sheet_name="Tabla_1_EDL" frozen_headers='1' sheet_interval="none");
proc print data=work.a1_total1;
run;

proc print data=work.a1_total;
run;

ods excel options(sheet_interval="now");

ods excel options(sheet_name="Tabla_2_Sugef" frozen_headers='1' sheet_interval="none");
proc print data=work.a2_total1;
run;

proc print data=work.a2_total;
run;

ods excel options(sheet_name="Ajustes_Tab_2" frozen_headers='1' sheet_interval="now");
proc print data=work.ajustes_manuales_2;
run;

ods excel options(sheet_name="Validacion_SUGEF" frozen_headers='1' sheet_interval="now");
proc print data=work.a2_valida_final;
run;

ods excel options(sheet_name="Asiento_1" frozen_headers='1' sheet_interval="none");
proc print data=work.asiento_1_final;
run;

proc print data=work.valida_asiento_1;
run;

ods excel options(sheet_name="Asiento_2" frozen_headers='1' sheet_interval="none");
proc print data=work.asiento_2_final;
run;

proc print data=work.valida_asiento_2;
run;

ods excel close;

but some tables are in the same tables so I'm not sure where's the issue.

Thanks in advance for all your advise.

Fer

Re: Multiple tables in multiple sheets with ODS Excel

PaigeMiller — Tue, 05 Oct 2021 00:41:23 GMT

@japfvg wrote:

... but some tables are in the same tables so I'm not sure where's the issue.

Please explain this further, and show us a screen capture(s) of what the problem is (use the "Insert Photos" icon to include screen captures, do not attach files).

Re: Multiple tables in multiple sheets with ODS Excel

Oligolas — Tue, 05 Oct 2021 09:44:14 GMT

Hi,

I guess this answers your question

topic Re: Multiple tables in multiple sheets with ODS Excel in SAS Programming

Multiple tables in multiple sheets with ODS Excel

Re: Multiple tables in multiple sheets with ODS Excel

Re: Multiple tables in multiple sheets with ODS Excel