获取所有librefs的服务器信息 [英] Get server info for all librefs

问题描述

如何为SAS中可用的所有库获取包含变量libref和server_id(或任何服务器信息)的表?

How can I get a table with variables libref and server_id (or any server info) for all libraries available to me in SAS?

我的目标是总结所有这些库的数据实际位置，以便在从不同服务器获取数据时编写高效的查询.

My goal is to get a summary of where the data is physically located for all these libraries, in order to write efficient queries when fetching data from different servers.

推荐答案

查看SASHELP.VLIBNAM视图(或使用PROC SQL时为DICTIONARY.LIBNAMES)中可用的信息.

Look at what information is available in the view SASHELP.VLIBNAM (or DICTIONARY.LIBNAMES when using PROC SQL).

这是一个实用程序宏，可从该视图中为给定的libref拉取引擎，主机和架构.我已经将它用于TERADATA，ORACLE和ODBC引擎. dblibchk.sas

Here is a utility macro that pulls the engine, host and schema from that view for a given libref. I have used it for TERADATA, ORACLE and ODBC engines. dblibchk.sas

这篇关于获取所有librefs的服务器信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！