SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 18039: "ERROR: numeric expression requires numeric format"

DetailsHotfixAboutRate It

One or both of the following error messages may be issued when using SAS/ACCESS® Interface to MySQL to access a table with a LONGTEXT or LONGBLOB data type using SAS 9.1.3 Service Pack 4. This problem does not occur with SAS® 9.1.3 Service Pack 3.

  ERROR: Numeric expression requires numeric format.

  ERROR: Length of the numeric variable content must be between 3 and 8.

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



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to MySQLLinux9.1 TS1M3 SP49.2 TS1M0
64-bit Enabled Solaris9.1 TS1M3 SP49.2 TS1M0
64-bit Enabled HP-UX9.1 TS1M3 SP49.2 TS1M0
64-bit Enabled AIX9.1 TS1M3 SP49.2 TS1M0
* 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.