The SAS Dummy

Learn SAS

Learn about the latest tips, tutorials, upcoming events and certifications

Learn SAS

Chris HemedingerNovember 15, 2016 2

Rick Wicklin showed us how to visualize the ages of US Presidents at the time of their inaugurations. That's a pretty relevant thing to do, as the age of the incoming president can indirectly influence aspects of the president's term, thanks to health and generational factors. As part of his

English

Learn SAS

Chris HemedingerJuly 13, 2016 5

Build your Pokémon library using SAS and the Pokéapi

Today is #EmbraceYourGeekness day, and you are either reveling in this new crazy town inhabited by Pokémon GO, or you are hiding in your house trying to avoid all of the Pokémon GO zombies wandering around. But since I'm living in SAS these days -- not just the place (at

English

Learn SAS

Chris HemedingerJune 2, 2016 18

How SAS Support Communities can expedite your tech support experience

SAS Technical Support has earned a wonderful reputation for being friendly, knowledgeable, and thorough. Every customer that I talk to is delighted by the experience. That's why what I'm about to say might be heresy, but here it goes. If you have a question about how to accomplish a task

English

Learn SAS | Programming Tips

Chris HemedingerJune 11, 2015 15

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

English

Learn SAS | Programming Tips

Chris HemedingerMay 20, 2015 123

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.

English

Learn SAS

Chris HemedingerFebruary 16, 2015 4

Can you learn how to create custom tasks?

To develop a custom task for use in SAS Enterprise Guide (or SAS Add-In for Microsoft Office), you need a few things: A working knowledge of SAS and SAS Enterprise Guide Microsoft Visual Studio (the free Express edition will do, though the Professional edition is better) Some experience with C#

English

Learn SAS | Programming Tips

Chris HemedingerJanuary 26, 2015 52

How to split one data set into many

Back in the day when the prison system forced inmates to perform "hard labor", folks would say (of someone in prison): "He's busy making little ones out of big ones." This evokes the cliché image of inmates who are chained together, forced to swing a chisel to break large rocks

English

Learn SAS | Programming Tips

Chris HemedingerSeptember 21, 2014 40

Using ODS EXCEL and PROC EXPORT to bundle Excel-based reports

I recently wrote about my foray into the experimental world of ODS EXCEL. Using this new destination in SAS 9.4, I was able to create multisheet workbooks -- containing reports and graphs -- in the XLSX format. I outlined some of the benefits -- such as being part of Base

English

Learn SAS | Programming Tips

Chris HemedingerAugust 29, 2014 73

Experimenting with ODS EXCEL to create spreadsheets from SAS

The ODS ExcelXP tagset has served us well over the years. It provides a reliable method to get formatted SAS output into Microsoft Excel workbooks, where the business world seems to like to live. And it's available in Base SAS, which means that you don't need SAS/ACCESS to PC Files

English

Learn SAS

Chris HemedingerJune 12, 2014 8

New course: Developing Custom Tasks for SAS Enterprise Guide

This probably won't surprise any of my regular readers: "SAS custom tasks" is one of my favorite topics to talk about. Since 2007, I've written blogs about how you can use custom tasks to extend SAS Enterprise Guide and the SAS Add-In for Microsoft Office. I've shared lots of examples,

English

Blogs

Blogs

Learn SAS