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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.