Data Visualization | Programming Tips

Robert AllisonJanuary 29, 2019 0

Visualizing unemployment data, with a band plot

Many areas of the US are experiencing record low unemployment. This is great at the national level, and also great at a personal level (for example, I now have fewer unemployed friends asking to borrow money!) But just how low is the US unemployment rate, and how does it compare

Read More

English

Government

Learn SAS | Programming Tips

Rick WicklinJanuary 28, 2019 0

Simulate data for a regression model with categorical and continuous variables

This article shows how to use SAS to simulate data that fits a linear regression model that has categorical regressors (also called explanatory or CLASS variables). Simulating data is a useful skill for both researchers and statistical programmers. You can use simulation for answering research questions, but you can also

Read More

English

Analytics | Programming Tips

Rick WicklinJanuary 23, 2019 0

Coding and simulating categorical variables in regression models

Recently I was asked to explain the result of an ANOVA analysis that I posted to a statistical discussion forum. My program included some simulated data for an ANOVA model and a call to the GLM procedure to estimate the parameters. I was asked why the parameter estimates from PROC

Read More

English

Analytics | Programming Tips

Rick WicklinJanuary 23, 2019 0

Coding and simulating categorical variables in regression models

Recently I was asked to explain the result of an ANOVA analysis that I posted to a statistical discussion forum. My program included some simulated data for an ANOVA model and a call to the GLM procedure to estimate the parameters. I was asked why the parameter estimates from PROC

Read More

English

Analytics | Machine Learning | Programming Tips

Rick WicklinJanuary 21, 2019 0

Create training, validation, and test data sets in SAS

In machine learning and other model building techniques, it is common to partition a large data set into three segments: training, validation, and testing. Training data is used to fit each model. Validation data is a random sample that is used for model selection. These data are used to select

Read More

English

Learn SAS | Programming Tips

Kathryn McLawhornJanuary 18, 2019 0

Navigating SAS documentation to find out about new, modified, and updated features

Learn about the latest product features, changes and upgrade information in new sections of SAS product documentation for SAS® 9.4 and SAS® Viya®. SAS' Kathryn McLawhorn tells us all about them.

Read More

English

Data Visualization | Programming Tips

Robert AllisonJanuary 17, 2019 0

Using International characters in a SAS graph

They say "The Sun never sets on the SAS Empire" ... and it's true! There are SAS users all over the world, and SAS output & results could be in any language. Therefore, if you're a SAS programmer, you might need to know how to create SAS graphs with international

Read More

English

Programming Tips

Chris HemedingerJanuary 17, 2019 0

Using built-in Git operations in SAS

SAS supports direct integration for Git from Base SAS (via functions), SAS Enterprise Guide, SAS Studio, and SAS Data Integration Studio. Read this article to learn how to use Git more effectively in your SAS processes.

Read More

English

Analytics | Programming Tips

Rick WicklinJanuary 16, 2019 0

Three ways to add a line to a Q-Q plot

A quantile-quantile plot (Q-Q plot) is a graphical tool that compares a data distribution and a specified probability distribution. If the points in a Q-Q plot appear to fall on a straight line, that is evidence that the data can be approximately modeled by the target distribution. Although it is

Read More

English

Data Visualization | Programming Tips

Robert AllisonJanuary 15, 2019 0

Let's track the falling gasoline prices!

When I fill up my daily-driver Prius, the price of gasoline isn't that important. But when I occasionally take a trip in my V8 Suburban, I pay a lot more attention! Therefore I was pleasantly surprised when I noticed that gasoline prices have been falling. How much have they fallen,

Read More

English

Energy & Utilities | Travel

Analytics | Artificial Intelligence | Data Visualization | Machine Learning | Programming Tips

Melanie CareyJanuary 14, 2019 0

How SAS Visual Analytics' automated analysis takes customer care to the next level - Part 3

In the second of three posts on using automated analysis with SAS Visual Analytics, we used the automated analysis object to get a better understanding of our variable of interest, X-Sell and Up-sell Flag, and how it is influenced by other variables in our dataset. In this third and final

Read More

English

Data Visualization | Learn SAS | Programming Tips

Kelly MillsJanuary 10, 2019 0

Use PROC GPROJECT to Project Choromap Regions Successfully in PROC SGMAP

Sometimes it is difficult to know what parameters to use when projecting map data onto Esri or OpenStreetMaps in PROC SGMAP. The shapefile .PRJ file contains everything you need to set these parameters in PROC GPROJECT. In a previous blog, you saw how to lookup projections at a web site,

Read More

English

Data Management | Learn SAS | Programming Tips

Leonid BatkhanJanuary 9, 2019 0

Simplify data preparation using SAS data templates

My New Year's resolution: “Unclutter your life” and I hope this post will help you do the same. Here I share with you a data preparation approach and SAS coding technique that will significantly simplify, unclutter and streamline your SAS programming life by using data templates. Dictionary.com defines template as

Read More

English

Analytics | Data Visualization | Programming Tips

Rick WicklinJanuary 9, 2019 0

10 posts from 2018 that deserve a second look

Numbers don't lie, but sometimes they don't reveal the full story. Last week I wrote about the most popular articles from The DO Loop in 2018. The popular articles are inevitably about elementary topics in SAS programming or statistics because those topics have broad appeal. However, I also write about

Read More

English

Analytics | Artificial Intelligence | Data Visualization | Machine Learning | Programming Tips

Melanie CareyJanuary 7, 2019 0

How SAS Visual Analytics' automated analysis takes customer care to the next level - Part 2

In the first of three posts on using automated analysis with SAS Visual Analytics, we explored a typical visualization designed to give telco customer care workers guidance on customers most receptive to upgrade their plans. While the analysis provided some insight, it lacked analytical depth -- and that increases the risk of  wasting time, energy and

Read More

English

Communications

Analytics | Programming Tips

Rick WicklinJanuary 7, 2019 0

Deming regression for comparing different measurement methods

Deming regression (also called errors-in-variables regression) is a total regression method that fits a regression line when the measurements of both the explanatory variable (X) and the response variable (Y) are assumed to be subject to normally distributed errors. Recall that in ordinary least squares regression, the explanatory variable (X)

Read More

English

Analytics | Artificial Intelligence | Data Visualization | Machine Learning | Programming Tips

Melanie CareyJanuary 2, 2019 0

How SAS Visual Analytics' automated analysis takes customer care to the next level - Part 1

You're the operations director for a major telco's contact center. Your customer-care workers enjoy solving problems. Turning irate callers into fans makes their day. They also hate flying blind. They've been begging you for deeper insight into customer data to better serve their callers. They want to know which customers

Read More

English

Communications

Learn SAS | Programming Tips

Rick WicklinJanuary 2, 2019 0

Top posts from The DO Loop in 2018

Last year, I wrote more than 100 posts for The DO Loop blog. Of these, the most popular articles were about data visualization, SAS programming tips, and statistical data analysis. Here are the most popular articles from 2018 in each category. Data Visualization Visualize repetition in song lyrics: In one

Read More

English

Programming Tips

Joe FurbeeDecember 21, 2018 0

SAS REST APIs: a sample application

This post rounds out the year and my series of articles on SAS REST APIs. You can read all of my posts on this topic here. The first two articles in the series: Using SAS Viya REST APIs to access images from SAS Visual Analytics and Using SAS Cloud Analytics

Read More

English

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeDecember 20, 2018 0

A Graphical Journey

The ODS Graphics software, first released with SAS 9.2, supported creating graphs directly from statistical procedures.  Prior to this, very few statistical procedures created graphs on their own, and in most cases creating graphs was a post process or creating the graphs from the saved data using SAS/GRAPH procedures. With

Read More

English

Banking | Communications | Energy & Utilities | Health Care | Manufacturing | Retail | Travel

Programming Tips

Chris HemedingerDecember 20, 2018 0

Five SAS programming language features you should be using

Good news -- the SAS program that you wrote and put into production 10 years ago still works. Hey, it's SAS, so you probably take that for granted. But are those techniques from 2008 still the best way to accomplish your task? SAS 9.4, first released in 2013 and now

Read More

English

Learn SAS | Programming Tips

Kim WilsonDecember 13, 2018 0

FAQs about SAS dates, arrays and managing local PC files

Every so often, SAS Technical Support highlights questions that come in on a regular basis. This is one of those times. Here Kim Wilson describes answers to questions covering SAS dates, arrays, and how to reference local PC files from SAS® Enterprise Guide® and SAS® Studio when those applications connect to a SAS® server in UNIX operating environments.

Read More

English

Analytics | Data Visualization | Programming Tips

Robert AllisonDecember 13, 2018 0

Examining data about North Carolina's absentee ballots

Certain North Carolina counties have been in the news lately, for suspected election fraud involving absentee ballots in the 2018 election.  Let's analyze the voter registration and absentee ballot data, to see if we can detect anything suspicious! In order to definitively determine whether fraud & illegal activity occurred, investigators

Read More

English

Government

Analytics | Learn SAS | Programming Tips

Rick WicklinDecember 12, 2018 0

The essential guide to bootstrapping in SAS

This article describes best practices and techniques that every data analyst should know before bootstrapping in SAS. The bootstrap method is a powerful statistical technique, but it can be a challenge to implement it efficiently. An inefficient bootstrap program can take hours to run, whereas a well-written program can give

Read More

English

Data Visualization | Learn SAS | Programming Tips

Kelly MillsDecember 11, 2018 0

PROC SGMAP using CSV Files, GINSIDE and GEODIST to Plot Places of Interest

As mentioned in other PROC SGMAP blogs, several SAS/GRAPH procedures have been moved to 9.4M6 Base SAS to be used with PROC SGMAP. You can use these to create PROC SGMAP output even when using the free SAS University edition. In this blog you will use the: IMPORT procedure for

Read More

English

Data Visualization | Programming Tips

Robert AllisonDecember 11, 2018 0

Plotting snow data for your area

We got our first 'big' snow of the season here at the SAS headquarters in Cary, NC ... therefore I thought this would be a great time to dig into some snow data! Follow along and pick up some tips & tricks as I plot our snow data - and

Read More

English

Government

Learn SAS | Programming Tips

Larry LaRussoDecember 10, 2018 0

Navigating the Candy Wall of SAS Support Resources

While support.sas.com remains the holy grail of SAS support resources, there are so many good choices, it can sometimes be hard to know where to start. That’s why we’ve put together a new guide to make things easier for new SAS users: the SAS Starter Kit.

Read More

English

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeDecember 7, 2018 0

The SGPIE Procedure - Part 2

The SAS 9.4M6 software includes a new SGPIE procedure (preproduction) as introduced in the recent article - The SGPIE Procedure.  In that article, I described the basic features of the two statements supported in the procedure, the PIE and the DONUT, with some examples. It is my humble opinion that

Read More

English

Banking | Communications | Education | Energy & Utilities | Government | Health Care | Hospitality | Insurance | Life Sciences | Manufacturing | Retail | Sports & Entertainment | Travel

Learn SAS | Programming Tips

Rick WicklinDecember 5, 2018 0

When is a histogram not a histogram? When it's a table!

Recently a SAS programmer wanted to obtain a table of counts that was based on a histogram. I showed him how you can use the OUTHIST= option on the HISTOGRAM statement in PROC UNIVARIATE to obtain that information. For example, the following call to PROC UNIVARIATE creates a histogram for

Read More

English

Data Visualization | Programming Tips

Robert AllisonDecember 4, 2018 0

Let it snow, let it snow, let it snow!

It might snow this weekend here at the SAS headquarters! This would be the first snow of the season for us, and it got me thinking about snow again (see some of my previous blog posts about snow). Apparently these thoughts have manifested themselves in my computer graphics work ...

Read More

English