可以试一下
sas 的sql的执行相率完全不能和专业的数据库管理软件比较,更何况还通过odbc转换。
你可以尝试使用proc sql步的Pass-Through技术。
The SQL Procedure Pass-Through Facility communicates with the DBMS through the SAS/ACCESS engine.
The facility enables you to do the following:
pass native DBMS SQL statements to a DBMS
display query results formatted by PROC SQL
save query results as SAS data files
create SAS data views containing pass-through queries
示例:
proc sql;
connect to ACCESS as mydbms
(path="./sql1.mdb");
title “Report using SQL Passthrough”;
select *
from connection to mydbms
(select Product_Name, Price
from Catalog_2007
order by Product_Name)
;
disconnect from mydbms;
quit;