12-16-2016 04:40 PM
For Excel support, consult a Microsoft-oriented forum.
Or do you need help in exporting SAS data to Excel? In that case, use proc export.
12-16-2016 04:49 PM
What I'm trying to accomplish is exporting to excel and have the data automatically formatted as a Table.
So, instead of exporting the data, opening it in excel, and then formatting it as a Table (which can be accomplished by highlighting the data and pressing ctrl+t), I would like the table to be already formatted as a Table when it's exported by SAS.
12-16-2016 05:00 PM
Once again for the Excel-centric: How and what are you currently moving the SAS results to Excel? If using proc export to send a dataset likely there is no solution as that procedure is intended for data interchange files and contains no formatting information at all on purpose.
Procedure output may be another matter.
Have you tried using ODS EXCELXP ? That creates xml that Excel can read and I would expect it bring it results as tablish of sorts.
Be aware that Excel will reformat things and you may have to spend time forcing values with leading zeroes to appear correctly.
12-19-2016 02:58 AM
Using ods tagsets.excelxp or ods excel (if you run SAS 9.4) allows you to create formatted spreadsheets.
But be aware that it will take more work than just hitting ctrl-t.