Data Visualization | Programming Tips

Robert AllisonFebruary 14, 2019 0

Analyzing age and gender distribution, with a pyramid chart

With the US census coming in 2020, I've decided to sharpen my skills at graphing census data. And today I'm working on creating a population pyramid chart to analyze the age and gender distribution. Follow along if you'd like to see how to create such a chart ... or jump

Read More

English

Government

Analytics | Learn SAS | Programming Tips

Rick WicklinFebruary 13, 2019 0

3 ways to obtain the Hessian at the MLE solution for a regression model

When you use maximum likelihood estimation (MLE) to find the parameter estimates in a generalized linear regression model, the Hessian matrix at the optimal solution is very important. The Hessian matrix indicates the local shape of the log-likelihood surface near the optimal value. You can use the Hessian to estimate

Read More

Artificial Intelligence | Machine Learning | Programming Tips

Augusta ZhangFebruary 11, 2019 0

How to spot counterfeit company logos with AI – no SAS programming experience needed

As one of SAS' newest systems engineers, recently joining the Americas Artificial Intelligence Team, I’m incredibly excited to gain expertise in artificial intelligence and machine learning. I also look forward to applying my knowledge to enable others to leverage the advanced technologies that SAS offers. However, as a recent graduate

Read More

English

Programming Tips

Chris HemedingerFebruary 8, 2019 0

Convert a text-based measurement to a number in SAS

Regular expressions are a powerful method for finding specific patterns in text. The syntax of regular expressions is intimidating, but once you've solved a few pattern-recognition problems with regex, you'll never go back to your old methods.

Read More

English

Data Visualization | Programming Tips

Robert AllisonFebruary 8, 2019 0

How to show recessions on your SGplot line graph

Plotting just your data often helps you gain insight into how it has changed over time. But what if you want to know why it changed? Although correlation does not always imply causation, it is often useful to graph multiple things together, that might logically be related. For example, recessions

Read More

English

Government

Data Management | Learn SAS | Programming Tips

Leonid BatkhanFebruary 6, 2019 0

How to split a raw file or a data set into many external raw files

Recently, I worked on a cybersecurity project that entailed processing a staggering number of raw text files about web traffic. Millions of rows had to be read and parsed to extract variable values. The problem was complicated by the varying records composition. Each external raw file was a collection of

Read More

English

Data Visualization | Learn SAS | Programming Tips

Kelly MillsFebruary 4, 2019 0

Use PROC GREMOVE and GREDUCE for Nice SGMAP Regions

In the previous Graphically Speaking blog for PROC SGMAP, you used PROC GPROJECT so map regions would match OpenStreetMap and Esri background images. This time, the same British Columbia shapefile is used with: PROC GREMOVE to remove unwanted boundary lines PROC GREDUCE to reduce map data PROC GPROJECT to zoom

Read More

English

Analytics | Data Visualization | Programming Tips | SAS Administrators | SAS Events

Frederik VandenbergheFebruary 1, 2019 0

Installing SAS Viya Azure virtual machines with a single click

I don't know about you, but when I read challenges like: Detecting hidden heart failure before it harms an individual Can SAS Viya AI help to digitalize pension management? How to recommend your next adventure based on travel data How to use advanced analytics in building a relevant next best

Read More

English

Data Visualization | Programming Tips

Robert AllisonJanuary 31, 2019 0

Creating a fancy life expectancy chart, with SGplot

You might have noticed I've been trying out SAS ODS Graphics lately, whereas in the past I mainly used SAS/Graph for my samples. In this blog post I step you through my latest fancy SGplot graph - hopefully you'll learn some tips & techniques, as you follow along. (I don't

Read More

English

Health Care

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