If you have ever had to manually add in a reverse proxy, manually configure HTTPS, or otherwise needed to update the connection URLs for any of the SAS Web Applications you know that it can be a tedious job prone to errors.  This information can be updated in the Configuration Manager of SAS Management Console by right-clicking on each individual Web App and going to the Internal and External Connection tabs one by one… lots and LOTS of clicking and typing.  If you need a way to sanity check the connection information for the SAS Web Applications, or just want an easy way to see them all in the one place then this Data Step View is for you!

Overview

This example provides data step code that will query the SAS Metadata and return a list of Web Application Connections. 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:

  • METASERVER
  • METAPORT
  • METAUSER
  • METAPASS
If you are running this code via an IOM client (e.g. Enterprise Guide, DI Studio, etc.) then these options will already be set to the user you have logged into SAS with.  If you are running this code from Base SAS you will need to issue an OPTIONS statement to set them.
Because access to the SAS Metadata requires security authorisation, the list of objects returned will be dependent on what the user specified in the METAUSER/METAPASS options can access.

Example

Metadata Web Application Connections View

Code