Problem Note 37778: Errors might occur exporting a data set with more than 255 columns using SAS® Enterprise Guide®
 |  |  |  |  |
The following message might occur when exporting a SAS data set using SAS Enterprise Guide
An error occurred saving the file. Export job Unable to export the data to this type. There are NNN columns in the data, but the destination type only supports up to 255 columns.
SAS Enterprise Guide 3.x and 4.1 could export to TEXT/CSV that had more than 255 columns, but version 4.2 will generate the above error.
To circumvent the problem, use PROC EXPORT code similar to the following sample code to save the TEXT file onto the SAS server used by SAS Enterprise Guide.
proc export data=work.a outfile="myfile.csv" replace;
run;
|
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.2 TS2M0 | ||
A fix for this issue for SAS Enterprise Guide 4.305 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C44.html#37778A fix for this issue for SAS Enterprise Guide 4.3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D18.html#37778| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-11-12 11:22:06 |
| Date Created: | 2009-11-10 14:01:43 |