07-22-2015 04:15 AM
As far as I am aware there is not method of doing this in tagsets.excelxp or libname excel. What I would suggest, as you seem to want to use a lot of Excel functionality, is to create a template Excel file, which has the layout you want. Export your data as CSV from SAS. Now, in your Excel file write a small VBA macro which opens and reads in the CSV file, and processes the data into the template.