07-16-2012 11:41 AM
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.
07-16-2012 04:02 PM
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.
07-16-2012 09:58 PM
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.