Analytics | Data Visualization | Programming Tips

Chris HemedingerFebruary 27, 2024 0

Visualized: US Currency in circulation, past and present

This phenomenon has been in the news recently, so I've updated this article that I originally published in 2017. The paper currency in circulation in the US is mostly $100 bills. And not just by a little bit -- these account for 34% of the notes by denomination and nearly

Read More

English

Banking

Analytics | Learn SAS | Programming Tips

Rick WicklinFebruary 21, 2024 0

On using the range to estimate the variability of small samples

In statistical quality control, practitioners often estimate the variability of products that are being produced in a manufacturing plant. It is important to estimate the variability as soon as possible, which means trying to obtain an estimate from a small sample. Samples of size five or less are not uncommon

Read More

English

Learn SAS | Programming Tips

Rick WicklinFebruary 19, 2024 0

The linear distribution on an interval

In a recent Monte Carlo project, I needed to simulate numbers on an interval by using a continuous linear probability density function (PDF). An example is shown to the right. In this example, the linear density function is decreasing on the interval, but the function could also be constant or

Read More

English

Programming Tips

Chris HemedingerFebruary 15, 2024 0

SAS knows it's a leap year. Do you?

How to calculate a leap year in SAS - the easy way!

Read More

English

Programming Tips

Chris HemedingerFebruary 13, 2024 0

5 reasons to use VS Code for your SAS code projects

The SAS extension for VS Code supports SAS syntax and programming, and can connect to almost all SAS environments.

Read More

English

Analytics | Learn SAS | Programming Tips

Rick WicklinFebruary 12, 2024 0

An exact formula for the sampling distribution of the correlation coefficient

I read a journal article in which a researcher used a formula for the probability density function (PDF) of the sample correlation coefficient. The formula was rather complicated, and presented with no citation, so I was curious to learn more. I found the distribution for the correlation coefficient in the

Read More

English

Learn SAS | Programming Tips

Rick WicklinJanuary 31, 2024 0

The name of the variable that contains the largest value in each row

A SAS programmer wanted to find the name of the variable for each row that contains the largest value. This task is useful for wide data sets in which each observation has several variables that are measured on the same scale. For example, each observation in the data might represent

Read More

English

Programming Tips

Peter StyliadisJanuary 30, 2024 0

9 for SAS9 – Top Tips for SAS 9 Programmers Moving to SAS Viya

Transitioning from SAS9 to SAS Viya can be uncertain for SAS programmers. Whether your organization is making the move and you’re curious about your current SAS analytical workflows, or you're contemplating moving to SAS Viya and concerned about its impact on your SAS expertise and programs. The hesitation is understandable.

Read More

English

Programming Tips

Chris HemedingerJanuary 28, 2024 0

How to split a large file into smaller chunks using SAS

Use SAS DATA step to split a large binary file into smaller pieces, which can help with file upload operations,

Read More

English

Learn SAS | Programming Tips

Rick WicklinJanuary 24, 2024 0

Implement Jacobi's method in SAS

In a first course in numerical analysis, students often encounter a simple iterative method for solving a linear system of equations, known as Jacobi's method (or Jacobi's iterative method). Although Jacobi's method is not used much in practice, it is introduced because it is easy to explain, easy to implement,

Read More

English

Data Visualization | Programming Tips

Peter StyliadisJanuary 19, 2024 0

My Family of Four's Monthly Water Usage (Gallons) Compared to the Town of Cary's Average

Have you ever been curious about your monthly water consumption and how it compares to others in your community? Recently, I had this question and decided to get ahold of my family's water usage data for analysis. Harnessing the power of data visualization, I compared my family of four's monthly

Read More

English

Programming Tips

Melodie RushJanuary 17, 2024 0

Getting Started with Python Integration to SAS Viya for Predictive Modeling - Fitting a Logistic Regression

Learn how to fit a logistic regression and use your model to score new data. In part 4 of this series, we created and saved our modeling data set with all our updates from imputing missing values and assigning rows to training and validation data. Now we will use this

Read More

English

Learn SAS | Programming Tips

Rick WicklinJanuary 15, 2024 0

Simulate correlated continuous and discrete variables

Statistical software provides methods to simulate independent random variates from continuous and discrete distributions. For example, in the SAS DATA step, you can use the RAND function to simulate variates from continuous distributions (such as the normal or lognormal distributions) or from discrete distributions (such as the Bernoulli or Poisson).

Read More

English

Learn SAS | Programming Tips

Ron CodyJanuary 10, 2024 0

Using the BXOR Function to Encode and Decode Text

SAS expert Ron Cody recently published a fiction novel, The Enigma Terrorists, in which SAS code plays a key role.

Read More

English

Programming Tips

Rick WicklinJanuary 10, 2024 0

Blog posts from 2023 that deserve a second look

In a previous article, I presented some of the most popular blog posts from 2023. The popular articles tend to discuss elementary topics that have broad appeal. However, I also wrote many technical articles about advanced topics. The following articles didn't make the Top 10 list, but they deserve a

Read More

English

Analytics | Data Visualization | Learn SAS | Programming Tips

Rick WicklinJanuary 3, 2024 0

Top 10 posts from The DO Loop in 2023

In 2023, I wrote 90 articles for The DO Loop blog. My most popular articles were about SAS programming, data visualization, and statistics. In addition, several "general interest" articles were popular, including my article for Pi Day and an article about AI chatbots. If you missed any of these articles,

Read More

English

Data Management | Programming Tips

Melodie RushDecember 22, 2023 0

Getting Started with Python Integration to SAS Viya for Predictive Modeling - Fitting a Linear Regression

Learn how to fit a linear regression and use your model to score new data. In part 4 of this series, we created our modeling dataset by including a column to identify the rows to be used for training and validating our model. Here, we will create our first model

Read More

English

Programming Tips | SAS Administrators

soyongyunDecember 18, 2023 0

SAS Enterprise Guide에서 Github 연결하기

SAS Enterprise Guide(이하 SAS EG)의 최근 버전에서는 기존의 폴더를 통한 접근뿐만 아니라 GitHub 레파지토리를 등록하여 프로그램을 실행, 수정, 관리할 수 있습니다. 회사나 개인 용도로 GitHub을 사용하고 있을 경우, SAS EG에 레파지토리를 등록하여 사용이 가능합니다. 기존에 SAS EG와 GitHub을 사용하는 분이라면 EG를 통해서 좀 더 효율적이고 편리하게 작업을 하실 수 있습니다.

Read More

Korean

Banking | Government | Insurance | Retail

Analytics | Learn SAS | Programming Tips

Rick WicklinDecember 4, 2023 0

Bivariate normal probability in SAS

A previous article discussed how to compute probabilities for the bivariate standard normal distribution. The standard bivariate normal distribution with correlation ρ is denoted BVN(0,ρ). For any point (x,y), you can use the PROBBNRM function in SAS to compute the probability that the random variables (X,Y) ~ BVN(0,ρ) is observed

Read More

English

Analytics | Programming Tips

Rick WicklinNovember 29, 2023 0

Bivariate normal probability in SAS: Rectangular regions

This article shows how to use SAS to compute the probabilities for two correlated normal variables. Specifically, this article shows how to compute the probabilities for rectangular regions in the plane. A second article discusses the computation over infinite regions such as quadrants. If (X,Y) are random variables that are

Read More

English

Data Management | Programming Tips

Melodie RushNovember 28, 2023 0

Getting Started with Python Integration to SAS Viya for Predictive Modeling - Creating Training and Validation Data Sets

Learn how to split your data into a training and validation data set to be used for modeling. In part 3 of this series, we replaced the missing values with imputed values. Our final step in preparing the data for modeling is to split the data into a training and

Read More

English

Analytics | Data Visualization | Programming Tips

Rick WicklinNovember 27, 2023 0

An example of finite-precision issues in a simple collinearity algorithm

The collinearity problem is to determine whether three points in the plane lie along a straight line. You can solve this problem by using middle-school algebra. An algebraic solution requires three steps. First, name the points: p, q, and r. Second, find the parametric equation for the line that passes

Read More

English

Data Visualization | Programming Tips

Rick WicklinNovember 20, 2023 0

Data visualization tip: Plot rates, not counts

Plot rates, not counts. This maxim is often stated by data visualization experts, but often ignored by practitioners. You might also hear the related phrases "plot proportions" or "plot percentages," which mean the same thing but expresses the idea alliteratively. An example in a previous article about avoiding alphabetical ordering

Read More

English

Programming Tips

Nancy RauschNovember 17, 2023 0

A tip for moving SAS Visual Analytics reports in SAS Viya 4 between SAS Viya environments

In SAS Viya 4 you can create Reports in SAS Visual Analytics that you may want to move around between machines. What if you want copy a report for example from a development environment folder to a production environment folder? You may want to work on the report in one system before putting it onto a final system and making it generally available. Or you may want to have a backup copy saved for recovery purposes. This blog post provides an updated description of how to easily save off SAS Visual Analytics report content to a file and easily move it between machines.

Read More

English

Data Management | Programming Tips

Melodie RushNovember 15, 2023 0

Getting Started with Python Integration to SAS Viya for Predictive Modeling - Imputing Missing Values

In part 1 of this series, we examined our data before building any models. Among the discoveries were missing values in some of our columns. Missing values are an inevitable part of data analysis. Whether it's due to a faulty sensor, human error, or simply the absence of information, missing

Read More

English

Learn SAS | Programming Tips

Rick WicklinNovember 15, 2023 0

On resizing an array when an index is out of bounds

Converting a program from one language to another can be a challenge. Even if the languages share many features, there is often syntax that is valid in one language that is not valid in another. Recently, a SAS programmer was converting a program from R to SAS IML. He reached

Read More

English

Programming Tips

Peter StyliadisNovember 8, 2023 0

Extract text from a PDF file using SAS Viya

You most likely have used a Portable Document Format (PDF) file in one form or another. Now, what if you have a PDF file and want to extract the text from the file? What if the PDF file contains input fields that a user fills in and you want to

Read More

English

Data Visualization | Learn SAS | Programming Tips

Rick WicklinNovember 8, 2023 0

4 ways to display an inset that contains statistics on a SAS graph

Sometimes it is helpful to display a table of statistics directly on a graph. A simple example is displaying the number of observations and the mean or median on a histogram. In SAS, the term inset is used to describe a table that is displayed on a graph. This article

Read More

English

Analytics | Programming Tips

Jongman JeongNovember 8, 2023 0

파라미터(Parameter)란 무엇인가? – 시리즈 ①

SAS Visual Anaytics(이하, VA)를 사용할 때, 리포트의 형태를 고정하고 변수만 변경하면서 그래프 및 값들이 바뀌는 결과를 확인할 수 있으면 더 효율적이지 않을까 생각해 본 적이 있으신가요? VA에서 파라미터를 활용하면 가능합니다. 파라미터의 활용법을 다루기 전에 전반적인 이해를 돕고자 파라미터가 무엇인지, 어떻게 사용하는 것인지 등에 대한 내용을 먼저 살펴보고자 합니다. 이번 블로그

Read More

Korean

Programming Tips

Kevin RussellNovember 6, 2023 0

The SAS® Viya® platform provides multiple methods to append to CAS tables

Appending data tables is a common task for data analysis. Here are three of the several methods possible through the SAS Viya platform.

Read More

English