Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

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

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

Previous 1 2 3 4 5 … 45 Next