Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

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

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

Learn SAS | Programming Tips

Calibration plot for a misspecified logistic model

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

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

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

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

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

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

Analytics | Learn SAS | Programming Tips

A bootstrap analysis (1) Starts with data, (2) resamples from the data many times to create bootstrap samples, (3) computes a statistic for each sample, and (4) uses the distribution of the bootstrap statistics to make inferences.

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

Data Visualization | Learn SAS | Programming Tips

SGMAP SCATTER Data Limited by the GEODIST Function

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

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

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

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

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

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

Data Visualization | Learn SAS | Programming Tips

SERIES and BUBBLE Plots

Kelly MillsNovember 29, 2018 0

PROC SGMAP Series Plot – Importing Shapefiles and using PROC GPROJECT

In August 2018, Hurricane Florence came on shore in North Carolina. Much of the damage was from flooding because the storm moved slowly over North and South Carolina. Parts of North Carolina had over 30 inches of rain from the storm, and this caused many of North Carolina’s rivers to

Read More

Programming Tips

Chris HemedingerNovember 29, 2018 0

Using SAS to access and update files on Microsoft OneDrive

Learn how to use SAS code (PROC HTTP) to read and write files from your Microsoft OneDrive. You'll learn how to create a Microsoft Office 365 app, connect to it with SAS, and automate the integration with your office productivity environment.

Read More

Learn SAS | Programming Tips | Students & Educators

Marcia SurrattNovember 28, 2018 0

Making great graphs even better with ODS Graphics

This blog post shows a few samples of graphs and explains how you can use new functionality in ODS Graphics to make your old graphs look new again. And, ODS Graphics is part of Base SAS, which means that all of these techniques work in SAS University Edition.

Read More

Programming Tips

Rick WicklinNovember 28, 2018 0

Singular parameterizations, generalized inverses, and regression estimates

I remember the first time I used PROC GLM in SAS to include a classification effect in a regression model. I thought I had done something wrong because the parameter estimates table was followed by a scary-looking note: Note: The X'X matrix has been found to be singular, and a

Read More

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeNovember 26, 2018 0

The SGPIE Procedure

The 6th maintenance release of SAS 9.4 is now available for users. Along with it comes a new SG procedure - the SGPIE procedure (pre-production). The primary audience for the SG procedures has been the analytical user, for creating effective displays of analytical data. However, the rich feature set of these

Read More

Data Visualization | Programming Tips

Robert AllisonNovember 26, 2018 0

Creating a 'Matrix-like' movie scroll animation, from a text file

Do you remember The Matrix movies, that started coming out in 1999? Hopefully this movie franchise didn't give you a fear of virtual reality and AI. The thing I remember most from the movie was the really cool slow-motion video effects (from multiple angles) in the fight scenes. And the

Read More

Sports & Entertainment

Analytics | Data Visualization | Programming Tips

Robert AllisonNovember 21, 2018 0

Finding a cut-your-own Christmas tree in North Carolina

This week I noticed that they've started building the lot where they sell Christmas trees near SAS (at the intersection of Maynard & Reedy Creek Rd). They put up a nice rustic wooden fence, and lights, and maybe even a fire pit to keep their workers warm. They sell some

Read More

Sports & Entertainment | Travel

Data Visualization | Learn SAS | Programming Tips

SGMAP with CHOROMAP using %CENTROID

Kelly MillsNovember 20, 2018 0

PROC SGMAP, Base SAS Procedures and MAPSSAS Data Sets

Starting with SAS 9.4M6, procedures that used to be provided with a SAS/GRAPH installation are now available with Base SAS. Using these procedures along with PROC SGMAP can help you create some very nice maps. This blog builds on previous posts and highlights the: MAPSSAS Data Sets GREMOVE procedure %CENTROID

Read More

Learn SAS | Programming Tips

Rick WicklinNovember 19, 2018 0

Select ODS tables by using wildcards and regular expressions in SAS

You might know that you can use the ODS SELECT statement to display only some of the tables and graphs that are created by a SAS procedure. But did you know that you can use a WHERE clause on the ODS SELECT statement to display tables that match a pattern?

Read More

Programming Tips

Joe FurbeeNovember 16, 2018 0

Using SAS Cloud Analytics Service REST APIs to run CAS Actions

Disclaimer: this article does not cover or promote any political views. It’s all about data and REST APIs. I am relieved, thankful, elated, glad, thrilled, joyful (I could go on with more synonyms from my thesaurus.com search for 'happy') November 6, 2018 has come and gone. Election day is over.

Read More

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeNovember 16, 2018 0

Waterfall Graph with more data for subject - Part 2

A few days back I published an article on including more subject data in a Waterfall graph. This was motivated by the desire from many users to view more data in the same graph, thus avoiding the need to refer to different graphs for the relevant information. In this case,

Read More

Health Care | Life Sciences

Analytics | Data Visualization | Programming Tips

Robert AllisonNovember 15, 2018 0

Where do provisional ballots come from?

There has been a lot of controversy surrounding this year's midterm election, when it comes to counting the ballots ... and I kept hearing the term provisional ballots in the news. But I'm embarrassed to say that I didn't really know much about provisional ballots. I decided to do a

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonNovember 14, 2018 0

Building a better election map

The US 'midterm' elections have finally started to wind down, and we finally have some (mostly) finalized results to study. But what's the best way to visualize who won the US congressional seats in each of the 435 districts? Let's dive into this topic!... Preparation For starters, I couldn't find

Read More

Programming Tips

Chris HemedingerNovember 14, 2018 0

Create newline-delimited JSON (or JSONL) with SAS

JSON is a popular format for data exchange between APIs and some modern databases. It's also used as a way to archive audit logs in many systems. Because JSON can represent hierarchical relationships of data fields, many people consider it to be superior to the CSV format -- although it's

Read More

Programming Tips

Steven SoberNovember 14, 2018 0

How to achieve repeatable results with distributed DATA Step BY Groups

Prior to distributed DATA Step, DATA Step programmers never had to think about achieving repeatable results because DATA Step ran single-threaded and the source SAS7BDAT dataset was stored on disk. But if you need to obtain repeatable results in DATA Step code that runs distributed in CAS, this post provides a workaround that you'll want to keep handy.

Read More

Previous 1 2 3 4 5 … 42 Next