07-06-2011 07:28 PM
There is a limit of 255 variables when using proc export to export files between 64 bit SAS and Excel (2007, 2010). SAS reports that the conversion has worked but the files are not readable in Excel. Has anyone else encountered this problem and if so what types of workarounds are you using? We are about to deploy 64 bit windows systems and would like to provide our end users as many mitigations as possible. Thanks in advance.
07-07-2011 12:22 AM
I know not very helpful for you,
We have come across other issues with Proc Export on Windows 7 and windows 2008 (64bit) envs logged issues but was told not fixing (by way of hotfix) and they are re-writing the EXPORT procedure for 9.3... The recomendation we were given were to use PC File Server to handle the exports.
Quote from TS "Regardless the answer is still the same, you have to use the pc file server to do this well until 9.3. "
12-19-2011 10:10 AM
One solution is to use Enterprise Guide. It will handle import and export to Excel. I have not test the number of variables. There is an add-in to EG from SAS for export to Excel 2007/10 files
03-09-2012 10:45 AM
The SolutionProvided in this article is Perfect with one adjustment for exports via PC Files:
PROC EXPORT DBMS=EXCELCS
DATA = MyLib.MyData
The Changes are in bold:
- Add version as 2007 for very large files
- leave out the file extention in the outfile name. this helps excel not to get confused with the extentions. if find it creates a .XLSB binary file but the data is perfectly fine!
You could also try the version statement without PC Files server, not sure if this works though!
Please dont hesitate to ask if i have not been very clear about anything....