By default, accessing third party relational databases can be very slow if not configured properly. I recently started using PostgreSQL 9.1, an open source database, to store high volumes of data for my SAS Global Forum 2013 paper. At first it was taking forever to load up data because SAS was inserting 1 row...
Read more »
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 ...
Read more »
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...
Read more »
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...
Read more »
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...
Read more »
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...
Read more »
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...
Read more »
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...
Read more »