Accessing SPD Engine Data using Hive

With the release of SAS® 9.4 M3, you can now access SAS Scalable Performance Data Engine (SPD Engine) data using Hive. SAS provides a custom Hive SerDe for reading SAS SPD Engine data stored on HDFS, enabling users to access the SPD Engine table from other applications. The SPD Engine […]

Post a Comment

Let me help you with that! A technical SAS resource guide

On the search for some SAS notes, workarounds or sample code? What you may not know is that there are a ton of SAS resources out there providing examples, tips and tricks that are great to have in your tool belt! Many of these resources provide sufficient insight and resolutions […]

Post a Comment

SAS Visual Analytics autoload configuration made easy

In the past, configuring a new autoload library for SAS Visual Analytics was a manual process involving steps to create very specific folder structures and to copy and edit scripts and SAS programs. No more! Updates to the SAS Deployment Manager have added a new task that creates and configures new autoload libraries […]

Post a Comment

Opening Up the SAS Environment Manager Report Center

The SAS Environment Manager Report Center is a set of SAS stored processes and SAS macros which leverage the SAS Data Mart for the purpose of monitoring and auditing a SAS installation. Full documentation on the structure and functioning of the Data Mart can be found in the SAS Environment Manager […]

Post a Comment

Copy data to Hadoop using SAS Data Loader

The SAS Data Loader directive ‘Copy Data to Hadoop’ enables you to copy data from DBMS to Hadoop Hive tables. The SAS Data Loader for Hadoop can be configured to copy data from any external database which offers JDBC database connectivity. SAS Data Loader uses the Apache Sqoop™ and Oozie […]

Post a Comment

New year resolution: Don't let old stuff slow down your SAS Grid

As another year goes by, many people think about new year’s resolutions. It’s probably the third year in row that I’ve promised myself I’d start exercising in the fabulous SAS gym. Of course, I blame the recently concluded holiday season. With all the food-focused events, I couldn’t resist, ate way […]

Post a Comment

Accessing the provided Relationship Report in SAS Visual Analytics 7.3

In SAS Visual Analytics 7.3, the usage reports accessed from the administrator includes a relationship report.  This report provides very basic lineage and dependency information for selected object types.  The data to populate this report comes from the middle-tier relationship service.  Once you enable the collection and extraction of this […]

Post a Comment

What is going on with my Visual Analytics audit data archiving?

In my last blog (What is going on with my Visual Analytics audit data collection) I reviewed how middle-tier auditing works and where to look for logs to debug issues. In this follow up blog I will do the same for the Visual Analytics audit data archiving process. The archive process is […]

Post a Comment

SAS administrators tip: Keeping track of SAS users

If you are a SAS Administrator who is tasked with managing SAS users including adding and removing SAS users in the SAS Management Console, assigning (or re-assigning) them to Groups and Roles, maintaining their General information and user Accounts, then you know that when number of users grow, at some […]

Post a Comment

Help for SAS administrators only a click away

If you install, update, manage or maintain a SAS deployment, you're a SAS administrator, and a very valuable resource for your organization. Every day, SAS users at your company depend on you to do their job. Being a SAS administrator is a critical and rewarding role, but it can sometimes be a lonely one as […]

Post a Comment