Is there a way to read a SQLite database using SAS? Is there an ACCESS Interface available? There is an R application that writes to a SQLite database and I'm trying to figure out a way to read the data generated in the app. Any ideas? I'm running SAS 9.3.2 in Windows 7. We have SAS Access for ODBC. With the right driver, can it be used to read SQLite?
as you can access SQLite and having sas/access that should be able to be used.
SQLite ODBC Driver (www.ch-werner.de/sqliteodbc) take care of the bitness. With a 32-bit SAS you are needing a 32-bit driver with a 64-bit SAS the 64-bit driver.
If you have IML you could connect that one to R.
as you can access SQLite and having sas/access that should be able to be used.
SQLite ODBC Driver (www.ch-werner.de/sqliteodbc) take care of the bitness. With a 32-bit SAS you are needing a 32-bit driver with a 64-bit SAS the 64-bit driver.
If you have IML you could connect that one to R.
Funny you should ask. I am working on a SQL Pass-through engine for SQLite v3 right now. I am recruiting anyone interested in beta-testing the engine. If you are interested, reply. The engine does not require SAS/ACCESS for ODBC, etc. This is an internal SAS pass-through engine (see below for the LIBNAME engine, information).
Current status on SQLite Pass-Through engine (SQLitePT):
The Pass-through engine was my first effort because it is relatively simple [except for data typing, the SQLitePT engine is almost a direct mapping between the SAS Pass-through API requests and SQLite API fulfiller]. This is my introduction to the SQLite API.
It will be followed by a SQLite LIBNAME engine later this year or early next year. This is partially written but nowhere near beta-testing. Most likely January before a beta version would be available since I have a day-job and this ain't it :smileygrin: -- this is just promotion-ware).
I'm toying with a Cassandra interface.
Dear Ms/Mr Noodle,
We are interested in your "SQL Pass-through engine for SQLite v3".
We are running Red Hat Linux on our server (2.6.32-431.20.3.el6.x86_64). Would that be compatible with your DLL?
Thanks.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.