Skip to content
Advertisement

SAS pass through query to SQL Server

I have some troubles with passing through query to SQL Server. OS is RedHat 6. In SAS Enterprise Guide I try to execute this code:

but I faced with error:

ERROR: CLI execute error: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]INSERT failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. : [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Statement(s) could not be prepared.

If I try to put QUOTED_IDENTIFIER option into execute statement it works properly:

Are there any opportunities to put QUOTED_IDENTIFIER into LIBNAME STATEMENT using SQLSVR? SAS/ACCESS components for ODBC and OLEDB are not licensed.

Advertisement

Answer

@Jdzel What type of connection do you use?

Try to add parameter CONNECTION=SHAREDREAD.
Libname stetement will be like:

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement