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

Learn SAS | Programming Tips

Charu ShankarJune 1, 2015 0

Looking for a SAS job? Join the 21-day SAS challenge

I recently taught a SAS training course where the students were very engaged. They had so many questions, I could have spent the next month writing helpful blog posts that came from that one class. However, I picked this one question that the class begged for me to share. The

Read More

English

Programming Tips | SAS Administrators

Rob CollumMay 29, 2015 0

How SAS gets to data in Hadoop

SAS offers a rich collection of features for working with Hadoop quickly and efficiently. This post will provide a brief run-through of the various technologies used by SAS to get to data in Hadoop and what’s needed to get the job done. Working with text files Base SAS software has the

Read More

English

Learn SAS | Programming Tips

Charu ShankarMay 27, 2015 0

Life saver tip for comparing PROC SQL join with SAS data step merge

“Phew! That tip alone was a life saver,” said a student in one of my SAS SQL classes. “Before, I would have to read about ten Google search results before I could find that content of the sort you shared in class.” That student was referring to the tip I

Read More

English

Programming Tips

Bari LawhornMay 20, 2015 0

ODS PDF destination in SAS 9.4: Come take a look under the hood!

If you have programmed with SAS in the last 15 years, you have probably had a reason to share your SAS results in PDF format. The ODS PDF destination, much like a well-designed car, has evolved over the years, offering progressively nicer features like security, enhanced image formatting and embedded

Read More

English

Learn SAS | Programming Tips

Chris HemedingerMay 20, 2015 0

Using LIBNAME XLSX to read and write Excel files

The XLSX libname engine in SAS allows you to read and write Microsoft Excel files in the same way that you can work with other data sets and databases. This article describes the basic (and some limitations) of the XLSX engine.

Read More

English

Programming Tips

Teri PatsilarasMay 15, 2015 0

SAS Visual Analytics:  Localize your reports to support multiple languages!

Do you support a multilingual reporting audience? This is a fast-growing requirement for many of you,  and now your SAS Visual Analytics reports can be easily configured to support any number of languages. From SAS Visual Analytics Designer, there is an option under the File menu called Localize Report. This

Read More

English

Programming Tips

Chris HemedingerMay 14, 2015 0

Filter your SAS Enterprise Guide data with a WHERE clause

Are you a VIEWTABLE fan from the SAS Windowing Environment (a.k.a. Display Manager, DMS, PC SAS)? If so, the latest version of SAS Enterprise Guide has a new feature that you'll love. With the latest update to SAS Enterprise Guide 7.1 (7.11), you can now subset your data in the

Read More

English

Analytics | Data Visualization | Programming Tips

Robert AllisonMay 12, 2015 0

Creating your own customized graphs for SAS analytic procedures

In recent releases of SAS, you can use Output Delivery System graphics or 'ODS graphics on' to produce nice graphical output for most of the analytic procedures. These default graphs are nice, but when you want your graphs to look "a certain way" SAS also lets you create your own custom graphs!

Read More

English

Programming Tips

Chris HemedingerMay 11, 2015 0

Using FILENAME ZIP to unzip and read data files in SAS

I've written about how to use the FILENAME ZIP method to read and update ZIP files in your SAS programs. The ZIP method was added in SAS 9.4, and its advantage is that you can accomplish more in SAS without having to launch external utilities such as WinZip, gunzip, or

Read More

English

Learn SAS | Programming Tips

Michael A. RaithelMay 8, 2015 0

Doctor, I have this friend who has a pain right about here

We have all heard the old joke about the person who sidles up to a doctor at a party and describes in great detail a medical problem a "friend" is having in order to get free medical advice.  It could just as easily be a person buttonholing an accountant for

Read More

English

Learn SAS | Programming Tips

Charu ShankarMay 6, 2015 0

10 reasons to learn SAS code even when you have Enterprise Guide

New York City Mayor, Michael Bloomberg made a new-year's resolution to learn code. Apple’s Steve Jobs said, “I think everybody in this country should learn how to program a computer because it teaches you how to think.” President Barrack Obama said, "Don't just buy a new video game, make one.

Read More

English

Programming Tips | SAS Administrators | SAS Events

Rob CollumMay 6, 2015 0

SAS administration and architecture—highlights from SAS Global Forum 2015

I was privileged with the opportunity to present a couple of papers at SAS Global Forum 2015 in Dallas, Texas this year.  While there, I was also excited to attend presentations with new and inventive approaches for working with the administration and architecture of SAS solutions. This is a collection

Read More

English

Data Visualization | Programming Tips

Robert AllisonMay 5, 2015 0

SAS/GRAPH: Intermediate Tricks (a Handbook for the Wizard’s Apprentice)

Did you ever wish you could master SAS/GRAPH, and create graphs and maps that were customized exactly like you wanted them? Then this free eBook is for you! Probably the most memorable book for me was the Necronomicon in the Army of Darkness movie. How many of you liked that

Read More

English

Programming Tips

Sunil GuptaMay 1, 2015 0

Converting variable types—use PUT() or INPUT()?

How many times have you had a need to convert between variable types such as converting character to numeric or numeric to character?  For example, what if you have a character variable with numeric values but you need to perform some calculations?  Or, if you have a numeric variable but

Read More

English