Help using Base SAS procedures

What are the database formats for SAS access to OBDC?

Reply
Contributor
Posts: 36

What are the database formats for SAS access to OBDC?

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

Super User
Posts: 5,426

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

Posted in reply to CesarOmarHR

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

Data never sleeps
Contributor
Posts: 36

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

Do you know the data types that are supported?

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

Super User
Posts: 19,772

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

Posted in reply to CesarOmarHR

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

Trusted Advisor
Posts: 3,212

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

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.

---->-- ja karman --<-----
Trusted Advisor
Posts: 3,212

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

Posted in reply to CesarOmarHR

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.
 

---->-- ja karman --<-----
Super User
Posts: 19,772

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

Posted in reply to CesarOmarHR

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.

Trusted Advisor
Posts: 3,212

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

Ask a Question
Discussion stats
  • 7 replies
  • 222 views
  • 1 like
  • 4 in conversation