Hi All,
I have a requirement where i have to import a .db3 file into SAS. Is it possible to import a .db3 file into SAS.
ODBC (Open Database Connectivity) lets a process connect to database data via a standardized interface. Once a database system provides an ODBC driver, every ODBC-capable software can connect to it transparently (no special knowledge of the target necessary). So you need to have the ODBC driver for SQlite installed (.db3 is the standard file extension for SQlite files), and SAS/ACCESS to ODBC licensed.
AFAIK, SAS does not provide a direct interface to SQlite. You can use the connection to ODBC if you have the ODBC driver for SQlite installed.
I've used the ODBC driver to connect to SQLite DBs. So yes, you can connect to DB3 files.
hi @Kurt_Bremser and @Reeza Thank you for your replies.
Can you be a bit more detailed as i do not understand what you were saying.
i am having a .db3 file on my system and i need to import it. On checking with SAS docs, it was saying use proc dbf. But i am not able to import it.
ODBC (Open Database Connectivity) lets a process connect to database data via a standardized interface. Once a database system provides an ODBC driver, every ODBC-capable software can connect to it transparently (no special knowledge of the target necessary). So you need to have the ODBC driver for SQlite installed (.db3 is the standard file extension for SQlite files), and SAS/ACCESS to ODBC licensed.
@naveenraj wrote:
i am having a .db3 file on my system and i need to import it. On checking with SAS docs, it was saying use proc dbf. But i am not able to import it.
PROC DBF is for importing/exporting dBase files. But the .db3 extension is not only used by dBase, but also by the SQlite system. If your .db3 file is not a dBase file, PROC DBF will fail.
Check with your data provider the exact nature of the file.
Please let me know if i understand this correctly. SAS EG cannot import .db3 sqllite files directly.
Instead we have to create a ODBC to the sqllite DB's and create libraries through which we can import data to SAS environment
Depends on what you mean by directly. It's the same method as to connect to any database really.
DB3 is a database not a file.
At the same time DB3 is a text file so you can open it with a text editor so you could theoretically process it with a datastep but that wouldn't be very fun.
To avoid this kind of hassles, it is always best to use a text-based file format for data transfer between systems.
Any DB system can export to csv, and read back from csv. This, of course, includes SAS.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.