In this SAS tutorial, you will learn to import data from Microsoft Excel into SAS with SAS/ACCESS Interface to PC Files. Learn to read any sheet or named range from an Excel workbook as a data set or import any sheet or named range to create a SAS data...
Read more »
My teenage daughter is a self-appointed anglophile. She's a big fan of British movies and TV shows such as Doctor Who and Sherlock, and although she has not yet visited the UK (an injustice for which she blames her father), she considers the place to be her homeland. In an
Read more »
A colleague sent me an interesting question: What is the best way to abort a SAS/IML program? For example, you might want to abort a program if the data is singular or does not contain a sufficient number of observations or variables. As a first attempt would be to try
Read more »
With all of us blogging, emailing and posting updates on social media, the amount of textual data is growing fast. So how do you make sense of all that big data? Dr. Goutam Chakraborty teaches a Business Knowledge Series course, Text Analytics and Sent...
Read more »
SAS Global Forum 2014 is just around the corner and I’m getting really excited about it. There is so much content for SAS platform administrators this year. I had been thinking of posting a list of admin related papers I was keen to see, but then I saw that Greg Nelson from ThotWave wrote...
Read more »
One common violation of the assumptions needed for linear regression is heterscedasticity by group membership. Both SAS and R can easily accommodate this setting. Our data today comes from a real example of vitamin D supplementation of milk. Four sup...
Read more »
Michele Ensor recently posted a wonderful blog with a graph of the 2014 Winter Olympics medal count. I'm going to further refine that graph, making it an Olympic graph ... on steroids! :) Here is Michele's graph: First, let's give it a few simple cosmetic changes. I always like to have
Here’s my latest tip on how to apply conditional highlighting to a SAS Enterprise Guide report using the Summary Tables task. The Summary Tables task is a great way to point and click your way to creating simple or complex reports. Conditional highlighting is just one additional feature you can
My last blog post described three ways to add a smoothing spline to a scatter plot in SAS. I ended the post with a cautionary note: From a statistical point of view, the smoothing spline is less than ideal because the smoothing parameter must be chosen manually by the user.
Read more »