Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Learn SAS | Programming Tips

Rick WicklinJune 10, 2019 0

5 reasons to use PROC FORMAT to recode variables in SAS

Recoding variables can be tedious, but it is often a necessary part of data analysis. Almost every SAS programmer has written a DATA step that uses IF-THEN/ELSE logic or the SELECT-WHEN statements to recode variables. Although creating a new variable is effective, it is also inefficient because you have to

Read More

Data Visualization | Programming Tips

Robert AllisonJune 6, 2019 0

Converting from Gchart to SGpie - simple pie chart

For my third 'Rosetta Graph' example, I will focus on a simple pie chart. Hopefully this example will show you how to convert your SAS/Graph Proc Gchart pies into almost-identical Proc SGpie pies. And speaking of almost-identical pies, here are two beautiful pies my friend Beth made - which one

Read More

Data Visualization | Learn SAS | Programming Tips

Rick WicklinJune 5, 2019 0

Plot a family of curves in SAS

A family of curves is generated by an equation that has one or more parameters. To visualize the family, you might want to display a graph that overlays four of five curves that have different parameter values, as shown to the right. The graph shows members of a family of

Read More

Data Visualization | Programming Tips

Robert AllisonJune 4, 2019 0

Converting from Gchart to SGplot - simple bar chart

You've probably heard of the famous Rosetta Stone. It had the same decree written on it in both ancient Egyptian and Greek, and was an essential key to help modern historians decipher and translate the ancient Egyptian hieroglyphs. To help the 'old timers' (like me) shift from using SAS/Graph to the

Read More

Learn SAS | Programming Tips

Mike ZizziJune 4, 2019 0

SAS or Python? Why not use both? Using Python functions inside SAS programs

Two sayings I’ve heard countless times throughout my life are “Work smarter, not harder,” and “Use the best tool for the job.” If you need to drive a nail, you pick up a hammer, not a wrench or a screwdriver. In the programming world, this could mean using an existing

Read More

Data Visualization | Learn SAS | Programming Tips

Rick WicklinJune 3, 2019 0

Graph wide data and long data in SAS

Statistical programmers and analysts often use two kinds of rectangular data sets, popularly known as wide data and long data. Some analytical procedures require that the data be in wide form; others require long form. (The "long format" is sometimes called "narrow" or "tall" data.) Fortunately, the statistical graphics procedures

Read More

Data Visualization | Programming Tips

Robert AllisonMay 29, 2019 0

Converting from Gplot to SGplot - scatter plots

You've probably heard of the famous Rosetta Stone. It had the same decree written on it in both ancient Egyptian and Greek, and was an essential key to help modern historians decipher and translate the ancient Egyptian hieroglyphs. To help the 'old timers' (like me) shift from using SAS/Graph to

Read More

Analytics | Programming Tips

Rick WicklinMay 28, 2019 0

The Theil-Sen robust estimator for simple linear regression

Modern statistical software provides many options for computing robust statistics. For example, SAS can compute robust univariate statistics by using PROC UNIVARIATE, robust linear regression by using PROC ROBUSTREG, and robust multivariate statistics such as robust principal component analysis. Much of the research on robust regression was conducted in the

Read More

Data Visualization | Programming Tips

Robert AllisonMay 21, 2019 0

Analyzing marathon data with a graph

Marathons seem to be popular these days, therefore I decided to dive into some data and find a way to apply analytics. You might find this interesting if you're a fan of marathons - or if you like seeing the details behind cool graphing techniques! Before we get started, here's

Read More

Sports & Entertainment

Analytics | Programming Tips

Rick WicklinMay 20, 2019 0

Critical values of the Kolmogorov-Smirnov test

Recently I wrote about how to compute the Kolmogorov D statistic, which is used to determine whether a sample has a particular distribution. One of the beautiful facts about modern computational statistics is that if you can compute a statistic, you can use simulation to estimate the sampling distribution of

Read More

Data Visualization | Programming Tips

Robert AllisonMay 16, 2019 0

NC tornado animation (1950-2018)

We recently had some severe storms come through North Carolina, which even spawned a tornado in Wake county (the county where I live and work). This got me wondering when and where we've had tornadoes in NC in the past ... and, of course, I had to create a map!

Read More

Programming Tips

Deva KumarMay 16, 2019 0

GraphQL and SAS Viya applications - a good match

In the article Serverless functions and SAS Viya - a good match I discussed using serverless functions to deliver SAS Viya applications. Ignoring all the buzz words, a serverless function boils down to a set of REST APIs. So, if you tried the example you are now a REST API

Read More

Data Visualization | Learn SAS | Programming Tips

PROC SGMAP SCATTER of Movie Locations

Kelly MillsMay 14, 2019 0

Geocoding US Street Addresses and Plotting Them with PROC SGMAP

I met many SAS programmers at the 2019 SAS Global Forum who geocode addresses using ArcGIS. Did you know that street address locations and other things can be found using the SAS GEOCODE procedure? PROC GEOCODE gives you coordinates for address, ZIP codes, ZIP+4 codes and cities. You can even

Read More

Learn SAS | Programming Tips

Rick WicklinMay 13, 2019 0

Write to a SAS data set from inside a SAS/IML loop

In SAS/IML programs, a common task is to write values in a matrix to a SAS data set. For some programs, the values you want to write are in a matrix and you use the CREATE FROM/APPEND FROM syntax to create the data set, as follows: proc iml; X =

Read More

Data Visualization | Programming Tips

Robert AllisonMay 9, 2019 0

US natural gas graph has 'flipped'!

You might have seen in the news that US exports of natural gas to Europe are up 300%. And we recently crossed the threshold where we export more natural gas than we import. This seems like a momentous occasion, and worthy of a graph! But first, let me make sure

Read More

Energy & Utilities

Programming Tips

Leonid BatkhanMay 8, 2019 0

Dividing by zero with SAS - myths and realities

To those of you who have not read my previous post, Dividing by zero with SAS, it's not too late to go back and make it up. You missed a lot of fun, deep thought and opportunity to solve an unusual SAS coding challenge. For those who have already read

Read More

Analytics | Programming Tips

Rick WicklinMay 8, 2019 0

Discrimination, accuracy, and stability in binary classifiers

At SAS Global Forum 2019, Daymond Ling presented an interesting discussion of binary classifiers in the financial industry. The discussion is motivated by a practical question: If you deploy a predictive model, how can you assess whether the model is no longer working well and needs to be replaced? Daymond

Read More

Analytics | Data Visualization | Programming Tips

Lavanya MandavilliMay 6, 2019 0

Five key security features in the SAS Visual Analytics app

App security is at the top of mind for just about everybody – users, IT folks, business executives. Rightfully so. Mobile apps and the devices on which they reside tend to travel around, without any physical boundaries that encompass the traditional desktop computers. In chatting with folks who are evaluating

Read More

Analytics | Programming Tips

Rick WicklinMay 6, 2019 0

How to simulate data from a generalized linear model

Here's a simulation tip: When you simulate a fixed-effect generalized linear regression model, don't add a random normal error to the linear predictor. Only the response variable should be random. This tip applies to models that apply a link function to a linear predictor, including logistic regression, Poisson regression, and

Read More

Data Visualization | Programming Tips

Robert AllisonApril 30, 2019 0

Mortgage rate graph animation

I always recommend looking at data in several different ways to get a more complete mental picture. And when the data is changing over time, one great way to view it is using an animation. Follow along for some tips & tricks to animate your own data over time. I'll

Read More

Learn SAS | Programming Tips

Rick WicklinApril 29, 2019 0

The normal mixture distribution in SAS

Did you know that SAS provides built-in support for working with probability distributions that are finite mixtures of normal distributions? This article shows examples of using the "NormalMix" distribution in SAS and describes a trick that enables you to easily work with distributions that have many components. As with all

Read More

Programming Tips

William BenjaminApril 25, 2019 0

Making the most of the ODS Excel destination

As a SAS programmer, you are asked to do many things with your data -- reading, writing, calculating, building interfaces, and occasionally sending data outside of SAS. One of the most popular outputs you may be tasked with creating is likely a Microsoft Excel workbook. Have you ever heard, “just

Read More

Data Visualization | Programming Tips

Robert AllisonApril 25, 2019 0

Polar graph remix - using sgplot (no gtl/sgrender!)

A few years ago Sanjay showed how to create a polar graph by creating a gtl template, and then plotting it using Proc SGRender. These days, Proc SGPlot has all the functionality you need to create this graph, therefore I've rewritten the example to just use SGPlot. And while I

Read More

Analytics | Programming Tips

Rick WicklinApril 24, 2019 0

A CUSUM test for autregressive models

The CUSUM test has many incarnations. Different areas of statistics use different assumption and test for different hypotheses. This article presents a brief overview of CUSUM tests and gives an example of using the CUSUM test in PROC AUTOREG for autoregressive models in SAS. A CUSUM test uses the cumulative

Read More

Programming Tips

Chevell ParkerApril 23, 2019 0

Control the location of tables, graphs, and text with ODS Excel

This article demonstrates the ODS Excel destination’s flexibility and how you can modify its default behavior by using the SHEET_INTERVAL= option.

Read More

Data Visualization | Programming Tips

Robert AllisonApril 22, 2019 0

Mortgage rates - overlaying multiple years in the same graph

While we're on the topic of mortgage rates, let's explore another technique for plotting and comparing the rate data over several years. Last time, we plotted each year's data in a separate graph, and paneled them across the page. This time, let's overlay multiple years together in the same graph.

Read More

Banking | Government

Programming Tips

Sian RobertsApril 22, 2019 0

Moving from natural language processing to natural language understanding

Imagine a world where satisfying human-computer dialogues exist. With the resurgence of interest in natural language processing (NLP) and understanding (NLU) – that day may not be far off. In order to provide more satisfying interactions with machines, researchers are designing smart systems that use artificial intelligence (AI) to develop

Read More

Programming Tips

Rick WicklinApril 22, 2019 0

The CUSUM test for randomness of a binary sequence

Many statistical tests use a CUSUM statistic as part of the test. It can be confusing when a researcher refers to "the CUSUM test" without providing details about exactly which CUSUM test is being used. This article describes a CUSUM test for the randomness of a binary sequence. You start

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerApril 19, 2019 0

Deeper enjoyment of your favorite shows -- through data

By using data provided by a Game of Thrones fan, we use SAS to look at screen time for scene locations and characters in this crazy popular show.

Read More

Previous 1 … 22 23 24 25 26 … 65 Next