请教：SAS程序中如何直接调用SQL Server数据库的数据

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

电脑上装的是SAS 9.4， SQL Server2014 express

libname mydblib sqlsvr
        noprompt="uid=xxx;
        pwd=;
        dsn=sqlservr;"
        stringdates=yes;

xxx是sql server的用户名，密码为空。运行后错误是：

1    libname mydblib sqlsvr
2        noprompt="uid=Think";
3        pwd=;
4        dsn=sqlservr;"
5        stringdates=yes;
ERROR: The SQLSVR engine cannot be found.
ERROR: Error in the LIBNAME statement

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

关键词：Server Serve sas程序 Ver sql 数据库 程序 如何

现在数据源做ODBC连接

能再解说得详细些么？在网上查来查去也没有找到解决方案。多谢了

可能性较大的原因是你装的SAS版本没有SQL SERVER的engine~
你可以用proc setinit;run;看一下
如果只有ODBC（网上流传的盗版一般都有）的引擎建议通过odbc来连sql server 在控制面板里配好dsn libname a odbc datasrc=xxx uid=xxx pwd=xxx;

tompiano 发表于 2015-12-10 14:26
可能性较大的原因是你装的SAS版本没有SQL SERVER的engine~
你可以用proc setinit;run;看一下
如果只有ODB ...

检查结果如下，有sas/access interface to MS sql server

Product expiration dates:
---Base SAS Software
      31JUL2016
---SAS/STAT
      31JUL2016
---SAS/GRAPH
      31JUL2016
---SAS/ETS
      31JUL2016
---SAS/FSP
      31JUL2016
---SAS/OR
      31JUL2016
---SAS/AF
      31JUL2016
---SAS/IML
      31JUL2016
---SAS/QC
      31JUL2016
---SAS/SHARE
      31JUL2016
---SAS/ASSIST
      31JUL2016
---SAS/CONNECT
      31JUL2016
---SAS/EIS
      31JUL2016
---SAS/SHARE*NET
      31JUL2016
---MDDB Server common products
      31JUL2016
---SAS Integration Technologies
      31JUL2016
---SAS/Secure 168-bit
      31JUL2016
---SAS/Secure Windows
      31JUL2016
---SAS Enterprise Guide
      31JUL2016
---SAS Bridge for ESRI
      31JUL2016
---OR OPT
      31JUL2016
---OR PRS
      31JUL2016
---OR IVS
      31JUL2016
---OR LSO
      31JUL2016
---SAS/ACCESS Interface to DB2
      31JUL2016
---SAS/ACCESS Interface to Oracle
      31JUL2016
---SAS/ACCESS Interface to Sybase
      31JUL2016
---SAS/ACCESS Interface to PC Files
      31JUL2016
---SAS/ACCESS Interface to ODBC
      31JUL2016
---SAS/ACCESS Interface to OLE DB
      31JUL2016
---SAS/ACCESS Interface to Teradata
      31JUL2016
---SAS/ACCESS Interface to Microsoft SQL Server
      31JUL2016
---SAS/ACCESS Interface to MySQL
      31JUL2016
---SAS/IML Studio
      31JUL2016
---SAS Workspace Server for Local Access
      31JUL2016
---SAS/ACCESS Interface to Netezza
      31JUL2016
---SAS/ACCESS Interface to Aster nCluster
      31JUL2016
---SAS/ACCESS Interface to Greenplum
      31JUL2016
---SAS/ACCESS Interface to Sybase IQ
      31JUL2016
---SAS/ACCESS to Hadoop
      31JUL2016
---SAS/ACCESS to Vertica
      31JUL2016
---SAS/ACCESS to Postgres
      31JUL2016
---SAS/ACCESS Reserved Slot 565
      31JUL2016
---SAS/ACCESS Reserved Slot 567
      31JUL2016
---High Performance Suite
      31JUL2016
---SAS/ACCESS to SAP HANA
      31JUL2016

诶 楼主的你9.4模块好全啊 分享一下安装包如何？是在哪个帖子下的也行 我下了几个版本都没有Oracle引擎
我之前用过较多的是Oracle和MySQL的直连 Oracle是需要配环境变量目录 MySQL是需要将libmysql.dll拷到系统目录或SAS目录下
说到底都需要能找到对应的引擎驱动 你试试把sqlsvr32.dll拷到SAS Foundation\9.4\这个目录下吧~ 说不定能连上

tompiano 发表于 2015-12-10 14:45
诶 楼主的你9.4模块好全啊 分享一下安装包如何？是在哪个帖子下的也行 我下了几个版本都没有Oracle引擎
我 ...

这里：

[_SID_]
Version=9.4
Revision=9.4
Platform_long=Microsoft Windows Workstation for x64
Platform_short=wx6
Order=9BC8WC
License_prod=SAS
Setnumid=70109265
SID_schema=2
ph_agreement=PROMPT
SID_header=SAS 9.4
[_Info_]
[_FileData_]
$_Filename=setinit.sss
$_Path=sas\core\sasinst\
$_Date=
$_Time=
$_Stream=-------------------- BEGIN --------------------
PROC SETINIT RELEASE='9.4';
SITEINFO NAME='LICENCE GRATUITE EAS WINDOWS 64 BITS'
SITE=70109265 OSNAME='WX64_WKS' RECREATE
BIRTHDAY='24JUL2015'D  EXPIRE='31JUL2016'D PASSWORD=905138460;
CPU MODEL=' ' MODNUM=' ' SERIAL=' ' NAME=CPU000;
EXPIRE 'PRODNUM000' 'PRODNUM001' 'PRODNUM002' 'PRODNUM003'
'PRODNUM004' 'PRODNUM005' 'PRODNUM006' 'PRODNUM007'
'PRODNUM008' 'PRODNUM010' 'PRODNUM013' 'PRODNUM015'
'PRODNUM025' 'PRODNUM035' 'PRODNUM070' 'PRODNUM075'
'PRODNUM094' 'PRODNUM095' 'PRODNUM119' 'PRODNUM123'
'PRODNUM164' 'PRODNUM165' 'PRODNUM166' 'PRODNUM167'
'PRODNUM192' 'PRODNUM194' 'PRODNUM204' 'PRODNUM208'
'PRODNUM209' 'PRODNUM215' 'PRODNUM219' 'PRODNUM222'
'PRODNUM225' 'PRODNUM535' 'PRODNUM538' 'PRODNUM550'
'PRODNUM555' 'PRODNUM557' 'PRODNUM560' 'PRODNUM561'
'PRODNUM563' 'PRODNUM564' 'PRODNUM565' 'PRODNUM567'
'PRODNUM677' 'PRODNUM884' '31JUL2016'D / CPU=CPU000;
SAVE; RUN;
*DROPPED SAS/INSIGHT;
*DROPPED SAS/LAB;
*DROPPED SAS/Secure Windows;
*PRODNUM000 = BASE Base SAS;
*PRODNUM001 = STAT SAS/STAT;
*PRODNUM002 = GRAPH SAS/GRAPH;
*PRODNUM003 = ETS SAS/ETS;
*PRODNUM004 = FSP SAS/FSP;
*PRODNUM005 = OR SAS/OR;
*PRODNUM006 = AF SAS/AF;
*PRODNUM007 = IML SAS/IML;
*PRODNUM008 = QC SAS/QC;
*PRODNUM010 = SHARE SAS/SHARE;
*PRODNUM013 = ASSIST SAS/ASSIST;
*PRODNUM015 = CONNECT SAS/CONNECT;
*PRODNUM025 = EIS SAS/EIS;
*PRODNUM035 = SHARENET SAS/SHARE*NET;
*PRODNUM070 = MDDBCOM MDDB Server common products;
*PRODNUM075 = INTTECHSRV SAS Integration Technologies;
*PRODNUM094 = SECUREBNDL SAS/Secure;
*PRODNUM095 = SECUREWBNDL SAS/Secure Windows;
*PRODNUM119 = EGUIDE SAS Enterprise Guide;
*PRODNUM123 = ESRIBRDGORD SAS Bridge for ESRI;
*PRODNUM164 = OROPT SAS/OR Optimization;
*PRODNUM165 = ORPRS SAS/OR Project and Resource Scheduling;
*PRODNUM166 = ORIVS SAS/OR Interactive Visualization and Simulation;
*PRODNUM167 = ORLSO SAS/OR Local Search Optimization;
*PRODNUM192 = DB2BNDL SAS/ACCESS DB2;
*PRODNUM194 = ORACLEBNDL SAS/ACCESS ORACLE;
*PRODNUM204 = SYBASE SAS/ACCESS SYBASE SQL;
*PRODNUM208 = PCFILE SAS/ACCESS PC Files;
*PRODNUM209 = ODBC SAS/ACCESS ODBC;
*PRODNUM215 = OLEDB SAS/ACCESS TO OLE DB;
*PRODNUM219 = TERADATABNDL SAS/ACCESS Teradata;
*PRODNUM222 = MSSQLSERVER SAS/ACCESS MS SQL Server;
*PRODNUM225 = MYSQL SAS/ACCESS Intface MYSQL;
*PRODNUM535 = STATSTUDIO SAS/IML Studio;
*PRODNUM538 = WKSPSRVLOCAL SAS Workspace Server for Local Access;
*PRODNUM550 = NETEZZABNDL SAS/ACCESS Netezza;
*PRODNUM555 = ASTERBNDL SAS/ACCESS Interface to Aster nCluster;
*PRODNUM557 = GREENPLMBNDL SAS/ACCESS Interface to Greenplum;
*PRODNUM560 = SYBASEIQBNDL SAS/ACCESS Interface to Sybase IQ;
*PRODNUM561 = HADOOPBNDL SAS/Access Interface to Hadoop;
*PRODNUM563 = VERTICABNDL SAS/ACCESS Interface to Vertica;
*PRODNUM564 = POSTGRESBNDL SAS/ACCESS Interface to PostgreSQL;
*PRODNUM565 = IMPALABNDL SAS/ACCESS Interface to Impala;
*PRODNUM567 = HAWQBNDL SAS/Access Interface to HAWQ;
*PRODNUM677 = HPS SAS High-Performance Server;
*PRODNUM884 = SAPHANABNDL SAS/ACCESS Interface SAP HANA;
*LICENSE=SAS 000001873523;
*SITEID=595791;
*0094053005 9.4;
*XYZ 595791;
$_Stream=--------------------- END ---------------------
$_Filename=tletter.txt
$_Path=.\
$_Date=
$_Time=
$_Stream=-------------------- BEGIN --------------------
Microsoft Windows Workstation for x64
All Standard SAS/ACCESS Engines        31JUL2016
Base SAS        31JUL2016
Education Analytical Suite        31JUL2016
SAS Bridge for Esri        31JUL2016
SAS Enterprise Guide        31JUL2016
SAS Integration Technologies        31JUL2016
SAS/ACCESS Interface to Aster        31JUL2016
SAS/ACCESS Interface to DB2        31JUL2016
SAS/ACCESS Interface to Greenplum        31JUL2016
SAS/ACCESS Interface to HAWQ        31JUL2016
SAS/ACCESS Interface to Hadoop        31JUL2016
SAS/ACCESS Interface to Impala        31JUL2016
SAS/ACCESS Interface to Microsoft SQL Server        31JUL2016
SAS/ACCESS Interface to MySQL        31JUL2016
SAS/ACCESS Interface to Netezza        31JUL2016
SAS/ACCESS Interface to ODBC        31JUL2016
SAS/ACCESS Interface to OLE DB        31JUL2016
SAS/ACCESS Interface to Oracle        31JUL2016
SAS/ACCESS Interface to PC Files        31JUL2016
SAS/ACCESS Interface to PostgreSQL        31JUL2016
SAS/ACCESS Interface to SAP HANA        31JUL2016
SAS/ACCESS Interface to Sybase        31JUL2016
SAS/ACCESS Interface to Sybase IQ        31JUL2016
SAS/ACCESS Interface to Teradata        31JUL2016
SAS/ACCESS Interface to Vertica        31JUL2016
SAS/AF        31JUL2016
SAS/ASSIST        31JUL2016
SAS/CONNECT        31JUL2016
SAS/EIS        31JUL2016
SAS/ETS        31JUL2016
SAS/FSP        31JUL2016
SAS/GRAPH        31JUL2016
SAS/IML        31JUL2016
SAS/OR        31JUL2016
SAS/QC        31JUL2016
SAS/SHARE        31JUL2016
SAS/STAT        31JUL2016
$_Stream=--------------------- END ---------------------
[_EOF_]

stayhungry05 发表于 2015-12-10 15:00
这里：

[_SID_]

额。。。我是想要安装包 不是sid...

stayhungry05 发表于 2015-12-10 15:00
这里：

[_SID_]

额。。。我是想要安装包 不是sid...

tompiano 发表于 2015-12-10 15:13
额。。。我是想要安装包 不是sid...

记得就是在这个论坛找到的连接，百度云下载的。没有保留原始贴子，你搜搜看