topic Re: output excel as an Excel table (ctrl+t)? in Microsoft Integration with SAS

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

gzr2mz39 — Fri, 16 Dec 2016 18:29:24 GMT

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.

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

Kurt_Bremser — Fri, 16 Dec 2016 21:40:06 GMT

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.

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

gzr2mz39 — Fri, 16 Dec 2016 21:49:55 GMT

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.

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

ballardw — Fri, 16 Dec 2016 22:00:03 GMT

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.

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

Kurt_Bremser — Mon, 19 Dec 2016 07:58:52 GMT

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.