在64位SAS中使用libname语句与32位Excel交互 [英] Using libname statement in 64 bit SAS to interact with 32 Excel

问题描述

我安装了 64 位 SAS 9.4 和 32 位 Office 2007.当我安装了 32 位 SAS 9.3 时，我可以使用 libname 语句，其中 Excel 文件是库，而文件名"后面是句点实际上是 Excel 文件中的工作表或命名范围.例如，您从 libname 语句开始

I have 64 bit SAS 9.4 installed and 32 bit Office 2007. When I had 32 bit SAS 9.3 installed, I was able to use a libname statement where the Excel file was the library and the "filename" that follows after the period was in fact a worksheet or named range in the Excel file. For example, you start with a libname statement

libname exceltst path="C:UsersusernameDocuments	est.xlsx";

然后，稍后您可以使用 exceltst.stuff 在其中引用一个命名范围，假设stuff"是一个命名范围.

And, then later you can reference a named range in this with exceltst.stuff, assume "stuff" is a named range.

那么，这还有可能吗?我猜它与 64 位 sas 和 32 位 excel 有关，但我想知道是否有一些变化仍然有效.我可以使用 proc 导出来导出到 excel 文件，它工作得很好，但我已经尝试了 libname 的 20 种变体，但无法让它工作.我得到的错误是:

So, is this still possible? I am guessing it has to do with 64 bit sas and 32 bit excel but I am wondering if there is some variation that still works. I am able to use a proc export to export to the excel file and it works just fine but I have tried 20 variations on the libname and can't get it to work. The error I get is:

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.

推荐答案

如果您可以安装 SAS PC Files Server，您仍然可以使用 PCFILES 目标执行此操作.安装 PC Files Server 软件超出了此处的答案范围，但请在谷歌上搜索说明，它们很容易获得.您可以将 PC 文件服务器安装在您的桌面上，如果这对您的工作场所更方便的话，也可以安装在中央服务器上.

If you can install SAS PC Files Server, you can still do this with the PCFILES destination. Installing the PC Files Server software is out of the scope of an answer here, but google about for instructions, they are readily available. You can install the PC Files Server on your desktop, or on a central server if that's more convenient for your workplace.

安装后，您只需通过以下方式访问它:

Once you have it installed, you just access it by:

libname mylib pcfiles path="blahlahlah.xlsx";

就像你以前做的那样，但使​​用不同的 dbms 类型.

Just like you did before, but with a different dbms type.

这篇关于在64位SAS中使用libname语句与32位Excel交互的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！