Advanced Search

Access SQLite Database from SAS

/ Published in: SAS
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. /************************************************
  2. * ACCESS SQLITE DATABASE FROM SAS               *
  3. * REQUIREMENT:                                  *
  4. *   HAVE SQLITE ODBC DRIVER INSTALLED           *
  5. ************************************************/
  6.  
  7. libname sqlite odbc complete = "dsn=SQLite; 
  8.                                 Driver={SQLite3 ODBC Driver};
  9.                                 Database=C:\folder\mydatabase.db";

URL: http://jaredprins.squarespace.com/blog/2008/9/30/connect-to-sqlite-database-using-sas.html

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.