BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » Archive by Category

Articles in BI Admin

SAS Visual Analytics 7.4: Modern Theme Vs Classic Theme

2016-05-08 – 1:03 PM
admin_cvm_thumb

At the SAS Global Forum 2016 the SAS Viya platform was announced and part of the platform was SAS Visual Analytics and SAS Visual Statistics converting to the HTML5 interface. Noticeable changes were that the Designer and the Explorer have merged into one interface and there is a spiffy new color Modern theme. Dr. Goodnight said the expected release of the tool was projected to …

3 Methods to Remove Data from the HDFS VAPUBLIC Directory

2015-12-20 – 3:53 PM
hdfs_delete_data_thumb

When working with HDFS, you are often loading data to the various directories to upload into SAS Visual Analytics. However, sometimes you want to remove that data. Here’s three different ways to remove the data.
Method 1: Use the SAS VA Administrator Tools
If you have access to the Manage Environment area, you can use the Explore HDFS tab to interact with the data in the HDFS. You …

4 Tips for Using Linux to Find SAS VA Logs

2014-10-28 – 12:10 PM
Charleston Cemetary

In the US, Halloween is celebrated by young children dressing up as ghouls, ghosts, and demons of other sorts.  I think the original idea of costumes was to be the scarier demon, which means if I look like a bad ass demon then maybe the truly bad ass demons will run away in fright. This made me wonder What do I truly find scary? Turns out it is not graveyards, …

Administration: Retrieving Passwords from the SAS Metadata

2014-01-13 – 8:11 AM
2014 01 13 admin find userid 03 thumb

When working with the SAS metadata, sometimes a developer needs to retrieve a user ID and password from the metadata. For instance a developer may need the encoded password to connect to the database using the SAS pass-through with relational databases like Oracle and TeraData.  [More discussion about the pass-through :  here with TeraData, here compared to Libname, and here in SAS 9.2 doc set.]
As …

SAS Coding: Scattered Data Might Need CPORT Procedure Help

2013-12-15 – 5:52 PM
2013 12 environment setup thumbnail

My computer is a hot mess!  I have datasets and code everywhere.  I’m serious … you name it … there is not a hard drive, thumb drive, and even a DVD in my office that doesn’t have data on it.  I call it Scattered Data Syndrome and I had to do something before I kicked a stray dataset across the room and broke the printer.
Who knew …