Programming Tips

Chris HemedingerFebruary 6, 2014 0

Adding "sticky notes" in your SAS Enterprise Guide projects

This isn't the first blog post to laud the "Note" feature of SAS Enterprise Guide. You know, the feature that allows you to add documentation to describe what the heck your project or process flow is actually doing. For example, Tricia described 3 useful ways to use the note feature.

Read More

English

Programming Tips

Chris HemedingerJanuary 29, 2014 0

Reading and updating ZIP files with FILENAME ZIP

Need to read or update a ZIP file within your SAS program? In SAS 9.4, you can use the FILENAME ZIP access method to do the job. Explanation and examples here!

Read More

English

Data Visualization | Programming Tips

Robert AllisonJanuary 22, 2014 0

Easy new way to send drilldown graphs in an email

In a previous post, I showed you how to send graphs with charttips & drilldowns in an email ... but what if you also need to send the graphs that you're drilling-down to? You guessed it - SAS also has a slick trick for doing that! When you create SAS graphs

Read More

English

Programming Tips

Chris HemedingerJanuary 20, 2014 0

Customer segmentation using RFM in SAS Enterprise Guide

Recency, Frequency, and Monetary Analysis (or RFM) is a popular customer segmentation technique employed by database marketers everywhere. Marketers use RFM to identify which customers are most likely to respond to a direct marketing campaign. The model takes into account three simple metrics: How recently did the customer buy from

Read More

English

Programming Tips

Chris HemedingerJanuary 18, 2014 0

SHA256 and other hashing functions in SAS

SHA256 and other hash functions are supported in SAS 9.4 and SAS Viya. It's better than MD5 as a cryptographic hash!

Read More

English

Data Visualization | Programming Tips

Robert AllisonJanuary 14, 2014 0

Find out what 'holiday' your birthday is on!

Every day of the year is an official 'national day' for something - here's a SAS chart to help you find which bizarre 'national day' falls on your birthday! I recently read an article that lists weird and unconventional national days. It was very interesting, but I found the data

Read More

English

Sports & Entertainment

Data Visualization | Programming Tips

Robert AllisonJanuary 8, 2014 0

Creating 'pretty' maps with SAS

When you create maps, you are typically plotting data for analytics -- but you can also use SAS to create 'pretty' maps for background decorations (for posters, slides, presentations, etc). This blog shows you a few examples... A few years ago I noticed that the CNN Situation Room had a decorative

Read More

English

Programming Tips

Chris HemedingerJanuary 6, 2014 0

Adding Google Web Fonts to your SAS reports

Because I began my SAS career in the Publications division, I like to think that I have a keen eye when it comes to SAS documentation. When I first visited the SAS 9.4 online documentation, I immediately noticed that it had a different look. Examine the image below; can you

Read More

English

Programming Tips

Chris HemedingerDecember 24, 2013 0

Closing the "LIBNAME loophole" with metadata-bound libraries

My children learned this skill early in life: when you want to secure permission for a questionable activity (say, "watch 5 hours of Phineas and Ferb" or "eat a bowl of candy for breakfast"), you should approach the most lenient adult in the household. In my early days of fatherhood,

Read More

English

Data Visualization | Programming Tips

Robert AllisonDecember 19, 2013 0

How to plot a forecast and confidence interval

The farther you try to forecast into the future, the less certain you are -- how can you represent that graphically? One way is to draw a shaded/colored "confidence interval" around your forecast line, but this is something a lot of SAS users have trouble with. That's why I decided to create

Read More

English

Programming Tips

Falko SchulzDecember 19, 2013 0

Santa's route in SAS Visual Analytics

Being so close before Christmas I thought it would be a good idea to see what route Santa Claus is planning this year. Not just because I'm living in Australia and Santa usually comes in t-shirts & shorts but also because it's a long way to get down here. So

Read More

English

Programming Tips

Chris HemedingerNovember 25, 2013 0

11 super-useful custom tasks for SAS Enterprise Guide

The holiday season is here, and you're probably wondering how to shop for that picky SAS Enterprise Guide user on your gift list. I've got a few ideas for you, and the price is right! Here are links to 11 custom tasks that are free to download, easy to install,

Read More

English

Data Visualization | Programming Tips

Warren F. KuhfeldNovember 11, 2013 0

The RUN Statement: Fun and Fitness with ODS Graphics

I decided this year to get serious about my running.  I started recording my distance for every run.  I made a SAS data set and generated simple reports.  After a few weeks, I set a goal of averaging one marathon a week (3.8 miles per day, 26.2 miles per week,

Read More

English

Programming Tips

Chris HemedingerNovember 6, 2013 0

Support for SAS on Windows 8 and Windows 8.1

Microsoft Windows 8 has been with us for a year, and its first major update -- Windows 8.1 -- has just arrived. So how does SAS support these Windows 8 platforms? The answer can be found on support.sas.com in SAS Note 46876. I'll summarize it here: SAS 9.3 and SAS

Read More

English

Data Visualization | Programming Tips

Robert AllisonNovember 6, 2013 0

SAS 9.4 has a new way to send interactive graphs in email!

SAS 9.4 allows you to create html5 output with your graph inline (as part of the html), providing a great way to email your SAS/Graph output! Previously, if you used ods html and dev=png to create graphs, you had to deal with two files -- a png file (containing the graph)

Read More

English

Programming Tips

Chris HemedingerOctober 29, 2013 0

5 keyboard shortcuts in SAS that will change your life

Okay, given the title of this article, I might be overselling the content a bit. Read on to see if your life will be transformed. I've just returned from SESUG, and this question came up during one of the presentations. While this tip might seem basic, it was news to

Read More

English

Programming Tips

Christina HarveyOctober 25, 2013 0

Do you understand the Program Data Vector?

Stick to the basics. Did you ever get that advice? Two of the papers at MidWest SAS Users Group 2013 used that most fundamental of SAS processing concepts—the Program Data Vector—to show why users might encounter unexpected errors in their DATA step programs. In The Secret Life of DATA STEP,

Read More

English

Analytics | Data Visualization | Programming Tips

Robert AllisonOctober 23, 2013 0

Using transparent colors in SAS Graphs

This graph certainly makes it clear! I can see right through your lies! Clearly, you know what you're talking about! We need more transparency in our organization! What was that all about, you might ask?!? ... I was just getting all the obvious puns out of the way, so I

Read More

English

Programming Tips

Rick WicklinOctober 23, 2013 0

Output percentiles of multiple variables in a tabular format

A challenge for statistical programmers is getting data into the right form for analysis. For graphing or analyzing data, sometimes the "wide format" (each subject is represented by one row and many variables) is required, but other times the "long format" (observations for each subject span multiple rows) is more

Read More

English

Programming Tips

Chris HemedingerOctober 18, 2013 0

A custom task to check your data cardinality

The other day I showed how to check your data cardinality by using a simple SAS program. I also promised to provide a custom task that makes the process even easier within SAS Enterprise Guide. Today I'm delivering on that promise. I've just added the custom task to the support.sas.com

Read More

English

Programming Tips

Chris HemedingerOctober 17, 2013 0

How to store data about your data in your data

Although the NSA and news media have given metadata a bad name in the popular press, the fact remains that information about the nature of your data is extremely valuable. For example, I posted an article yesterday about data cardinality. Cardinality measures the uniqueness of values in a variable. Cardinality

Read More

English

Programming Tips

Chris HemedingerOctober 16, 2013 0

Your data ain't good looking, but it has a nice cardinality

Data cardinality is an important topic for for data analysis. In mathematical terms, cardinality is simply the number of elements in a set. But in data applications, cardinality signifies the number of unique values for a given field of data. Related terms include number of levels (thank you, PROC FREQ

Read More

English

Programming Tips

Chris HemedingerOctober 8, 2013 0

Process Interruptus: a custom task to pause your process flow

Traditionally, SAS users like their processes to behave like Ron Popeil's famous rotisserie: they want to set it and forget it. That's the definition of a batch process. You work like heck to get it ready to run, then you push the button (or schedule it) and walk away. But

Read More

English

Programming Tips

Chris HemedingerOctober 1, 2013 0

Put them back the way you found them: restoring SAS titles

Has this ever happened to you? You have a SAS program with statements that you wrote, then you make use of a macro function or %include file supplied by a helpful colleague, and when your SAS code resumes, you find that all of your SAS titles have been changed out

Read More

English

Data Visualization | Programming Tips

Robert AllisonSeptember 20, 2013 0

A beginner's tutorial on ... geographical maps

Your biggest problem with maps used to be learning how to fold a paper road map. Today, with the advent of GPS, Google Maps, and location-specific data, the bar has been raised! ... you now need to know how to plot your data on a map! Below are several examples of different kinds

Read More

English

Programming Tips

Chris HemedingerSeptember 17, 2013 0

Copy a file using a SAS program: another method

A couple of years ago I shared a method for copying any file within a SAS program. It was a simple approach, copying the file byte-by-byte from one fileref (SAS file reference) to another. My colleague Bruno Müller, a SAS trainer in Switzerland, has since provided a much more robust

Read More

English

Data Visualization | Programming Tips

Robert AllisonSeptember 17, 2013 0

A beginner's tutorial on ... pie charts

There's an old expression "easy as pie."  Have you ever tried to bake a pie??? ... It's not so easy, LOL!  And neither is using pie charts correctly! :) Below are several examples of different kinds of pie charts you can create with SAS/GRAPH. And at the bottom of this

Read More

English

Data Visualization | Programming Tips

Robert AllisonSeptember 11, 2013 0

A beginner's tutorial on ... bar charts

Do you know how to create a bar chart using SAS, and when to use what kind of bar chart?!?  If the answer doesn't come to you "easy as pie" then this blog is for you! Below are several examples of different kinds of bar charts you can create with SAS/GRAPH.

Read More

English

Programming Tips

Chris HemedingerSeptember 5, 2013 0

New and improved: Importing SPSS data files in SAS Enterprise Guide

It's been almost 5 years since I posted one of the first custom tasks for SAS Enterprise Guide. It was a task that made it easier to convert SPSS data files into SAS data sets. Like many projects that begin as custom tasks, this one later became a feature in

Read More

English

Data Visualization | Programming Tips

Robert AllisonAugust 28, 2013 0

A beginner's tutorial on ... line plots

Do you know (right off the top of your head) the simple SAS/GRAPH code you would use to create line graphs? ... If not, then this tutorial is for you! A line plot is basically a scatter plot where the markers are connected. A line plot should only be used

Read More

English