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.
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.
This option of DBMS=XLSX does not support in SAS 9.2. i still tried to run it and got the error.
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.
Yeah... looks like there is no way to get this done,because i have to export to multiple sheet in single excel workbook.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.