Tag: SAS Management Console

Web Report Studio: Adding a Confidentiality Disclaimer

Adding disclaimers to SAS Web Report Studio tables and graphs is sometimes necessary for confidentiality purposes.  You can do this easily by using the Configuration Manager available in SAS Management Console 9.2 and up.  This is shown to the right.   Adding a Table Disclaimer Through SAS Management Console SAS Support provides official documentation for adding disclaimers in SAS 9.3 as well as SAS 9.2.  To add the disclaimer, simply find the “Web Report Studio 4.3″ application under the Configuration Manager through SAS Management Console. Right click and go to the “Advanced” tab and add the property as shown below. Downsides The major downside is the disclaimer gets inserted on every single table and chart produced going forward.  Web reports can get very cluttered with the same message.  As an alternative I would recommend building a Web Report Studio template with the security message as a footer.  Report writers can be educated to always use this template to enforce security policies. I noticed a reference to an XHTML fragment in the LocalProperties.xml file for Web Report Studio… Not sure how this works, but if anybody has any ideas please share!  Related content: MDX: Dynamically Hiding Measures for Compliance

SAS Management Console over SSH

I was asked recently how to get SAS® Management Console to remotely access a SAS metadata server using SSH tunnels. In the absence of a VPN connection to your network, SSH can be an alternative for SAS Management Console access to a remote SAS met…

Administration: Cleaning Up the WORK Library Automatically in UNIX

Here is a quick tip for keeping the WORK library clean in a UNIX/Linux environment.  Most of the time SAS manages the cleanup process very well but sometimes orphaned processes can leave unwanted data lying around which can build up over time.  This tip is only applicable for UNIX or Linux environments.  Windows would have a similar approach with different commands.   Use a Shell Script for UNIX Heavy Lifting This simple shell script will find all WORK directories created by SAS sessions and recursively remove everything within each directory older than a set time frame.  The joys of shell scripting!  WORK=/sas/work#!/bin/sh find $WORK/ -mtime +3 -type f -exec rm -rf {} \; exit 0 The WORK variable is set to the physical path of the WORK library on the compute server.  The number 3 represents the number of days since the file was last modified.  When this script is run, it initiates the find command which finds everything starting from the set directory with a last modified date older than 3 days, then forcibly removes everything within.  To prevent any permission problems, it should be run as ‘root’ or any other super user.  Why Not Schedule It? This shell […]