output excel as an Excel table (ctrl+t)?

[gzr2mz39]

Hi,
Is it possible to output an excel file with the data formatted as a table (ctrl+t)?
If so, how can this be done?
Thank you.

[Kurt_Bremser]

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.

[gzr2mz39]

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.

[ballardw]

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.

[Kurt_Bremser]

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.