关于SAS不能读取Excel2007文件的原因及解决方法

最新推荐文章于 2021-05-27 15:57:58 发布

ZJ_lover

最新推荐文章于 2021-05-27 15:57:58 发布

阅读量3.6k

点赞数

分类专栏： SAS 文章标签： excel microsoft office extension methods service

本文链接：https://blog.csdn.net/ZJ_lover/article/details/6662149

版权

SAS 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

本文介绍了SAS在特定版本下不支持导入导出Microsoft Office 2007文件的问题，包括.xlsx文件的限制，并提供了升级到SAS 9.2 Phase 2或使用替代方法来处理此类文件的建议。

摘要由CSDN通过智能技术生成

原因：

The EXCEL and XLS engines do not support importing and exporting of Microsoft Office 2007 files. These files have an extension of .xlsx, which is based on the Open XML standard. This type of file also allows for 16,384 columns and 1,048,576 rows.

Support for Office 2007 files is available in SAS^® 9.2 Phase 2 (TS2M0). Contact SAS Customer Service, your account team, or SAS Technical Support to request the Phase 2 software.

SAS Representatives at a company site can request the software from the link listed in SAS Note 35445, "Process to Request SAS^® Phase 2.

In the meantime, you can use the following methods to import, export, and create Office 2007 fies in SAS 9.1.3 and SAS9.2 Phase 1.

解决方法：