如何读取从 access 导入的 SAS 数据集(不在 sas 命名约定中) [英] How to read SAS datasets (not in sas naming convention) imported from access

问题描述

我已使用 Libname 将 Access DB 导入到 SAS.库名 accdb 'c:\mydata\base.accdb'.DB 中的所有表现在都在 accdb 库中.但是 Access DB 中的表名与 SAS 数据集命名约定不匹配.我的问题是如何读取 accdb 中可用的那些数据集.

I have imported Access DB into SAS using Libname. Libname accdb 'c:\mydata\base.accdb'. All the tables in DB are now in accdb Library now. but table names in Access DB are not matching to SAS dataset naming convention. My question is how to read those datasets available in accdb.

谢谢，拉维

推荐答案

您可以尝试设置选项 VALIDMEMNAME=EXTEND.然后，您可以使用名称文字来引用成员，例如 '00ReadMe'n .这应该适用于 32 个字符或更短的任何成员(表)名称.我认为对于太长的名称，您可能只需要在 Access 中重命名它们，或者创建具有较短名称的视图以供您改用.

You can try setting the option VALIDMEMNAME=EXTEND. You can then reference the members using name literals such as '00ReadMe'n . This should work for any member (table) name that is 32 characters or shorter. I think that for names that are too long you might just have to either rename them in Access or create views that have shorter names that you can use instead.

这篇关于如何读取从 access 导入的 SAS 数据集(不在 sas 命名约定中)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！