topic Re: What are the database formats for SAS access to OBDC? in SAS Procedures

What are the database formats for SAS access to OBDC?

CesarOmarHR — Mon, 06 Oct 2014 15:55:11 GMT

Hi there

I know it's a pretty simple question, but what are the databases capable for import with SAS ACCESS TO OBDC?

I appreciate the help.

César

Re: What are the database formats for SAS access to OBDC?

LinusH — Mon, 06 Oct 2014 17:16:19 GMT

Pretty much any database that has an odbc driver. There can be limitations to data types supported. See on line doc for details.

Re: What are the database formats for SAS access to OBDC?

CesarOmarHR — Mon, 06 Oct 2014 17:20:49 GMT

Do you know the data types that are supported?

i'm thinking MySql, Sql, .dat are there any others?

Re: What are the database formats for SAS access to OBDC?

jakarman — Mon, 06 Oct 2014 18:56:35 GMT

I your question is wich RDBMS systems support ODBC. Well ODBC is an open standard they should conform to.

If at the RDBMS software supplier they are claiming to support this than that is no question. The only question is if they are conforming that correctly (no errors).

Be aware of the confusion on dedicated interfaces being supported. They are often indicated as ODBC but are dedicated versions with a lot of additional functionality. Sometimes these are not available on all platforms. For example SQL-server is having dedicated drives at Windows but you are needing to switch to ODBC at Unix.

Datatypes within each RDBMS type is another part of the puzzle. Not all datatypes are equal. The interface is doing the translations. They can be found at:

SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Fifth Edition

As you can see it are the SAS-formats that are related to the data-type conversions. Numerics in SAS are always floating type. This is not the same within a RDBMS assuming numeric are equal to chars just having a dedicated range more like a constraint.

Re: What are the database formats for SAS access to OBDC?

Reeza — Mon, 06 Oct 2014 19:00:27 GMT

Isn't .dat a text file, not a data base?

Re: What are the database formats for SAS access to OBDC?

jakarman — Mon, 06 Oct 2014 19:41:27 GMT

Yep your are right Reeza CesarOmarHR is mixing up a lot. All three are really different:

- The rdbms system like MySql.

- A language you can use to access a rDBMS as SQL

- a text file in some text file (.dat) you can use to configure something like a rDBMS.

Re: What are the database formats for SAS access to OBDC?

Reeza — Mon, 06 Oct 2014 20:04:10 GMT

I think Linus answer is correct, anything with an ODBC Driver.

And SQL isn't one thing, there's T-SQL or MS SQL, Oracle SQL, MySQL, NoSQL, SQLLite and I'm sure there are others.

Re: What are the database formats for SAS access to OBDC?

jakarman — Mon, 06 Oct 2014 20:12:50 GMT

Open Database Connectivity - Wikipedia, the free encyclopedia