I am trying to export several tables to an excel sheet in a concrete format with ods. I want to export 2 tables in one sheet and 2 tables in a second sheet without changing of document, but I am unable to do it with ods.   I have tried the option (sheet_interval = "now") but it export me every single table after it in one sheet and I want 2 tables in that second sheet. Here I left what I want to export. Thank you 😉 title; options nocenter; ods excel file="c:\temp\sample.xlsx" options( sheet_interval= 'none' sheet_name="tables1_2" embedded_titles= 'on' ); title "Table 1"; proc report data=RWORK.Table1 style(header)=[JUST = center FONT_FACE=Arial FONT_SIZE=10pt background = lightblue]; column col1 col2 ; define col1/ 'Column 1'; define col2/ 'Column 2'; define col1 / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt ASIS=on}; define col2 / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt ASIS=on}; run; title "Table 2"; proc report data=RWORK.Table2 style(header)=[JUST = center FONT_FACE=Arial FONT_SIZE=10pt background = lightblue]; column col1 col2 ; define col1/ 'Column 1'; define col2/ 'Column 2'; define col1 / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt ASIS=on}; define col2 / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt ASIS=on}; run; ods excel options( sheet_interval= 'now' sheet_name="tables3_4" ); title "Table 3"; proc report data=RWORK.Table3 style(header)=[JUST = center FONT_FACE=Arial FONT_SIZE=10pt background = lightblue]; column col1 col2 ; define col1/ 'Column 1'; define col2/ 'Column 2'; define col1 / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt ASIS=on}; define col2 / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt ASIS=on}; run; title "Table 4"; proc report data=RWORK.Table4 style(header)=[JUST = center FONT_FACE=Arial FONT_SIZE=10pt background = lightblue]; column col1 col2 ; define col1/ 'Column 1'; define col2/ 'Column 2'; define col1 / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt ASIS=on}; define col2 / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt ASIS=on}; run; title; ods excel close; ... View more

I'am trying to export several tables to an excel sheet in a concrete format with ods. I want to export 3 tables in one sheet and one table in a second sheet without changing of document, but I am not able to do it with ods. I have tried "ods layout end" and "ods layout start" and this one continuous exporting in the same sheet, as well I tried closing ods and opening the same excel changin the name of the sheet but it replaced it. Here I left what I wnat to export, it is mark  with a coment where I want to beging exporting in another sheet. Thank you 😉 ods excel file = "C:\Prueba\exportar.xlsx" style=pearl options (start_at="2,2" sheet_interval = 'page' sheet_name = "Prom"); ods escapechar='~'; ods text = "~S={font_size=14pt font_weight=bold foreground=blue font_face='Algerian' TEXTDECORATION=underline}~Capacidad Discriminante"; ods text = " "; ods text = "~S={font_size=11pt font_weight=bold}~ 1. Tabla 1"; ods text = " "; *Tabla 1; proc report data=RWORK.Tabla1 style(header)=[JUST = center FONT_FACE=Arial FONT_SIZE=10pt background = lightblue]; column GINI REF DISC; define GINI/ 'Gini'; define REF/ 'Referencia'; define DISC/ 'Capacidad'; define GINI / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=200 ASIS=on}; define REF / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=120 ASIS=on}; define DISC / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=200 ASIS=on}; run; ods text = " "; ods text = "~S={font_size=11pt font_weight=bold}~ 2. Tabla 2"; ods text = " "; *Tabla 2; proc report data=RWORK.Tabla2 style(header)=[JUST = center FONT_FACE=Arial FONT_SIZE=10pt background = lightblue]; column Variables VI_Ref VI_Disc; define Variables/ 'Variables'; define VI_Ref/ 'Referencia'; define VI_Disc/ 'discriminante'; define Variables / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=200 ASIS=on}; define VI_Ref / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=200 ASIS=on}; define VI_Disc / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=200 ASIS=on}; run; ods text = " "; ods text = "~S={font_size=14pt font_weight=bold foreground=blue font_face='Algerian' TEXTDECORATION=underline}~Estabilidad"; ods text = " "; ods text = "~S={font_size=11pt font_weight=bold}~ 1. Tabla3"; ods text = " "; *Tabla 3; proc report data=RWORK.Tabla3 style(header)=[JUST = center FONT_FACE=Arial FONT_SIZE=10pt background = lightblue]; column Periodo P_Cuant P_Cual P_comportamental P_Final; define P_Cuant/ 'P. Cuantitativa'; define P_Cual/ 'P. Cualitativa'; define P_comportamental/ 'P. Comportamental'; define P_Final/ 'P. Final'; define Periodo / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=200 ASIS=on}; define P_Cuant / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=200 ASIS=on}; define P_Cual / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=200 ASIS=on}; define P_comportamental / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=200 ASIS=on}; define P_Final / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=200 ASIS=on}; run; ods text = " "; *______________________________________________________________________________________ I WOULD LIKE TO CHANGE HERE OF SHEET ______________________________________________________________________________________ ; ods text = "~S={font_size=11pt font_weight=bold}~ 2. Tabla 4"; ods text = " "; *Tabla 4; proc report data=RWORK.Tabla4 style(header)=[JUST = center FONT_FACE=Arial FONT_SIZE=10pt background = lightblue]; column Ks_estabilidad; define Ks_estabilidad/ 'Kolmogorov-Smirov'; define Ks_estabilidad / style(column) = {JUST=c FONT_FACE=Arial FONT_SIZE=10pt CELLWIDTH=250 ASIS=on}; run; ods excel close; ... View more