## Learn SAS

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

0
Which of my factors are important?

This question has been asked repeatedly for decades by anyone facing a new system. That system might be a new product, a new piece of equipment, a new process, or anything really that is new and not well understood. Ultimately, you might need to change this system but first you

Learn SAS
0
Jedi SAS Tips - Favorite Resources for SAS Programmers

I frequently get asked about my favorite book on a particular topic, how to find free SAS learning materials online, how to get help with SAS issues, etc. This lead me to compile a "Great Resources for SAS Programmers" document which I freely share with my students upon request. So

0
What is rank correlation?

When someone refers to the correlation between two variables, they are probably referring to the Pearson correlation, which is the standard statistic that is taught in elementary statistics courses. Elementary courses do not usually mention that there are other measures of correlation. Why would anyone want a different estimate of

0
CALL EXECUTE made easy for SAS data-driven programming

In my prior posts (Data-driven SAS macro loops, Modifying variable attributes in all datasets of a SAS library, Automating the loading of multiple database tables into SAS tables), I presented various data-driven applications using SAS macro loops. However, macro loops are not the only tools available in SAS for developing

0
Flip it. Flip it good.

A SAS user needed to convert a program from MATLAB into the SAS/IML matrix language and asked whether there is a SAS/IML equivalent to the fliplr and flipud functions in MATLAB. These functions flip the columns or rows (respectively) of a matrix; "LR" stands for "left-right" and "UD" stands for

0
Interning at SAS: A Summer Adventure - Part 2

In my last post, I discussed the outstanding experiences I’ve had as an intern at SAS and some of the things that I’ve learned so far. I love working at SAS, and now that I’ve been here for a while, I can confidently say I’m contributing to the success of

0
Interning at SAS: A Summer Adventure - Part 1

Every year, SAS ranks high on the Fortune 100 Best Companies to Work For list. The rankings are largely based on anonymous feedback from employees, who consistently rank SAS high on everything from executive communications to work-life balance. But SAS isn’t just a great place to work for professionals; it’s an

0
Programming tips from experienced SAS users

Trivial Pursuit, Justin Bieber and Timbits. Some pretty great things have come from Canada, eh? Well, you can go ahead and add expert SAS programmers to that impressive list. In this video, six Canadian SAS programmers, with more than 115 years of SAS programming experience between them, share some of their favorite, little-known SAS programming tips. You're sure to discover a new trick or

0
23 MSAs account for 1/2 of US GDP!

When it comes to economic activity, a handful of the largest metropolitan areas in the US account for lion's share. In 2013, the top 23 Metropolitan Statistical Areas (MSAs) accounted for 50% of the total US Gross Domestic Product (GDP). I recently came across a map created by Alexandr Trubetskoy

0
Discounted Certification Exams at SAS Analytics Experience 2017

SAS is hosting the premier analytics conference in the world September 18-20 in Washington DC, and supplementing the event with discounted training and certification exams at SAS Analytics Experience 2017. These offerings will be held before and after the event. As at other SAS events, we will be offering certification exams at

0
Planting seeds through education

If you’re familiar with the SAS story, you know that we have deep roots in academia. But our CEO Jim Goodnight has always known that roots aren’t enough to achieve incremental growth. You also have to plant seeds. Analytics alone can’t drive change, help businesses succeed and make the world

0
Organize your work with SAS® Enterprise Guide® Projects

Nowadays, whether you write SAS programs or use point-and-click methods to get results, you have choices for how you access SAS. Currently, when you open Base SAS most people get the traditional SAS windowing environment (aka Display Manager) as their interface. But it doesn’t have to be that way. If

Learn SAS
0
How severe is your missing data problem?

Datasets are rarely ready for analysis, and one of the most prevalent problems is missing data. This post is the first in a short series focusing on how to think about missingness, how JMP13 can help us determine the scope of missing data in a given table, and how to

Learn SAS
0
8 new summer reads for SAS users

Summer is here, which means vacations and time at the pool with a good book. If expanding your knowledge is a goal of yours this summer, SAS has a shelf full of new titles becoming available over the next few months. From new editions of classics – such as SAS® for Forecasting

0
Keeping your data set clean: Integrity constraints

When I teach my Data Cleaning course, the last topic I cover in the two-day course is SAS Integrity Constraints.  I find that most of the students, who are usually quite advanced programmers, have never heard of Integrity Constraints (abbreviated ICs).  I decided a short discussion on this topic would

Learn SAS
0
Jedi SAS Tricks - FedSQL Dictionary Tables

Dictionary tables are one of the things I love most about SQL! What a useful thing it is to be able to programmatically determine what your data looks like so you can write self-modifying and data-driven programs. While PROC SQL has a great set of dictionary tables, they all rely

0
Jackknife estimates in SAS

One way to assess the precision of a statistic (a point estimate) is to compute the standard error, which is the standard deviation of the statistic's sampling distribution. A relatively large standard error indicates that the point estimate should be viewed with skepticism, either because the sample size is small

0
Combine and conquer with SAS

The ancient political maxim “divide and conquer” (Lat. “dīvide et īmpera”) has been used for millennia in politics, sociology, and psychology, mainly to manipulate people. In the last two centuries, however, this principle has also been adopted by computer science. It is widely used in computer programming, primarily in computer

0
Graphing Ironman race data

This past weekend, I was a volunteer helping with an Ironman 70.3 race. I was really impressed & inspired by the athletes ... I was also excited about the quantity and variety of data generated by this type of race (compared to a regular marathon). And as a 'graph guy' I

0
Digital Learning per una nuova esperienza di apprendimento digitale

La digital transformation spazza come un vento tutti i settori industriali e promette di essere un motore per la competitività, la produttività e l’occupazione. Investire sul miglioramento delle competenze e il rafforzamento dei profili professionali è il punto di partenza per attuare la trasformazione di cui tanto si parla. Partendo

0
Using regular expressions to verify the pattern of character data

Wait!  Don't close this window.  I understand that regular expressions can be very complicated (yes, there are many books on the subject), but some basic expressions to test patterns such as zip codes or telephone numbers are not that difficult.  In addition, you can sometimes use Google to search for

0
A medical dashboard for the Star Trek fans

As a kid who grew up in the 60s & 70s, I was a big fan of the original Star Trek TV series. And in the years since, I have seen lots of the Star Trek “technology” become a reality: cellphones, portable tablet computers, talking computers (Alexa/Siri), etc. But I

0
How to choose a seed for generating random numbers in SAS

Last week I was asked a simple question: "How do I choose a seed for the random number functions in SAS?" The answer might surprise you: use any seed you like. Each seed of a well-designed random number generator is likely to give rise to a stream of random numbers,

0
Standardizing phone numbers using SAS

How many times have you entered a phone number on a web page, only to be told that you did not type it the "correct" form? I find that annoying. Don't you? In my latest book, Cody's Data Cleaning Techniques, 3rd edition, I show how to convert a phone number

1 2 3 23