1286 PROC EXPORT DATA= A.Tianshuju
1287 OUTFILE= "H:\data1.xls"
1288 DBMS=EXCEL2000 REPLACE;
[b:e2123][size=150:e2123][color=red:e2123]ERROR: UNABLE TO ACCESS MESSAGE 656.13
ERROR: Error attempting to CREATE a DBMS table. ERROR: .
ERROR: ROLLBACK issued due to errors for data set _IMEX_.TIANSHUJU.DATA.
ERROR: Import unsuccessful. See SAS Log for details.[/color:e2123][/size:e2123][/b:e2123]作者: shiyiming 时间: 2003-11-12 13:20 标题: 你可以上网找找，看看有没有类似的补丁！ <!-- m --><a class="postlink" href="http://search.sas.com/tech/query.html?qp=%2Burl%3Atechsup%2Funotes%2FSN%2F&col=suppsas&charset=iso-8859-1&ht=0&qt=%22+_IMEX_.%22&qs=-url%3A%2Ftechsup%2Funotes%2Fle+&qc=suppsas&pw=600&ws=0&la=en&qm=0&st=1&nh=25&lk=2&rf=0&rq=0&si=0">http://search.sas.com/tech/query.html?q ... &rq=0&si=0</a><!-- m -->
When exporting a dataset to Excel via Proc Export or the Export Wizard,
you may encounter one or both of the following errors:
ERROR: UNABLE TO ACCESS MESSAGE 656.13
ERROR: ROLLBACK ISSUED DUE TO ERRORS ON DATASET _IMEX_.XCONT.DATA
This will occur if you are trying to export a dataset with more than
65,000 observations. Excel97 and Excel2000 both have a limit of
65,000 rows to a worksheet.作者: shiyiming 时间: 2003-11-13 22:20 标题: 一点个人想法 首先谢谢leo的帮助，这两天我都在试着解决这个问题，后来我发现excel最多只能读入256个变量，而我的这个sas数据集中变量数远远多于256，观测到不多，只有455个。后来我试着将数据集分割，选取部分分析用变量导出，成功！不过你贴出的链接，我看了，又学到一些东西。谢谢你！ <!-- s8) --><img src="{SMILIES_PATH}/icon_cool.gif" alt="8)" title="Cool" /><!-- s8) -->