06-06-2017 08:17 AM
I am trying to prepare a report in Excel using ODS Excel in SAS. The report contains two sheets with three tables place side by side. I used Panelcol option but it is not available in ODS Excel. Also, the Start_at= option does not seem to be working?
Is there anyway it can be done in ODS Excel? Please let me know. Any help will be very much appreciated.
06-06-2017 09:04 AM
Ksharp, thank you for your reply. But, I want the excel file with .xlsx extension. Also, it produces the html output and it does not support the multisheet workbook.
Is there any better approach to this problem?
06-06-2017 09:35 AM
Proc EXPORT to specified ranges but you have to do the 'math' to figure out the ranges. But this doesn't provide formatting options.
Another option is create a pre-formatted template in Excel and export to the template.