topic Libname to create a connection to Access DB in SAS Programming

Libname to create a connection to Access DB

TMiller16 — Tue, 15 Nov 2016 22:15:05 GMT

Can someone give me the Code to create a library using an Access DB on a local server (X:ab/cd/ef.accbd)

Re: Libname to create a connection to Access DB

PGStats — Wed, 16 Nov 2016 03:54:11 GMT

Typically it is as simple as

libname ac Access "X:ab/cd/ef.accdb" access=readonly;

What did you try?

Re: Libname to create a connection to Access DB

RahulG — Wed, 16 Nov 2016 03:58:51 GMT

To connect MS Access database, we need to create ODBC connection.

Need to create ODBC string then use that string to create MS Access Server in SAS Management console

Then you can either create library using wizard or write LIBNAME statement to use MS Access table

For more details refer to following link

http://support.sas.com/documentation/cdl/en/bidsag/68193/HTML/default/viewer.htm#n167cjb87i0x9wn1h1qynnb2zumc.htm

https://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#n1wvmggexroxgyn17rp61jml3cvn.htm

Re: Libname to create a connection to Access DB

TMiller16 — Wed, 16 Nov 2016 16:37:23 GMT

Thank you! that was the push I needed, now I am good with the connection.

When using SAS statements to JOIN two tbles, is it as simple as JOIN?

Re: Libname to create a connection to Access DB

PGStats — Wed, 16 Nov 2016 18:44:25 GMT

LIBNAME is a layer of abstraction that allows you (at least in principle) to ignore the exact origin of data tables. But you should always check the data type of imported table columns, especially date types.