topic multiple proc output in a same excel sheet in ODS and Base Reporting

multiple proc output in a same excel sheet

rufmau68 — Wed, 21 Nov 2018 17:07:14 GMT

hi,

another question about ods excel or similar..

i need to output in only one excel sheet, a lot of proc report/proc tabulate output... but not one output in each sheet, and not all proc output vertically stacked all in one sheet, BUT horizzontal stacked....

like you see in attachment...

in ods excel sas 9.4 i cant use region/layout options and start_at options works only once...

i dont' know if anyone have eny workaround

thanks

bye

mauro

Re: multiple proc output in a same excel sheet

Reeza — Wed, 21 Nov 2018 17:10:26 GMT

Multiple to one sheet is fine, but I don't think SAS can do this at the moment. R will, you can use the XLSX package to accomplish this. Otherwise you need VBS most likely. It depends on how complex your report is.

Re: multiple proc output in a same excel sheet

SuryaKiran — Wed, 21 Nov 2018 17:28:52 GMT

You can't do that using SAS alone, you may need to use VBA also. Look at this "%EXCEL_ENHANCE" macro by @Chevell_sas

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/2174-2018.pdf

Re: multiple proc output in a same excel sheet

Reeza — Wed, 21 Nov 2018 17:33:07 GMT

RWI may be another option, but I only see HTML and PDF examples so far. If you only have one sheet with the multiple you can create an HTML file that Excel will display and then covert that using VBS script but its not guaranteed of course.