Solved: Native Excel output? - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Lapis Lazuli | Level 10

Lapis Lazuli | Level 10

Native Excel output?

Posted 10-30-2014 12:37 AM (2810 views)

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?

1 ACCEPTED SOLUTION

Accepted Solutions

SAS Employee

SAS Employee

Re: Native Excel output?

Posted 10-30-2014 12:45 PM (3018 views) | 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

2 REPLIES 2

SAS Employee

SAS Employee

Re: Native Excel output?

Posted 10-30-2014 12:45 PM (3019 views) | 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.

Lapis Lazuli | Level 10

Lapis Lazuli | Level 10

Re: Native Excel output?

Posted 10-30-2014 07:02 PM (2667 views) | In reply to Chevell_sas

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