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.
... View more
One workaround is to right-click on the active sheet, choose Ungroup Sheets from the pop-up menu, and then save the file.
Vince DelGobbo
SAS R&D
... View more