SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 61853: "WARNING: The length of column 1 exceeds the maximum of 254 allowed by dBASE..." might occur when you use the EXPORT procedure

DetailsHotfixAboutRate It

When you use PROC EXPORT with the DBMS=DBF option to create a .dbf file from a SAS® data set, messages similar to the following occur in the SAS log:

WARNING: The length of column 1 exceeds the maximum of 254 allowed by dBASE. The column will be truncated.
WARNING: Some character data was lost during transcoding data: aaa

In this scenario, variable length is truncated to 254 characters.

You encounter this issue if you submit code similar to the following:

data work.to_export;
 length a $255.;
 a = 'aaa';
run;
proc export 
     data=to_export 
     dbms=dbf
     outfile='/tmp/a.dbf'
     replace;
     dbencoding=pcoem866;
run;

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemBase SASMicrosoft Windows 8 Pro 32-bit9.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows 8 Enterprise x649.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows 8 Enterprise 32-bit9.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft® Windows® for x649.4_M49.4_M59.4 TS1M49.4 TS1M5
z/OS 64-bit9.4_M49.4_M59.4 TS1M49.4 TS1M5
z/OS9.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows 8 Pro x649.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows 8.1 Enterprise 32-bit9.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows 8.1 Enterprise x649.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows 8.1 Pro 32-bit9.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows 8.1 Pro x649.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows 109.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows Server 20089.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows Server 2008 R29.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows Server 2008 for x649.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows Server 2012 Datacenter9.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows Server 2012 R2 Datacenter9.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows Server 2012 R2 Std9.4_M49.4_M59.4 TS1M49.4 TS1M5
Microsoft Windows Server 2012 Std9.4_M49.4_M59.4 TS1M49.4 TS1M5
Windows 7 Enterprise 32 bit9.4_M49.4_M59.4 TS1M49.4 TS1M5
Windows 7 Enterprise x649.4_M49.4_M59.4 TS1M49.4 TS1M5
Windows 7 Home Premium 32 bit9.4_M49.4_M59.4 TS1M49.4 TS1M5
Windows 7 Home Premium x649.4_M49.4_M59.4 TS1M49.4 TS1M5
Windows 7 Professional 32 bit9.4_M49.4_M59.4 TS1M49.4 TS1M5
Windows 7 Professional x649.4_M49.4_M59.4 TS1M49.4 TS1M5
Windows 7 Ultimate 32 bit9.4_M49.4_M59.4 TS1M49.4 TS1M5
Windows 7 Ultimate x649.4_M49.4_M59.4 TS1M49.4 TS1M5
64-bit Enabled AIX9.4_M49.4_M59.4 TS1M49.4 TS1M5
64-bit Enabled Solaris9.4_M49.4_M59.4 TS1M49.4 TS1M5
HP-UX IPF9.4_M49.4_M59.4 TS1M49.4 TS1M5
Linux for x649.4_M49.4_M59.4 TS1M49.4 TS1M5
Solaris for x649.4_M49.4_M59.4 TS1M49.4 TS1M5
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.