If you are receiving an error that the registration for a column does not exist in the metadata server, and that column does exists on the input table, then that column was probably added to the input table after the table was registered to the SAS^® Metadata Server. You can use one of the following methods to update the metadata for the input table.

Method I. If the column is on the input table but not in the metadata, first try importing the new column into the existing metadata registration for the table. To do this, follow these steps within SAS^® Management Console:

1. Under Environment Management, navigate to the table via the path:
   Data Library Manager ► SAS Libraries ► <your_libname>
2. In the right-hand pane, you should see your table listed within the library listing. Right-click on the table and select Properties.
3. Click the Columns tab, and then click the Import button at the lower right.
4. In the Import Columns dialog box, you should be able to move the currently unregistered columns to the Selected Columns pane. Click OK to save the changes.

Method II. If Method I does not work for you, or if the column already appears on the Columns tab, then you will must unregister the table and import it back in. This action could impact some references to this table, but that cannot be avoided. Therefore, if you can update the metadata by just importing the individual column, that is the recommended method to follow.

Method III. If you do not want to delete the table by using Method II, or if you want to update the table using SAS code, you can use PROC METALIB to update the metadata for the table. The METALIB procedure synchronizes table definitions in a SAS metadata repository with current information from the physical library data source.

Below is sample code that can be used to update the metadata for a table.

   proc metalib; 
      omr (library="Library" repname="Foundation" user="userid" 
           password="password" protocol=BRIDGE port="8561" 
           metaserver="hostname/ipaddress"); 

      update_rule=(delete); 

      select tablename;  /* optionally list table(s) to update. */
      report; 
   run; 

For more information about using PROC METALIB, see METALIB Procedure.

Operating System and Release Information