topic SAS connection through ODBC in SAS Enterprise Guide

SAS connection through ODBC

yue001 — Fri, 08 Feb 2019 21:34:53 GMT

Currently, I am using SAS E guide locally and trying to set up the connection between SAS and a database. The one I wanted to use is called XXX, i can find it through ODBC data source administrator->system DSN->System Data Sources: Name XXX, Driver SQL server. Could you please let me know if I have what I need to set up the connection? So that I can access tables on this XXX database in SAS. If so, how do I do it? Sorry if this question seems dumb to you. I really cannot find anyone to help me with this issue.

Re: SAS connection through ODBC

SuryaKiran — Fri, 08 Feb 2019 22:10:14 GMT

Hello,

Welcome to SAS Community!

You require SAS/Access interface to ODBC. Run the below code to check if you have it or not.

proc setinit;
run;

If you don't have it, then you can't connect using ODBC.

If it is listed then you can assign a LIBANME to access the data in it. (DSN is the data source name that you assign in ODBC connection setup)

libname mydb odbc dsn=XXXX user= password= schema=;

Re: SAS connection through ODBC

LinusH — Mon, 11 Feb 2019 11:37:28 GMT

Theoretically, you can connect directly from your EG client, and trhen SAS/ACCESS is not needed.

But, should inly be considered for test/small data sets, since this connection cannot be optimized the same way as athe fully fledget ACCESS engine from the SAS session..