Problem Note 49266: An error might occur when you use SAS® in-database processing with Base SAS® procedures
When you are using a Base SAS procedure that enables SAS in-database processing for Teradata, an error similar to one of the following might occur:
ERROR: Syntax error or access violation
Syntax error: Blank name in quotation marks.
ERROR: Error during in-database processing.
The error might occur when you use the DATABASE= connnection option in the LIBNAME statement and you reference that libref in a Base SAS procedure.
To work around this problem, do one of the following:
- Use SCHEMA="database-name".
- If there are no special characters in the database name, you can omit the quotation marks from the database name and use database=database-name.
Operating System and Release Information
| SAS System | N/A | z/OS | 9.3 TS1M1 | |
| Microsoft® Windows® for x64 | 9.3 TS1M1 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M1 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M1 | |
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M1 | |
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M1 | |
| Microsoft Windows Server 2008 | 9.3 TS1M1 | |
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M1 | |
| Microsoft Windows XP Professional | 9.3 TS1M1 | |
| Windows 7 Enterprise 32 bit | 9.3 TS1M1 | |
| Windows 7 Enterprise x64 | 9.3 TS1M1 | |
| Windows 7 Home Premium 32 bit | 9.3 TS1M1 | |
| Windows 7 Home Premium x64 | 9.3 TS1M1 | |
| Windows 7 Professional 32 bit | 9.3 TS1M1 | |
| Windows 7 Professional x64 | 9.3 TS1M1 | |
| Windows 7 Ultimate 32 bit | 9.3 TS1M1 | |
| Windows 7 Ultimate x64 | 9.3 TS1M1 | |
| Windows Vista | 9.3 TS1M1 | |
| Windows Vista for x64 | 9.3 TS1M1 | |
| 64-bit Enabled AIX | 9.3 TS1M1 | |
| 64-bit Enabled HP-UX | 9.3 TS1M1 | |
| 64-bit Enabled Solaris | 9.3 TS1M1 | |
| HP-UX IPF | 9.3 TS1M1 | |
| Linux for x64 | 9.3 TS1M1 | |
| Solaris for x64 | 9.3 TS1M1 | |
*
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.
Using SAS in-database processing with Base SAS might result in any of these errors: "Syntax error or access violation," "Syntax error: Blank name in quotation marks", or "Error during in-database processing"
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2014-09-18 17:26:00 |
| Date Created: | 2013-02-25 09:28:07 |
