Multiple tables in multiple sheets with ODS Excel

[japfvg]

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

[PaigeMiller]

---

@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).

[Oligolas · Accepted solution]

Hi,

I guess this answers your question