Help using Base SAS procedures

Export to .xlsx on UNIX

Reply
New Contributor
Posts: 3

Export to .xlsx on UNIX

I am trying to output a SAS dataset with observations > 65k into a excel file on UNIX server.we have SAS 9.2 TS2M2 on a AIX platform(64 bit).

Tried to export using proc export - DBMS = XLS  but only 65k rows are getting output to excel file.

Any work arounds for exporting datasets with > 65k to a excel file on Unix.

Thanks,

G.Venkatesh.

Super User
Posts: 3,257

Re: Export to .xlsx on UNIX

Posted in reply to Venkatesh_gajula

You should try DBMS = XLSX. This is the new XML standard introduced in Excel 2007 that enables you to write more than 64,767 rows to a spreadsheet.

What version of Excel will you be using to read these spreadsheets? There are other issues related to whether your version of Excel is 32-bit or 64-bit. Excel 2007 is 32-bit, Excel 2010 is either 32-bit or 64-bit. You may also require the SAS PC File Server software to handle 32-bit to 64-bit translation.

Check out the numerous SAS notes on these topics.

New Contributor
Posts: 3

Re: Export to .xlsx on UNIX

This option of DBMS=XLSX does not support in SAS 9.2. i still tried to run it and got the error.

Super User
Posts: 3,257

Re: Export to .xlsx on UNIX

Posted in reply to Venkatesh_gajula

Sorry, you are correct. XLSX is not supported until 9.3 TS1. As a quick workaround you could export as a CSV, then ensure that it is imported by Excel 2007 or later.

New Contributor
Posts: 3

Re: Export to .xlsx on UNIX

Yeah... looks like there is no way to get this done,because i have to export to multiple sheet in single excel workbook.

Ask a Question
Discussion stats
  • 4 replies
  • 631 views
  • 0 likes
  • 2 in conversation