标题: 倒入excel表格后，用sql语句出错 [打印本页] 作者: shiyiming 时间: 2006-6-8 17:54 标题: 倒入excel表格后，用sql语句出错 [size=150:26f06]我用的是sas8.2，按照sas的标准97/2000 *.xls倒入了表格，
在editor里写了这个语句-----
proc sql;
title 'ine';
select postcode, month, category, count, weight from Newlib.Inems where postcode = 'AE' and month = 1 order by count;
结果发生错误------
ERROR: Read Access Violation In Task ( SQL ]
Exception occurred at (63CC5C0D)
Task Traceback
求高手点拨一下！[/size:26f06]作者: shiyiming 时间: 2006-6-9 01:54 标题: RE: SASv8.2 does not support to associate SAS libref with an Excel file, but SASv9. You may use one of methods proc import, proc access or DDE steps to read data from Excel to SAS.