Problem Note 36253: ERROR 22-7: "Invalid option name", "Library is not assigned", "Error in the LIBNAME statement"
If you define a SAS® Table Server library in SAS® Management Console that has a blank space in the data source name, and you try to assign the library using the META LIBNAME engine, you will receive the following errors in your SAS log:
ERROR 22-7: Invalid option name second_word.
ERROR: Libname libref is not assigned.
ERROR: Error in the LIBNAME statement.
In the error message, second_word is the string of characters that follows the first blank space character in the data source name.
To circumvent the problem, you must do the following:
-
In SAS Management Console, expand the Table Server Manager plug-in, then expand the Table Server Logical Server.
- Click the Data Source Names folder and select the data source name in the right pane that contains the space.
- Open the properties for this data source name and edit the name to remove any blank spaces.
-
Open the properties for the library in the Data Library Manager plug-in, select the Options tab and remove any blank spaces from the Data Source Name value.
-
Disconnect from your application server in SAS Enterprise Guide and reconnect.
You should be able to successfully assign the Table Server library.
Operating System and Release Information
| SAS System | SAS Metadata Server | z/OS | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista | 9.2 TS2M0 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 9.2 TS2M0 | 9.3 TS1M0 |
| 64-bit Enabled HP-UX | 9.2 TS2M0 | 9.3 TS1M0 |
| 64-bit Enabled Solaris | 9.2 TS2M0 | 9.3 TS1M0 |
| HP-UX IPF | 9.2 TS2M0 | 9.3 TS1M0 |
| Linux | 9.2 TS2M0 | 9.3 TS1M0 |
| Linux for x64 | 9.2 TS2M0 | 9.3 TS1M0 |
| Solaris for x64 | 9.2 TS2M0 | 9.3 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.
The META Libname engine is unable to assign a SAS® Table Server library if the data source name contains a blank space.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> SAS Libraries
|
| Date Modified: | 2010-06-14 12:44:54 |
| Date Created: | 2009-06-17 13:40:04 |
