Connecting to Vertica from SAS
Posted: Wed Aug 01, 2012 3:59 am
I was able to connect SAS to Vertica from a Windows OS. After setting up and testing the ODBC connection I used this syntax to create a SAS library.
The tricky part is remembering to include the schema name.
Example:
The tricky part is remembering to include the schema name.
Code: Select all
LIBNAME <VerticaLibaryName> DATASRC='<ODBCDataSourceName' USER='<UserName>' PASSWORD='<Password>' SCHEMA='<SchemaName>';
Code: Select all
LIBNAME EDW DATASRC='ODBC_EDW' USER='MyNameHere' PASSWORD='MyPasswordHere' SCHEMA='public';