SAS administrators--what's on your bookshelf?

I spend a lot of time on looking for resources to share.  The SAS Programmer’s Bookshelf is a handy reference that’s been around for a while, so I asked “Why not a SAS Administrator’s Bookshelf?”

What would you include?

It’s complicated, of course, because the SAS administrator’s role covers a myriad of tasks. Throw into that mix, the fact that many individual software products have their own administration requirements, and you have quite a long list.

About a year ago, I published a post on SAS administrator connections and resources, and all this research made me realize it might be time to update that post with a few new items (noted with *). Read More »

Post a Comment

SESUG 2014—learning, networking, problem-solving

SESUG_2014Sun, surf and SAS await you at this year’s South East SAS Users Group (SESUG) conference. Located at the beautiful Myrtle Beach, South Carolina from October 19-21, the conference offers two full days of learning, networking and problem-solving.

“Every year I’ve attended, I’ve found something that I could immediately use in my job and brought back contacts I could reach out to if I needed help with a new SAS application,” said Barbara Okerson, SESUG Executive Council Member. “Once you come to the conferences and meet other SAS professionals, you realize that it’s a community of friends that are always willing to help each other.”

Read More »

Post a Comment

Partitioning in Hadoop, sorting in SAS--same results, different methods

SAS In-Memory Statistics for Hadoop is a single interactive programming environment for analytics on Hadoop that  integrates analytical data preparation, exploration, modeling and deployment. It’s principle components are the IMSTAT procedure (PROC IMSTAT) and the SAS LASR Analytic Engine (or SASIOLA engine for input-output with LASR).

Within the SAS In-Memory Statistics for Hadoop environment, the SAS LASR Analytic Engine provides most of the functionality we associate with Base SAS; whereas, PROC IMSTAT covers the full analytical cycle from data manipulation and management, through modeling, towards deployment. This duality continues SAS's long standing tradition of  getting the same job done in different ways, to accommodate users' different style, constraints and preferences.

This post is one of several upcoming posts I plan to publish soon that discuss code mapping of key analytical data exercises from traditional SAS programming to SAS In-Memory Statistics for Hadoop. This post today covers sorting and sorting-related BY variables and ordering in SAS In-Memory Statistics for Hadoop. Read More »

Post a Comment

Live Google maps in SAS -- multiple markers

In my prior post, Spice up SAS output with live Google maps, I discussed the idea of delivering live Google map through SAS output and demonstrated the feasibility of doing so in SAS Information Delivery portal. Similarly, it can be done for any SAS HTML output.  You would just need to replace file _webout for SAS portal with any file reference pointing to an HTML file.

Since the first post was well received by the SAS community and generated numerous questions, I have decided to expand on it and show some additional functionality that can be incorporated into SAS output in regards to the Google maps.

In this post, I will demonstrate how to use SAS to generate Google map with multiple points (or markers, using Google terminology) and incorporate it into SAS HTML output. Read More »

Post a Comment

SAS Global Forum 2015: Your presentation is needed!

Do you know something about SAS® software that other SAS users would love to learn?

Of course you do!

Whether you’re a student or a member of the Circle of Excellence, every SAS programming project, every analysis or forecasting model is an opportunity to gain new insights into SAS processing or to develop new techniques.

No matter how you measure your SAS experience—what you’ve learned is valuable to other SAS users. So, start typing up your ideas. The SAS Global Forum 2015 call for content opens today! Read More »

Post a Comment

WUSS 2014—same event, new look and feel!

WUSS 2014 logo Do you know the way to San Jose? By now, SAS users are getting to know the way to the Western Users of SAS Software’s (WUSS) annual event on September 3-5, 2014.

Although this is the third time WUSS has been held in San Jose at The Fairmont Hotel, this year’s event will introduce a lot of changes, one of which includes the name of the event—going forward, the WUSS Conference will be called the WUSS Educational Forum and Conference. The purpose of the name change is to emphasize all of the learning opportunities there are at WUSS. Besides the name change, WUSS has more exciting changes to announce: Read More »

Post a Comment

One grid to rule them all – tuning your environment for SAS Enterprise Guide

Most organizations enjoy a plethora of SAS user types—batch programmers and interactive users, power users and casual—and all variations in between. Each type of SAS user has its own needs and expectations, and it’s important that your SAS Grid Manager environment meets all their needs.

One common solution to this dilemma is to set up separate configurations based on a mix of requirements for departments, client applications and user roles. The grid options set feature in SAS 9.4 makes this task much easier. A grid options set is a convenient way to name a collection of SAS system options, grid options and required grid resources that are stored in metadata. Read More »

Post a Comment

Old PROC REPORT code? Let's clean it up!

Did you inherit code that was written eons ago?  Do you find old programs to copy the PROC REPORT code and then simply change the variable names for your new program?  Have you wondered what all of those options do?  Do you ever send output to the Listing destination (the Output Window) anymore?

If you said yes to any of the questions above -- clean it up!  PROC REPORT has been around forever, but it has changed and evolved over the years to facilitate the creation of nicer looking output, specifically in non-Listing ODS destinations. Read More »

Post a Comment

Setting up SAS Business Intelligence environments – the right way

When new SAS users get introduced to the SAS Business Intelligence software (SAS BI), along with the thrill of a wide spectrum of new and desirable functionality, almost always comes a state of confusion--if not panic.

How do we go about adapting it to our organization IT guidelines? How do we arrange and support development and production environments? How do we set up our SAS developers so they can collaborate, but not overwrite each other’s work? What the hell are SAS folders? Why do we need them and how are they different from the operating system folders and directories?

Let’s make everything straight. This post will explain the two distinct dimensions to a SAS BI environment: folder structure and software lifecycle environments. It will also provide some suggestions on how you can set up your SAS Business Intelligence environment the right way. Read More »

Post a Comment

Can my SAS application be grid enabled?

This blog is a continuation of an earlier blog entitled “To grid or not to grid?” In that blog, one of the reasons to say “yes to SAS Grid” is to see if you can gain some performance improvements from modifying your existing SAS processes by converting them to a distributed processing format. If improving performance of individual SAS applications is one of your reasons to implement SAS Grid Manager, please read on.

To start with, all of your existing SAS jobs can run on your new SAS Grid, but not all of your existing SAS jobs can be turned into distributed processing applications that can be run simultaneously across multiple nodes of the SAS Grid. For example, processes that rely heavily on OLAP processing do not lend themselves to parallelization. Statistical analysis tasks that need to create a matrix in memory cannot be parallelized either.

When identifying SAS applications to modify for distribution across a SAS Grid, the first thing to look for is jobs that take many hours and even days to complete. In addition to long execution times, there are several profiles of SAS applications or jobs that are good candidates for running in parallel across a SAS Grid. Read More »

Post a Comment