Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Data Visualization | Programming Tips

Robert AllisonJuly 3, 2019 0

Can you choose an SUV based on MPG?

I think it's time to replace my 2008 Prius. It has served me well, been basically maintenance-free, and gotten good gas mileage ... so, why not just get a newer Prius? Well, I've got the itch to get back into an SUV for my daily driver (I had a Bronco

Read More

Energy & Utilities

Learn SAS | Programming Tips

Rick WicklinJuly 3, 2019 0

Create a custom informat in SAS

An informat helps you read data into a SAS data set. SAS supports more than 100 informats. The most common informats are related to dates and times and make it easy to read an input string such as 28JAN2001 and convert it to a SAS date such as 15003. Yet

Read More

Learn SAS | Programming Tips

Missy HannahJuly 2, 2019 0

Summer reading – Book recommendations from SAS Press authors

One of my favorite parts of summer is a relaxing weekend by the pool. Summer is the time I get to finally catch up on my reading list, which has been building over the year. So, if expanding your knowledge is a goal of yours this summer, SAS Press has

Read More

Programming Tips

Chris HollandJune 27, 2019 0

Working with ever-changing CDISC standards

When Jack Shostak and I first started thinking about writing a SAS book on implementing CDISC (Clinical Data Interchange Standards Consortium) standards, we held one truth to be self-evident: that at least some parts of the book would be outdated before it was even published. Thanks to some lucky timing

Read More

Learn SAS | Programming Tips

Leonid BatkhanJune 26, 2019 0

Finding n-th instance of a substring within a string

"There's a way to do it better - find it." - Thomas A. Edison When it comes to SAS coding, this quote by Thomas A. Edison is my best advisor. Time permitting, I love finding better ways of implementing SAS code. But what code feature means “better” – brevity, clarity

Read More

Analytics | Learn SAS | Programming Tips

Rick WicklinJune 26, 2019 0

Jump-start PROC LOGISTIC by using parameter estimates from PROC HPLOGISTIC

SAS/STAT software contains a number of so-called HP procedures for training and evaluating predictive models. ("HP" stands for "high performance.") A popular HP procedure is HPLOGISTIC, which enables you to fit logistic models on Big Data. A goal of the HP procedures is to fit models quickly. Inferential statistics such

Read More

Programming Tips

Deva KumarJune 25, 2019 0

"CAS Stored Process" with my Favorite Action Hero runCasl

In his article How to use CASL to develop and work with user-defined CAS actions, Brian Kinnebrew defines CASL as "a language specification used by the SAS client to interact with and provide easy access to Cloud Analytic Services (CAS). CASL is a statement-based scripting language with many uses and

Read More

Programming Tips

Kevin RussellJune 21, 2019 0

Learn the three easiest ways to load data into CAS tables

For every project in SAS®, the first step is almost always making your data available. This blog shows you how to load three of the most common input data types—a data set, a text file, and a Microsoft Excel file—into SAS® Cloud Analytic Services (CAS) tables. The three methods that

Read More

Data Visualization | Programming Tips

Robert AllisonJune 19, 2019 0

Airbnb's top wish-listed homes in NC!

As the sharing economy grows, you can catch a ride on Uber, have meals delivered by Grubhub ... and even stay in someone else's house (rather than a hotel) via sites like Airbnb. And speaking of that last one, I recently read an article listing Airbnb's top 20 'wish-listed' homes

Read More

Hospitality | Travel

Analytics | Programming Tips | Risk Management

Frederik Vandenberghe

Frederik VandenbergheJune 18, 2019 0

Deploy SAS Viya on AWS - Quick Start

As a data scientist, did you ever come to the point where you felt the need for an evolved analytics platform bringing together the disparate skills of open source and commercial software? A system that can enable advanced analytic capabilities. This is now possible and easy to implement. With many

Read More

Programming Tips

Sian RobertsJune 18, 2019 0

Understanding Item Response Theory with SAS

What is Item Response Theory? Item Response Theory (IRT) is a way to analyze responses to tests or questionnaires with the goal of improving measurement accuracy and reliability. A common application is in testing a student’s ability or knowledge. Today, all major psychological and educational tests are built using IRT.

Read More

Data Visualization | Programming Tips

Robert AllisonJune 14, 2019 0

Fine-tuning the date axis in your bar chart

In these modern times, my utility bill has a bar chart so I can see how my current consumption compares to my historical usage. I decided to create my own version of this utility bill bar chart, and make a few improvements along the way. If you're into SGplot bar

Read More

Energy & Utilities

Data Visualization | Programming Tips

Robert AllisonJune 12, 2019 0

Converting from SAS/Graph to ODS Graphics - color control

In this 'Rosetta Graph' example, I demonstrate how to control bar chart colors in Gchart and SGplot. But first, here's a little diversion... some artwork in my office here at SAS. There's a *lot* of artwork hanging around at SAS, but this particular painting wasn't created by the SAS artists

Read More

Advanced Analytics | Programming Tips

Rick WicklinJune 12, 2019 0

Leave-one-out statistics and a formula to update a matrix inverse

For linear regression models, there is a class of statistics that I call deletion diagnostics or leave-one-out statistics. These observation-wise statistics address the question, "If I delete the i_th observation and refit the model, what happens to the statistics for the model?" For example: The PRESS statistic is similar to

Read More

Programming Tips | SAS Administrators

Joe FurbeeJune 10, 2019 0

Deploying the Full SAS Viya Stack in Kubernetes

This article is a follow-on to a recent post from Jeff Owens, Getting started with SAS Containers. In that post, Jeff discussed building and running a single container for a SAS Viya runtime/IDE. Today we will go through how to build and run the full SAS Viya stack - visual

Read More

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

Previous 1 2 3 4 … 44 Next