SAS tutorial: Explore bivariate correlations

In this SAS tutorial video, you will learn to explore bivariate correlations using the CORR procedure in SAS. You will be introduced to a few of the options that can be used in PROC CORR and some CORR output is highlighted and discussed.


You can watch more SAS tutorials like these by visiting our SAS Tutorial Video Portal.

To learn more about this topic, check out our training course: Statistics 1: Introduction to ANOVA, Regression and Logistic Regression.



Post a Comment

Going for Gold with SAS Training

I loved watching the Winter Olympics last month. The unique events, amazing athletes, world records, and the emotion – it's hard not to be totally absorbed in it all. Mostly, I'm a sucker for those sentimental athlete profiles. The dedication and the extensive training they endure is truly amazing.

Noelle Pikus-Pace, a skeleton athlete from the United States, is a great example. Skeleton is the insane event where the athlete lies face down on a sled, with her nose inches from the ice, screaming down a steep track at more than 80 miles per hour. Pikus-Pace overcame a serious leg injury, a two-year retirement, and concussion-type symptoms to win the silver medal in Sochi. The most incredible part of her victory, though, was how little room for error she had. Had she been 0.5 seconds slower in her four runs (nearly four minutes on the track), she wouldn't even have medaled.

What gives athletes like Pikus-Pace the skills and confidence to perform at an elite level when the stakes are highest? I think it's largely those long hours of training and the expert instruction she received from her coaches and trainers.

The same is true in the increasingly competitive business world as well. To reach your full potential you must have dedication and a willingness to do what it takes to become elite in your field. SAS' training courses, led by our expert instructors, equip you with the SAS skills and confidence you need to overcome career hurdles and attain your personal best.

We’re here to help wherever you are in your SAS journey. If you’re an advanced SAS user, we have a curriculum of more than 150 courses, plus eight certifications to document your SAS expertise. If you’re new to SAS or need to learn the basics of SAS programming and analytics, we’ve created a series of free video tutorials. Recorded by SAS instructors, these videos cover topics in our foundation-level courses and are a great way to start your SAS adventure. Find them on our Web site or under the SAS Programming Tutorials and SAS Analytics Tutorials YouTube playlists.

Post a Comment

Jedi in Paradise - SAS Global Forum 2014

I'll be at SAS Global Forum again this year. I do SO love SAS Global Forum and the opportunity to talk DATA step, SQL, Macro and DS2 programming with other SAS aficionados! I’d love to connect with you, so send me an email or a tweet (@SASJedi) or just stop me and say ‘Hi’.  Here's my schedule:

Sunday, March 23, 2014

  • 19:00 – 20:30: Opening session
  • 20:30 – 22:30: Get-acquainted reception

Monday, March 24

  • 10:30 – 12:10: Helper at SAS Office Analytics Workshop
  • 13:30 – 15:10: Helper at SAS® Workshop: Data Mining
  • 11:30 – 13:30: I’ll be at the SAS Education booth in the Demo area, answering questions about SAS Foundation programming classes (including DS2, if latest SAS programming language interests you!)

Tuesday, March 25

  • Nothing scheduled

Wednesday, March 26

If you want to discuss SAS Foundation programming, comment on one of my blog entries, suggest a new blog topic, or just talk about any SASy thing – let’s chat. I hope to see you at SAS Global Forum 2014 in Washington, DC this year!

May the SAS be with you!

Post a Comment

Airplanes that have disappeared, without a trace!

With all the recent news reports about the missing Flight 370, I wondered what other airplanes have disappeared without a trace ... and I used SAS to visualize that data!

There was in interesting infographic on the Bloomberg website that sort of answered my question, but their map just had dots on it, with no hover-text or drilldowns to find out more info about each missing plane. It basically just showed the geographical distribution of lost flights.

I found a great website maintained by the Aviation Safety Network (ASN) that had the data I was looking for – they list all aircraft (certified to carry 14+ passengers, and corporate jets) that have disappeared without a trace (meaning that no debris, oil slick, or bodies were found) since 1948. Their site has an interactive map, but it just wasn't the kind of map I was looking for.

So I downloaded the ASN data, and created my own map using SAS. It’s visually similar to the Bloomberg map, but mine has hover-text for each missing airplane marker, and you can click the markers to see the ASN page with all the details about each flight.

Below is a snapshot of a piece of my map - click it to see the full-globe interactive map, with the hover-text and drilldowns!

Have you ever been on an airplane that you thought was going to be 'lost' ... or heaven forbid, that actually crashed?!? Feel free to leave a comment to share your experience!


Post a Comment

SAS tutorial: View and read a SAS data set

These two videos will show you how to view and read a SAS data set in Base SAS.

Viewing the data set helps you become more familiar with the data before you start working with it.


Once you master it, you will realize that the DATA step is a very powerful tool for data manipulation.

You can watch more video tutorials by visiting:

To learn more about the SAS data set, check out our Programming 1: Essentials course.

Post a Comment

Creating SAS graphs for an international audience

Have you ever eaten a biscuit, and thought to yourself "well, it ain't like momma fixed it"? (Alan Jackson fans will get that one!) ... So it is with food, and so it is with numbers and dates in graphs!

Back in college, when I lived in the Alexander International Dorm at North Carolina State University, I learned that people from different countries had a different way of saying just about everything. They pronounced country names differently, and sometimes used a completely different name for the countries, than we do in the US. Sometimes the same word meant something completely different - for example, when you ask someone if they want to "shag" in North Carolina, you're asking them if they would like to do a swing-like dance to beach music ... but if that person is from the UK, they might think you're talking about something else, LOL!

Here are a few favorite word differences that always caught my attention:

  • french fries/chips / crisps
  • biscuit / cookie
  • bathroom / loo / wc
  • flashlight / torch
  • trunk / boot
  • parking lot / car park
  • vacation / holiday
  • sweater / jumper
  • diaper / nappy
  • line / queue

As you can see, different countries have a different way of saying the same thing ... and if you're preparing graphs for an international audience, you might want to take that into consideration. You might be thinking ... "but graphs are mostly numbers - surely numbers are the same in all countries?" Actually not! Different countries use commas, spaces, and decimals differently in their numbers. And they have different preferences for how dates are written.

So, how will you (an international SAS programmer) know what the local preferences are, when you're creating graphs for a certain country? Not to worry - SAS has nls formats that can help you with that!

All you have to do is set the locale to the language & country of your intended audience, and use formats such as nlnum. and nldate., and your graph will automatically come out the way your audience expects it! :)

For example, if I assign these formats in my data:

data my_data;
format date nldate20.;
format quantity nlnum12.;
input date date9. quantity;
01jan2014  4455657
01feb2014  5025627
01mar2014 10709200
01apr2014  6896904
01may2014  6439536

And then set the following locale, then the numbers and dates in my graph will be targeted towards a US audience:

options locale=English_UnitedStates;

And now, using the exact same data & code, but just changing the locale to german_austria, you can produce a graph for an Austrian audience, using dots in the numbers where the US audience used commas.

And similarly, you can change the locale to french_france before you send the graph to your office in France - using spaces in the numbers, where the US would use commas:

As you can see, this technique is very easy, and allows you to create graphs targeted toward your audience ... no matter what country they are in :)

Have you ever had a misunderstanding caused by audiences in different countries interpreting numbers or words differently than you did? Feel free to share the story in a comment!


Post a Comment

SAS tutorial: Explore the distribution of a variable

In this SAS tutorial video, you will learn how to explore the distribution of a variable using the UNIVARIATE procedure in SAS. You will also be introduced to a few of the options that can be used in PROC UNIVARIATE, and some UNIVARIATE output is highlighted and discussed.


You can watch more SAS tutorial videos like these by visiting our SAS Tutorial Video Portal.

To learn more about this topic, check out our training course: Statistics 1: Introduction to ANOVA, Regression and Logistic Regression.


Post a Comment

Best cities to celebrate St. Patrick’s Day

In my younger years, I enjoyed celebrating St. Patrick’s Day in Savannah, GA. Did you know the city dyes the fountain water green and has a parade that attracts over 400,000 people? It is now time for me to find additional cities to celebrate the holiday.

Based on the DriveTheNation website, there are five best U.S. cities to celebrate St. Patrick’s Day. I couldn’t resist adding those cities to a SAS/GRAPH map.

Maybe, next year I will head to Chicago (one of my favorite cities) to celebrate St. Patrick’s Day. However, you can’t go wrong with Boston, New York, or San Francisco!

If you want to learn more about creating maps in SAS, check out the five-session Live Web class Producing Maps with SAS/GRAPH. Next offering of the class is April 21-25, 2014.

The following program created the above graph:

data work.cities(drop=city statecode);
   length xsys ysys hsys position when $ 1 
          function color style $ 8 text $50;
   retain xsys ysys '2' hsys 'D' function 'label' when 'a'; 
   set maps.uscity(keep=x y city statecode) end=last;
   where (city = 'San Francisco' and statecode = 'CA')
      or (city = 'Savannah'   and statecode = 'GA')
      or (city = 'New York' and statecode = 'NY')
      or (city = 'Chicago' and statecode = 'IL')
      or (city = 'Boston'  and statecode = 'MA');
   text='M'; color='green'; size=14; style='Marker'; position='5'; output;
   text=city; style='Arial/bold';
   if statecode='CA' then position='9'; 
   else if statecode='MA' then position='2'; else position='8'; output;
   if last then do;
      text='Note: Map produced with SAS/GRAPH'; style='Arial/italic'; size=12;
   position='5'; x=0.22; y=-0.22; output; 
ods html path='c:\temp' file='StPatricksDay.html' nogtitle nogfootnote;
goptions reset=all border;
proc gmap anno=work.cities;
   id state;
   choro state / nolegend levels=1 statistic=first 
                 coutline=white woutline=2;
   pattern1 c=lightgray v=s;
   title1 c=green h=14pt f='Arial' bold 
          "Best Cities to Celebrate St. Patrick’s Day";
   title2 c=green h=12pt f='Arial' bold
ods html close;
Post a Comment

Getting answers with econometrics

Someone once boiled down econometrics for me by explaining -- it’s all about answering the “why.”

It’s especially important for companies wanting to know the answers to important questions like…

  • Why are customers buying this product?
  • Why are customers not buying my product?

If you’re ready to start investigating the “why” in your business, watch this video with Dr. Oral Capps.

His Business Knowledge Series (BKS) course, Introduction to Applied Econometrics can help you get started.


Capps can also take you to the next level of econometrics with his sequel, Advanced Topics in Applied Econometrics.

Here’s another Q&A on what you might get out of attending his advanced course:


Post a Comment

SAS tutorial: Fit a logistic regression model with SAS

It's time for another SAS tutorial video!

In this video, you will learn to create a logistic regression model and interpret the results. You will learn PROC LOGISTIC syntax and how to interpret p-values, parameter estimates, and odd ratios.


You can watch more SAS tutorials like these by visiting our SAS Tutorial Video Portal.

To learn more about this topic, check out our training course: Statistics 1: Introduction to ANOVA, Regression and Logistic Regression.



Post a Comment