Usage Note 65349: The Register Tables wizard returns "ERROR 22-322: Syntax error, expecting one of the following...HOST, ID..." when you run the METALIB procedure
When you register tables using the Register Tables wizard in SAS® Management Console or in SAS® Data Integration Studio, table registration might fail and return a message similar to the following:
proc metalib;
omr (LIBURI="A513JHN5.B400000C" / project_reposid = "A513JHN5" );
76
ERROR 22-322: Syntax error, expecting one of the following: ), HOST, ID, IPADDR, LIBID,
LIBRARY, LIBURI, METAPASS, METAPORT, METAPROTOCOL, METAREPOSITORY, METASERVER,
METAUSER, PASSWORD, PORT, PROTOCOL, PW, REPID, REPNAME, SERVER, SERVID, TSID,
USER, USERID.
The syntax error occurs when you use SAS® 9.4M5 (TS1M5) or earlier and either of the following are true:
- You use SAS Management Console 9.4_M6 or later.
- You use SAS Data Integration Studio 4.904 or later.
The syntax error occurs because the Register Tables wizard is generating code using syntax that is not supported by PROC METALIB in your SAS system.
To circumvent this error, perform one of the following workarounds:
- Use a version of SAS Management Console or SAS Data Integration Studio that is compatible with your SAS system. For example, if you run SAS 9.4M5 (TS1M5), use SAS Data Integration Studio 4.903. For a complete list of compatible versions, see SAS KB0036260, "Support matrices for SAS® clients with SAS®9."
- Save the PROC METALIB code that is generated by the Register Tables wizard, modify it to remove the PROJECT_REPOSID option, and submit the code using a SAS programming environment such as SAS Data Integration Studio or SAS® Enterprise Guide.
Operating System and Release Information
SAS System | SAS Data Integration Studio | Microsoft® Windows® for x64 | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows 8 Enterprise 32-bit | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows 8 Enterprise x64 | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows 8 Pro 32-bit | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows 8 Pro x64 | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows 8.1 Enterprise 32-bit | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows 8.1 Enterprise x64 | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows 8.1 Pro 32-bit | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows 8.1 Pro x64 | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows 10 | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows Server 2012 Datacenter | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows Server 2012 R2 Datacenter | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows Server 2012 R2 Std | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows Server 2012 Std | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows Server 2016 | 4.904 | | 9.4 TS1M6 | |
Microsoft Windows Server 2019 | 4.904 | | 9.4 TS1M6 | |
Windows 7 Enterprise 32 bit | 4.904 | | 9.4 TS1M6 | |
Windows 7 Enterprise x64 | 4.904 | | 9.4 TS1M6 | |
Windows 7 Home Premium 32 bit | 4.904 | | 9.4 TS1M6 | |
Windows 7 Home Premium x64 | 4.904 | | 9.4 TS1M6 | |
Windows 7 Professional 32 bit | 4.904 | | 9.4 TS1M6 | |
Windows 7 Professional x64 | 4.904 | | 9.4 TS1M6 | |
Windows 7 Ultimate 32 bit | 4.904 | | 9.4 TS1M6 | |
Windows 7 Ultimate x64 | 4.904 | | 9.4 TS1M6 | |
SAS System | SAS Management Console | Microsoft® Windows® for x64 | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows 8 Enterprise 32-bit | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows 8 Enterprise x64 | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows 8 Pro 32-bit | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows 8 Pro x64 | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows 8.1 Enterprise x64 | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows 8.1 Pro 32-bit | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows 8.1 Pro x64 | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows 10 | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows Server 2012 Datacenter | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows Server 2012 R2 Datacenter | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows Server 2012 R2 Std | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows Server 2012 Std | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows Server 2016 | 9.4_M6 | | 9.4 TS1M6 | |
Microsoft Windows Server 2019 | 9.4_M6 | | 9.4 TS1M6 | |
Windows 7 Enterprise 32 bit | 9.4_M6 | | 9.4 TS1M6 | |
Windows 7 Enterprise x64 | 9.4_M6 | | 9.4 TS1M6 | |
Windows 7 Home Premium 32 bit | 9.4_M6 | | 9.4 TS1M6 | |
Windows 7 Home Premium x64 | 9.4_M6 | | 9.4 TS1M6 | |
Windows 7 Professional 32 bit | 9.4_M6 | | 9.4 TS1M6 | |
Windows 7 Professional x64 | 9.4_M6 | | 9.4 TS1M6 | |
Windows 7 Ultimate 32 bit | 9.4_M6 | | 9.4 TS1M6 | |
Windows 7 Ultimate x64 | 9.4_M6 | | 9.4 TS1M6 | |
64-bit Enabled AIX | 9.4_M6 | | 9.4 TS1M6 | |
64-bit Enabled Solaris | 9.4_M6 | | 9.4 TS1M6 | |
HP-UX IPF | 9.4_M6 | | 9.4 TS1M6 | |
Linux for x64 | 9.4_M6 | | 9.4 TS1M6 | |
Solaris for x64 | 9.4_M6 | | 9.4 TS1M6 | |
*
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 Register Tables wizard in SAS® Management Console and SAS® Data Integration Studio returns the following error for PROC METALIB: "ERROR 22-322: Syntax error, expecting one of the following:),HOST, ID, IPADDR, LIBID, LIBRARY, LIBURI, METAPASS, METAPORT, METAPROTOCOL, METAREPOSITORY, METASERVE..."
Date Modified: | 2020-01-30 15:08:44 |
Date Created: | 2020-01-14 11:00:13 |