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
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
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
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
In a couple of my previous blogs I discussed how to audit who made changes to data in a SAS environment. In the last couple of weeks I have been asked how to do the same thing for SAS Visual Analytics reports and explorations. The Visual Analytics administrator overview report
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
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
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
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
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
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
In my last blog I discussed purging audit records from the Web Infrastructure Platform SharedServices database. The blog generated a fair bit of discussion around the SAS Visual Analytics auditing data gathering and archive process. So let’s take a step back and in this blog review how data collection for auditing works and
From time to time we’ll hear from customers who are encountering performance issues. SAS has a sound methodology for resolving these issues and we are always here to keep your SAS system humming. However, many problems can be resolved with some simple suggestions. This blog will discuss different types of
The phrase “business rules” is often loosely used. It can refer to things like constraints in a query, a data mapping, a data quality constraint, a data transformation, or a model. Business rules also reflect an enforced policy, a regulatory requirement and business constraints on model scores that trigger analytically-driven
SAS Visual Analytics contains an Administrator Overview report which provides for Visual Analytics usage information by application, user, and object. To provide data for the report you must enable collection of key actions audit data in the Visual Analytics Middle-Tier. Auditing doesn’t just apply to Visual Analytics, it can be
We all know that alerting is one of the most powerful features of SAS Environment Manager; the flexibility and comprehensiveness of this feature is one of the things that makes SAS EV stand out among monitoring tools. If we dig a little deeper, we find that we have quite a bit of
As of Visual Analytics 7.2, the home page is designed to serve as the entry point for not only Visual Analytics, but also additional SAS applications and solutions. To this end, the SAS Visual Analytics home page is documented in both the SAS Visual Analytics Administration Guide and the SAS Intelligence
In my last blog, I demonstrated how to configure a SAS server to write a record to a log file showing who is opening, editing or renaming a SAS table. In this blog we will see how we can process that information. The documentation shows one way to do this via
SAS Administrators are frequently asked to log and report on which users are accessing SAS tables. This functionality is often requested by companies who, for regulatory compliance, need to track who is accessing data. In my next couple of blogs I will show how you can audit data access. In this first blog
Many administrators are familiar with the well-known “WIP Data Server” component of a SAS installation–so this blog takes a closer look at it, and shows how easy it is to monitor how large the database is growing. This data server contains a SAS-critical database known as the SharedServices Database, which is
As Gerry Nelson pointed out in an earlier post on 9.4M3, a new interface to the SAS Backup and Recovery Tool is available from the Administration application in SAS Environment Manager. This new SAS Backup Manager interface makes scheduling regular backups and executing ad hoc backups extremely easy to do
New in the 7.3 release, SAS Visual Analytics now provides sample objects. During installation, the SAS Deployment Wizard prompts you to include sample reports by default. In addition to eight reports, an exploration and ten sample datasets are also included in the samples. These sample reports and datasets are available by industry
If you have, or are considering, SAS Grid Manager, you’ll be excited to hear about two new changes to the product that make it even better for managing and processing in your analytics environment. The two changes were made in conjunction with the release of SAS 9.4M3 in July, and
As of April 15, 2015, Oracle is no longer providing public updates of the Java 7 runtime environment (JRE) or software development kit (JDK). SAS 9.3 and SAS 9.4, however, continue to rely on Java 7 for support of business production. SAS has therefore contracted with Oracle to continue receiving
Everyone who codes with SAS knows what the SASWORK directory space is, and everyone who has ever managed a medium-large installation knows that you need to monitor this space to avoid a huge buildup of worthless disk usage. One of the most common snarls happens when large SAS jobs go
The new 7.3 release of SAS Visual Analytics not only uses the new HTML5 home page as the entry point to the Visual Analytics environment, but also introduces the new HTML5 viewer. The HTML5 home page interface features a personalized welcome message, tiles for content organization (Recent, Links, Favorites), icons to access
Encryption and SAS is a wide ranging topic – so wide it gets its own book and features strongly in both the SAS(R) 9.4 Intelligence Platform: Security Administration Guide, Second Edition and SAS(R) 9.4 Intelligence Platform: Middle-Tier Administration Guide, Third Edition. In this blog we’ll take a high level look at
SAS 9.4 M3 released in July 2015 with some interesting new features and functionality for platform SAS administrators. In this blog I will review at a very high level the major new features. For details you can see the SAS 9.4 System Administration guide. SAS 9.4 M3 includes a new release
The SAS Visual Analytics 7.2 release introduces a new look and feel to the Hub with the modern (HTML5) version. It also introduces a new feature, Shared Collections, which allows an administrator to push a Shared Collection to all users’ Hub view, including Guest access. And bonus - it will
In a SAS Environment there is a lot of metadata, metadata about configuration such as server definitions, users, groups and roles and metadata about content like data, reports and jobs etc. SAS Administrators often want to report on metadata. They want to know what reports have been developed and where they are stored, what
