SAS 元数据对象详细信息 - SASLibraries、PhysicalTables、Jobs [英] SAS Metadata Objects Details - SASLibraries, PhysicalTables, Jobs

问题描述

我已使用此代码获取所有 SAS 库、物理表和作业的对象列表.https://github.com/sasjs/core/blob/master/元/mm_getobjects.sas我现在需要获取这些对象的详细信息，就像图书馆一样 - 我需要他们的 libname 和完整路径，Teradata 库 - 架构名称、库路径物理表 - 位置和其他属性工作 - 位置和其他属性.

I've used this code to fetch the list of objects for all SAS Libraries, Physical Tables and Jobs. https://github.com/sasjs/core/blob/master/meta/mm_getobjects.sas I now need to fetch these objects details, Like for Libraries - I need their libname and full path, Teradata Libs - Schema Name,Lib path Physical Tables - Location and other attribs Jobs - Location, and other attribs.

我不太熟悉我们可以如何报告或报告哪些属性，但我绝对需要他们的路径和属性.谢谢.

I'm not very familiar on how or what attribs can we report, but I definitely need their paths and attribs. Thank you.

推荐答案

您参考的示例是使用 proc metadata 返回您需要理解和处理的 XML.这里真正的问题是您必须学习如何构建输入 XML 来构建元数据查询，这是一件相当复杂的事情.

The example you refer to is using proc metadata that returns XML you need to understand and process. The real problem here is you have to learn how to build input XML to construct the metadata query, which is quite a complex thing.

也许更直接的是使用数据步骤元数据函数，例如 这里.

Maybe more straight forward is to use Data step metadata functions like here.

METABROWSE 命令有助于了解元数据对象关系(如果您有权访问 SAS Foundation)，请参阅 这里

METABROWSE command is useful to understand metadata object relations (if you have access to SAS Foundation), see here

这篇关于SAS 元数据对象详细信息 - SASLibraries、PhysicalTables、Jobs的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！