The SAS Output Delivery System and reporting techniques

Native Excel output?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 129
Accepted Solution

Native Excel output?

Are there any routines for outputting native Excel files yet? I'm running SAS 64 bit. Currently I'm using

ods markup tagset=ExcelXP file="File.xls";

to send procedure output to an XML file. Is there a way to actually create a native xls and/or xlsx file from SAS?


Accepted Solutions
Solution
‎10-30-2014 12:45 PM
SAS Employee
Posts: 88

Re: Native Excel output?

Posted in reply to BruceBrad

The ODS Excel destination is planned for SAS 9.4M3 which will generate native Excel files. It is there pre-production beginning with SAS 9.4M1.

View solution in original post


All Replies
Solution
‎10-30-2014 12:45 PM
SAS Employee
Posts: 88

Re: Native Excel output?

Posted in reply to BruceBrad

The ODS Excel destination is planned for SAS 9.4M3 which will generate native Excel files. It is there pre-production beginning with SAS 9.4M1.

Frequent Contributor
Posts: 129

Re: Native Excel output?

Posted in reply to Chevell_sas

Any comments on how it works in 9.4M1 (or M2)? Is it worth upgrading from 9.4M0?

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 480 views
  • 0 likes
  • 2 in conversation