Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Learn SAS | Programming Tips

Rick WicklinMarch 4, 2020 0

Store pre-computed matrices in a list

Suppose that a data set contains a set of parameter values. For each row of parameters, you need to perform some computation. A recent discussion on the SAS Support Communities mentions an important point: if there are duplicate rows in the data, a program might repeat the same computation several

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerFebruary 27, 2020 0

Viewing SAS macro variables in SAS Enterprise Guide

If you use SAS macro variables in your programs (who doesn't?), then the SAS Macro Variable viewer is immensely useful to see current macro var values.

Read More

Data Visualization | Programming Tips

Robert AllisonFebruary 26, 2020 0

How long does it take to paddle a canoe 100 miles?

I'm a bit of a boat paddling enthusiast, as you might have guessed from some of my previous paddling blog posts. The amount of exertion in race-paddling is similar to running - the longest race I've paddled in a race so far was 13 miles (half-marathon distance). But in the

Read More

Sports & Entertainment

Analytics | Programming Tips

Suzanne MorgenFebruary 26, 2020 0

Propensity Score Estimation with PROC PSMATCH and PROC LOGISTIC

Do you wish you could predict the likelihood that one of your customers will open your marketing email? Or what if you could tell whether a new medical treatment for a patient will have a better outcome than the standard treatment? If you are familiar with propensity modeling, then you

Read More

Communications | Education | Health Care | Life Sciences | Retail

Data Visualization | Programming Tips

Debpriya Sarkar

Debpriya SarkarFebruary 24, 2020 0

Ridgeline Plots using SGPLOT

Ridgeline plots are useful for visualizing changes in the shapes of distribution over multiple groups or time periods. Let us look at an example of how we can create this plot using the SGPLOT procedure that is part of the ODS Graphics Procedures. For this example, we will plot the

Read More

Data Management | Programming Tips

Mary Kathryn QueenFebruary 24, 2020 0

How to use Suggestions in SAS® Data Studio

SAS Technical Training Consultant Mary Kathryn Queen introduces you to SAS Data Studio's Suggestions feature.

Read More

Programming Tips

Rick WicklinFebruary 24, 2020 0

Visualization of a binary classification analysis

The purpose of this article is to show how to use SAS to create a graph that illustrates a basic idea in a binary classification analysis, such as discriminant analysis and logistic regression. The graph, shown at right, shows two populations. Subjects in the "negative" population do not have some

Read More

Learn SAS | Programming Tips

Rick WicklinFebruary 19, 2020 0

A list of SAS DATA step functions that do not run in CAS

Are you a statistical programmer whose company has adopted SAS Viya? If so, you probably know that the DATA step can run in parallel in SAS Cloud Analytic Services (CAS). As Sekosky (2017) says, "running in a single thread in SAS is different from running in many threads in CAS."

Read More

Programming Tips

Lora D. DelwicheFebruary 18, 2020 0

Test your SAS skills with the newest edition of Exercises and Projects for The Little SAS Book

In case you missed the news, there is a new edition of The Little SAS Book! Last fall, we completed the sixth edition of our book, and even though it is actually a few pages shorter than the fifth edition, we managed to add many more topics to the book.

Read More

Programming Tips

Suzanne MorgenFebruary 14, 2020 0

Learn to Love SAS LIKE

In honor of Valentine’s day, we thought it would be fitting to present an excerpt from a paper about the LIKE operator because when you like something a lot, it may lead to love! If you want more, you can read the full paper “Like, Learn to Love SAS® Like”

Read More

Data Visualization | Programming Tips

Robert AllisonFebruary 13, 2020 0

Giving your maps more visual impact!

There are many ways to add more "visual impact" to your maps. Some techniques grab the users' attention, but often don't add anything useful to the message the map is trying to convey (such as 3D tricks, or flashy/gratuitous images and infographics). I encourage you to design maps that have

Read More

Energy & Utilities

Analytics | Learn SAS | Programming Tips

Rick WicklinFebruary 12, 2020 0

The Johnson system: Which distribution should you choose to model data?

The Johnson system (Johnson, 1949) contains a family of four distributions: the normal distribution, the lognormal distribution, the SB distribution, and the SU distribution. Previous articles explain why the Johnson system is useful and show how to use PROC UNIVARIATE in SAS to estimate parameters for the Johnson SB distribution

Read More

Learn SAS | Programming Tips

Rick WicklinFebruary 10, 2020 0

Find the fractional part of a number

You can represent every number as a nearby integer plus a decimal. For example, 1.3 = 1 + 0.3. The integer is called the integer part of x, whereas the decimal is called the fractional part of x (or sometimes the decimal part of x). This representation is not unique.

Read More

Programming Tips

Ron CodyFebruary 5, 2020 0

Finding Possible Data Errors Using the %Auto_Outliers Macro

One of the first and most important steps in analyzing data, whether for descriptive or inferential statistical tasks, is to check for possible errors in your data. In my book, Cody's Data Cleaning Techniques Using SAS, Third Edition, I describe a macro called %Auto_Outliers. This macro allows you to search

Read More

Programming Tips

Rick WicklinFebruary 3, 2020 0

What sample size do you need for a binomial test of proportions?

Recently someone on social media asked, "how can I compute the required sample size for a binomial test?" I assume from the question that the researcher was designing an experiment to test the proportions between two groups, such as a control group and a treatment/intervention group. They wanted to know

Read More

Data Visualization | Programming Tips

Robert AllisonJanuary 31, 2020 0

Magnetic north moved 50 miles last year (let's map it!)

I've read several articles that mentioned the north magnetic pole has been moving more in the past few decades, than in the previous few hundred years. And as a Map Guy, I knew I just had to plot this data on a map, and see it for myself! I provide

Read More

Learn SAS | Programming Tips

Leonid BatkhanJanuary 27, 2020 0

Shifting a date by a given number of workdays

This blog post demonstrates process and SAS coding techniques to shift dates by a given number of workdays accounting for weekends and holidays.

Read More

Analytics | Data Visualization | Programming Tips

Rick WicklinJanuary 27, 2020 0

The Johnson SU distribution

The Johnson system (Johnson, 1949) contains a family of four distributions: the normal distribution, the lognormal distribution, the SB distribution (which models bounded distributions), and the SU distribution (which models unbounded distributions). Note that 'B' stands for 'bounded' and 'U' stands for 'unbounded.' A previous article explains the purpose of

Read More

Data for Good | Data Visualization | Programming Tips

Robert AllisonJanuary 24, 2020 0

Creating a map to track the coronavirus

The coronavirus has been a big item in the news lately - it's a pneumonia-like illness that has killed several people. It's thought to have started in China, and has spread to several other countries (including at least one case in the U.S.). The World Health Organization says the coronavirus

Read More

Data for Good | Data Visualization | Programming Tips

Robert AllisonJanuary 23, 2020 0

How to prepare (your graphs) for flu season

The flu season has started here in the U.S., and according to the Centers for Disease Control and Prevention (CDC) data it has caused 214 deaths in the first week of 2020. Is this number higher, or lower, than usual? When does the flu season start, and how long does

Read More

Programming Tips

Lora D. DelwicheJanuary 21, 2020 0

Expand Your SAS Knowledge by Learning PROC SQL

One great thing about being a SAS programmer is that you never run out of new things to learn. SAS often gives us a variety of methods to produce the same result. One good example of this is the DATA step and PROC SQL, both of which manipulate data. The

Read More

Analytics | Data Visualization | Programming Tips

Rick WicklinJanuary 20, 2020 0

The Johnson SB distribution

From the early days of probability and statistics, researchers have tried to organize and categorize parametric probability distributions. For example, Pearson (1895, 1901, and 1916) developed a system of seven distributions, which was later called the Pearson system. The main idea behind a "system" of distributions is that for each

Read More

Data Visualization | Programming Tips

Robert AllisonJanuary 15, 2020 0

Where's the best place to retire, in the U.S.?

As I get older, a few of my buddies are starting to retire. And this makes me think about my own retirement (not that I'm anywhere near old enough to retire, mind you!) Therefore when I saw a list of the "Best & Worst Cities for Retiring" it caught my

Read More

Learn SAS | Programming Tips

Suzanne MorgenJanuary 13, 2020 0

Foresight is 2020! New books to take your skills to the next level

Are you ready to get a jump start on the new year? If you’ve been wanting to brush up your SAS skills or learn something new, there’s no time like a new decade to start! SAS Press is releasing several new books in the upcoming months to help you stay

Read More

Programming Tips

Amber ElamJanuary 10, 2020 0

Why does my SAS date have the wrong century?

2020 is here and systems that use 2-digit years in date values are getting confused. Do we mean 1920 or 2020? In SAS, the YEARCUTOFF= option lets you decide.

Read More

Programming Tips

Ron CodyJanuary 8, 2020 0

Adventures of a SAS detective and the fantastic FIND function

Did I trick you into seeing what this blog is about with its mysterious title? I am going to talk about how to use the FIND function to search text values. The FIND function searches for substrings in character values. For example, you might want to extract all email addresses

Read More

Data Visualization | Programming Tips

Robert AllisonJanuary 7, 2020 0

Are winters colder in North Carolina, or Canada?

If someone proposes a bet to you, then you should be suspicious that they already know they're going to win. And one frequent topic of such bets is the weather... What if I bet you there's a city in Canada with a warmer average January temperature than Raleigh, NC? You

Read More

Data Visualization | Learn SAS | Programming Tips

Rick WicklinJanuary 6, 2020 0

Top posts from The DO Loop in 2019

Last year, I wrote more than 100 posts for The DO Loop blog. The most popular articles were about SAS programming tips for data analysis, statistical analysis, and data visualization. Here are the most popular articles from 2019 in each category. SAS programming tips Create training, testing, and validation data

Read More

Data Visualization | Programming Tips

Robert AllisonDecember 23, 2019 0

What restaurant is always open on holidays? - Waffle House!

Do you find yourself on the road during the holidays, and looking for a place to eat that's still open? Or perhaps you're like me - I don't cook at home, and I'm not really into visiting family for the holidays and eating with them. Well then, you probably know

Read More

Data Management | Programming Tips

Yinliang WuDecember 20, 2019 0

How to filter variables by percentage of missing values or duplicate values in SAS

This article discusses how to use SAS to filter variables in a dataset based on the percentage of missing values or duplicate values. The missing value statistics can be implemented by either DATA step programming on your own or reusing the existing powerful PROC FREQ.

Read More

Previous 1 … 19 20 21 22 23 … 64 Next