This post shows how you can create a SAS Data Step View that will give you access to the Columns from tables that are registered in SAS Metadata. Using this View you can leverage this information to help make you and your team more productive. For example you could create a Web Report that would dynamically show you what columns are in what tables.
This example provides data step code that will query the SAS Metadata and return a list of Columns from Tables registered in Metadata. The code as-is will create a data step view in the work library, so each time it is accessed it will dynamically query the SAS Metadata.
How to use it
The data step code below assumes that the connection to your Metadata Server has already been configured using the following System Options: