My work at Metacoda involves lots of metadata, as does my work as in SAS® platform administration. I spend a lot of time looking inside SAS metadata repositories, searching for objects, looking at their attributes, following their associations to …
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
Sneak Peek at our new Effective Permissions Explorers
This post is a sneak peek at a couple of effective permissions explorers that we are putting into the next version of our Metacoda Security Plug-ins. We’ll also be demoing these at the SAS Global Forum 2012 in Orlando next week, so if you’r…
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 […]
Peek Inside SAS BI Book: Building Business Intelligence with SAS
You may be aware by now, our new SAS BI book Building Business Intelligence with SAS:Content Development Examples launched last week on the SAS Press site. That’s right, SAS Press or Amazon will be delighted to bring a copy of this SAS BI book to your door. When Angela and I set out to write this book, one of the first things we discussed was how new users get access to the SAS BI toolset and have no idea of its astonishing capabilities. This book guides you through each one so you understand it. Intermediate and advanced users will also find this book as a valuable reference. Several times, Angela & I have both found ourselves pulling out the draft copy to reference an advanced technique. This book fulfills a unique spot in the marketplace; there is no other single book that leads you through each SAS BI component with step-by-step examples along with hundreds of tips and techniques to make you successful! SAS Institute offers over nine SAS BI courses to cover all the topics we have jammed packed into this book. Making this an excellent study guide for those planning to take the SAS BI Content Development Exam. Your SAS […]
Role-Based Access to Metacoda Security Plug-ins in SAS Management Console
This post explains how to provide role-based access to Metacoda Security Plug-ins in the SAS® Management Console (versions 9.2 and 9.3). Metacoda Security Plug-ins are initially only available to administrators, specifically members of the Managem…
SAS Management Console: Quick Tip when Creating a Metadata Library
Quick Tip to Use when Creating a Metadata Library Here’s a quick tip for SAS BI Administrators or anyone who has to create metadata library in the SAS Management Console. Often before I define the metadata library I am at the folder or the physical path of the library. Obviously, it’s critical that the path is defined correctly in the metadata. So here’s my quick tip. In the physical library, click or double-click the path and use the Ctrl+C keyboard shortcut to capture the path. As you assign the metadata library, in the New Library Wizard window, click New to assign the path. Instead of clicking the Browse button to navigate to your library path, do this instead: Double-click the Paths field and press Ctrl-V to paste the path.Some folks may not realize that is an editable line – so you can also make changes if needed.