Analytics | Learn SAS | Programming Tips

Rick WicklinMarch 20, 2024 0

Maximum likelihood estimates for linear regression

A statistical analyst used the GENMOD procedure in SAS to fit a linear regression model. He noticed that the table of parameter estimates has an extra row (labeled "Scale") that is not a regression coefficient. The "scale parameter" is not part of the parameter estimates table produced by PROC REG

Read More

English

Learn SAS | Programming Tips

Rick WicklinMarch 11, 2024 0

Pizza pi

Happy Pi Day! Every year on March 14th (written 3/14 in the US), people in the mathematical sciences celebrate all things pi-related because 3.14 is the three-decimal approximation to π ≈ 3.14159265358979.... Pi is a mathematical constant defined as the ratio of a circle's circumference (C) to its diameter (D).

Read More

English

Learn SAS | Programming Tips

Rick WicklinMarch 6, 2024 0

A generalized Number-Word Game

I recently wrote about the Number-Word Game, which is an iterative algorithm that generates a sequence of natural numbers by using the lengths of the words for the numbers. In English, the words are "one", "two", "three", and so on. You can play the Number-Word Game in any alphabetic language

Read More

English

Learn SAS | Programming Tips

Rick WicklinMarch 4, 2024 0

The Number-Word Game

Have you heard about the Number-Word Game? This is a simple game that has the following rules: Start with any positive integer. Write down the English word for the integer. Count the number of letters in the word. This gives a new positive integer. Go to (2). Repeat until a

Read More

English

Programming Tips

Melodie RushFebruary 27, 2024 0

Getting Started with Python Integration to SAS Viya for Predictive Modeling - Fitting a Decision Tree

Learn how to fit a decision tree and use your decision tree model to score new data. In Part 6 of this series we took our Home Equity data saved in Part 4 and fit a logistic regression to it. In this post we will use the same data and

Read More

English

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