Programming Tips

Jerry LeonardAugust 21, 2015 0

Creating Quantile Groups

SAS users often ask me about the best way to group or bin their data in preparation for additional analysis. Depending on the need, there are several ways to achieve this using SAS procedures or other SAS processing. Creating user-defined formats with PROC FORMAT or using Data step processing are

Read More

English

Programming Tips | SAS Administrators

Dave NadenAugust 19, 2015 0

Monitor your SASWORK directory from SAS Environment Manager

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

Read More

English

Data Visualization | Programming Tips

Warren F. KuhfeldAugust 17, 2015 0

Advanced ODS Graphics: Annotating multiple panels

In the past few weeks, I have written two posts on SG annotation and on saving and then modifying the graphs that analytical procedures produce:   Modifying dynamic variables in ODS Graphics   Annotating graphs from analytical PROCs Today, I finish this series with one more post. This one shows how you

Read More

English

Programming Tips | SAS Administrators

Bobbie WagonerAugust 13, 2015 0

Visual Analytics 7.3: A peek at HTML5 interfaces

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

Read More

English

Programming Tips

Stephen FoersterAugust 11, 2015 0

Loading LASR Remotely with DI Studio (SAS/Connect)

The SASIOLA libname engine is now delivered with most SAS software orders so that we can load LASR environments remotely from separate SAS environments. For example, maybe you have an existing SAS “ETL” machine that you use to access your source environments and load your target environments. With the SASIOLA

Read More

English

Programming Tips

Chris HemedingerAugust 10, 2015 0

Copy data and column names from SAS Enterprise Guide

While I've often written about how to get your SAS data to Microsoft Excel in some automated way, I haven't really addressed what's probably the most frequently used method: copy and paste. SAS Enterprise Guide 7.1 added a nifty little feature that makes copy-and-paste even more useful. The new "Copy

Read More

English

Data Visualization | Programming Tips

Warren F. KuhfeldAugust 10, 2015 0

Advanced ODS Graphics: Annotating graphs from analytical PROCs

There are many ways to modify the graphs that SAS creates. Standard graph customization methods include template modification (which most people use to modify graphs that analytical procedures produce) and SG annotation (which most people use to modify graphs that procedures such as PROC SGPLOT produce). However, you can also

Read More

English

Programming Tips

Chris HemedingerAugust 3, 2015 0

Using Lua within your SAS programs

With apologies to this candy advertisement from the 1980s: "Hey, you got your Lua in my SAS program." "You got your SAS code in my Lua program!" Announcer: "PROC LUA: Two great programming languages that program great together!" What is Lua? It's an embeddable scripting language that is often used

Read More

English

Data Visualization | Programming Tips

Warren F. KuhfeldJuly 31, 2015 0

Advanced ODS Graphics: Modifying Dynamic Variables in ODS Graphics

If you are familiar with the output delivery system (ODS), then you know that you can modify the tables and graphs that analytical procedures display by modifying table and graph templates. Perhaps less familiar is the fact that you can also modify dynamic variables. Tables and graphs are constructed from

Read More

English

Programming Tips | SAS Administrators

Stuart RogersJuly 31, 2015 0

SAS 9.4: Transport Layer Security (HTTPS) and SAS

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

Read More

English

Programming Tips

Chris HemedingerJuly 29, 2015 0

SAS Enterprise Guide now updates itself

I returned to work from a 2+ week vacation this morning. When I fired up SAS Enterprise Guide (as I do each work day and occasionally on weekends), I was greeted with this message: As a SAS insider, I knew this was coming. It's a new feature that was added

Read More

English

Programming Tips | SAS Administrators

Gerry NelsonJuly 29, 2015 0

Great new functionality for SAS Administrators in 9.4 M3

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

Read More

English

Programming Tips | SAS Administrators

Teri PatsilarasJuly 22, 2015 0

Use Hub Shared Collections to automatically push VA reports to your users

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

Read More

English

Programming Tips

Marjorie ShelleyJuly 21, 2015 0

What you should know about SAS Factory Miner

On July 14, 2015 SAS released SAS Factory Miner, our latest advanced data mining and machine learning product.  This new product provides automated predictive modeling by segment in a high velocity grid enabled environment, allowing modelers to run hundreds of models within minutes and find champion models by segment quickly.

Read More

English

Programming Tips

SAS JediJuly 20, 2015 0

Jedi SAS Tricks - Maximum Warp with Hadoop

I'm gearing up to teach the next "DS2 Programming Essentials with Hadoop" class, and thinking about Warp Speed DATA Steps with DS2 where I first demonstrated parallel processing using threads in base SAS. But how about DATA step processing at maximum warp? For that, we'll need a massively parallel processing

Read More

English

Data Visualization | Learn SAS | Programming Tips

Leonid BatkhanJuly 16, 2015 0

Integrating SAS reports with Google maps: two-pane solution

➤ DISCLOSURE! In June 2018 Google introduced changes to the way it handles its Maps platform. They now require API key in order to embed a map, plus Google Maps "projects" must now be associated with a billing account. Unless these new Google rules are met, Google maps described in

Read More

English

Programming Tips | SAS Administrators

Gerry NelsonJuly 15, 2015 0

Where is my stuff? Documenting what is stored in SAS metadata

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

Read More

English

Programming Tips | SAS Administrators

Dave NadenJuly 9, 2015 0

Providing multi-machine data for the SAS Environment Manager Data Mart

One of the great things that the new Data Mart will do for you is combine data from all the machines found in a multi-machine deployment into one storage area, where it is used to create many of the reports found in the Report Center. This capability began with the 14w41

Read More

English

Programming Tips

Chris HemedingerJuly 8, 2015 0

Copy an entire process flow in SAS Enterprise Guide

I've seen some crazy process flows in SAS Enterprise Guide. Crazy-big, and crazy-complex, used by real customers to accomplish real work. But while these process flows represent a ton of work, this is usually a calculated investment to automate processes that would be difficult to capture in another way. For

Read More

English

Programming Tips | SAS Administrators

David SternJuly 7, 2015 0

Anonymization for analysts, report designers and information owners

This is my second blog on the topic of anonymization, which I’ve spent some time over the past several months researching. My first blog, Anonymization for data managers, focused on the technical process. Now let’s dive into the role for analysts, report designers and information owners. To analysts and reporting

Read More

English

Data Management | Programming Tips | SAS Administrators

David SternJuly 2, 2015 0

Anonymization for data managers

I’ve spent some time over the past couple of months learning more about anonymization. This began with an interest in the technical methods used to protect sensitive personally-identifiable information in a SAS data warehouse and analytics platform we delivered for a customer. But I learned that anonymization has two rather different meanings; one in the

Read More

English

Programming Tips

Marjorie ShelleyJune 29, 2015 0

How sentimental of you! Enabling sentiment analysis in a SAS Visual Analytics word cloud

Word clouds have been available in SAS Visual Analytics for a while now, but recently, sentiment analysis was added to their functionality. For those of you not familiar with word clouds, a word cloud, also known as a tag cloud, is a visual representation of text data. You are probably

Read More

English

Learn SAS | Programming Tips | SAS Events

Maggie MillerJune 24, 2015 0

2 days. 2 exams. 2 SAS certifications.

In just one weekend Shang-Hua Wu went from a SAS user to a super SAS user by getting not just one, but two SAS certifications – SAS Certified Base Programmer and SAS Certified Advanced Programmer. Wu wanted to earn his certifications to position himself for new career opportunities in the

Read More

English

Programming Tips

Ginny PiechotaJune 19, 2015 0

Can you Lag and Lead at the same time? If using the SAS DATA step, yes you can

Within the SAS DATA step, the LAG function is provided to return a variable’s value from a previous data set observation.  With certain data criteria, sometimes there is a need to look ahead at the next observation and you would expect to use a LEAD function, but this does not

Read More

English

Learn SAS | Programming Tips

Cindy CraginJune 17, 2015 0

SAS Enterprise Guide: Suppress Output Data tab when programming

Have you ever waited a bit for SAS Enterprise Guide to display the Output Data tab when submitting a SAS program that generates multiple output tables?  Or, perhaps your program only generates one big output table but it takes a little while for it to surface on the Output Data

Read More

English

Programming Tips | SAS Administrators

Gerry NelsonJune 17, 2015 0

Recent improvements to SAS automated migration tools

Recent updates to SAS 9.4 have introduced some nice improvements in support of automated migration using the SAS Migration Utility and SAS Deployment Wizard. SAS has been working hard to make the migration experience more user friendly and less error prone. Changes have focused on making errors easier to identify

Read More

English

Learn SAS | Programming Tips

Chris HemedingerJune 11, 2015 0

Ask the Expert: Creating custom tasks for SAS Enterprise Guide

If you have not yet discovered the new Ask the Expert series on the SAS Training site, you are missing out on a treasure. Visit the site right now and review all of the available topics, from "Newbie" to Analytics to Visualization to good ol' SAS programming. Go on; I'll

Read More

English

Programming Tips

John HallJune 10, 2015 0

Evaluating tradeoffs when designing storage for SAS applications

Recently my wife and I took our annual anniversary trip – this time we went to the Grand Canyon, staying in Las Vegas. In researching our options to fly from Raleigh-Durham (RDU) to Las Vegas (LAS), we had several different selection criteria: what time we wanted to leave what time

Read More

English

Data Visualization | Learn SAS | Programming Tips

Leonid BatkhanJune 5, 2015 0

SAS ODS destination - Google maps

➤ DISCLOSURE! In June 2018 Google introduced changes to the way it handles its Maps platform. They now require API key in order to embed a map, plus Google Maps "projects" must now be associated with a billing account. Unless these new Google rules are met, Google maps described in

Read More

English

Programming Tips

Dave NadenJune 3, 2015 0

SAS Environment Manager: Importing events

An important goal of SAS Environment Manager is to communicate with existing software systems. This capability includes not only monitoring other non-SAS platform resources, but also means having the ability to respond to events from outside the SAS platform.  We’ve seen how SAS Environment Manager can generate an event for external consumption (see Scott McCauley’s

Read More

English