SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 15253: "ERROR: Invalid number" issued when re-ordering columns and using the old metadata update with PROC METALIB

DetailsHotfixAboutRate It

The following error message may be returned when columns are re-ordered and the old metadata update is used with PROC METALIB.

ERROR: Invalid number

The steps below demonstrate how to replicate this problem using any type of table (SAS®, DB2, Oracle, etc.):

  1. Import table metadata.
  2. Delete a column.
  3. Perform old update table metadata.
  4. Delete the column that was added.
  5. Perform new update table metadata.

You will receive this error even if the columns are re-ordered using the property sheet of the table registered.

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 SystemBase SAS64-bit Enabled Solaris9.1 TS1M39.1 TS1M3 SP3
64-bit Enabled HP-UX9.1 TS1M39.1 TS1M3 SP3
z/OS9.1 TS1M39.1 TS1M3 SP3
Linux9.1 TS1M39.1 TS1M3 SP3
Microsoft Windows XP Professional9.1 TS1M39.1 TS1M3 SP3
64-bit Enabled AIX9.1 TS1M39.1 TS1M3 SP3
* 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.