BookmarkSubscribeRSS Feed
GreenCode
SAS Employee

sqlite libname 引擎,可以通过libname语句直接访问sqlite数据库,目前只有Windows 64位版本,下载地址: https://github.com/SASAnalyser/PROC-JIEBA/releases/download/1.0/libname-sqlite_win_x64.zip

 

安装方法:下载上面文件解压到 <SASHome>\SASFoundation\9.4\core\sasexe 下面就可以,因为是静太连接sqlite库所以不需要安装sqlite。

 

使用方法如下,如果sqlite数据库文件不存在,将会创建一个:

/* write to sqlite database */

libname mylib sqlite "C:/temp/sample.db";

data mylib.air;

set sashelp.air;

run;

/* read from sqlite database */

libname mylib sqlite "C:/temp/sample.db";

data air;

set mylib.air;

run;

 

已知限制:目前不支持bulkload,不支持在Base SAS里直接打开sqlite数据表和看表属性,不支持sqlite的BLOB类型

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Discussion stats
  • 0 replies
  • 881 views
  • 0 likes
  • 1 in conversation