Analytics | Learn SAS | Programming Tips

Rick WicklinApril 15, 2024 0

Distributions with specified skewness and kurtosis

A SAS programmer wanted to simulate samples from a family of Beta(a,b) distributions for a simulation study. (Recall that a Beta random variable is bounded with values in the range [0,1].) She wanted to choose the parameters such that the skewness and kurtosis of the distributions varied over range of

Read More

English

Programming Tips

Peter StyliadisApril 12, 2024 0

Python Integration to SAS® Viya® - Part 23 - Executing SQL on Snowflake

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. Given the exciting developments around SAS & Snowflake, I'm eager to demonstrate how to effortlessly connect Snowflake to the massively parallel processing CAS server in SAS Viya with the Python SWAT package. If you're interested

Read More

English

Programming Tips

Melodie RushApril 8, 2024 0

Getting Started with Python Integration to SAS Viya for Predictive Modeling - Comparing Logistic Regression and Decision Tree

Comparing Logistic Regression and Decision Tree - Which of our models is better at predicting our outcome? Learn how to compare models using misclassification, area under the curve (ROC) charts, and lift charts with validation data. In part 6 and part 7 of this series we fit a logistic regression

Read More

English

Analytics | Learn SAS | Programming Tips

Rick WicklinApril 8, 2024 0

Improve the Federal Reserve's dot plot

A dot plot is a standard statistical graphic that displays a statistic (often a mean) and the uncertainty of the statistic for one or more groups. Statisticians and data scientists use it in the analysis of group data. In late 2023, I started noticing headlines about "dot plots" in the

Read More

English

Programming Tips

Chris HemedingerApril 3, 2024 0

Through the years: SAS Enterprise Guide versions

My colleague Rick Wicklin maintains a nifty chart that shows the timeline of SAS releases since Version 8. A few of you asked if I could post a similar chart for SAS Enterprise Guide. Here it is. Like Rick, I used new features in SAS 9.4 to produce this chart

Read More

English

Data Visualization | Programming Tips

Rick WicklinApril 1, 2024 0

Add a second axis to a SAS graph

Recently, I saw a scatter plot that displayed the ticks, values, and labels for a vertical axis on the right side of a graph. In the SGPLOT procedure in SAS, you can use the Y2AXIS option to move an axis on the right side of a graph. Similarly, you can

Read More

English

Programming Tips

Wilbram HazejagerMarch 22, 2024 0

Promise delivered: SAS Enterprise Guide integration with SAS Viya 4

SAS Enterprise Guide 8.4 is released, and it supports connections to SAS Viya to run SAS programs, access data, and more!

Read More

English

Programming Tips | SAS Administrators | SAS Events

Chris HemedingerMarch 22, 2024 0

What's next for SAS 9 and SAS Enterprise Guide?

SAS announces continued support and releases for SAS 9 and a new role for SAS Enterprise Guide with SAS Viya.

Read More

English

Analytics | Data Management | Programming Tips | SAS Administrators

Andrei ShinMarch 20, 2024 0

REST API를 사용하여 ‘SAS 컨테이너 런타임’ 이미지 업데이트하기

1. ‘SAS 컨테이너 런타임’이란? SAS는 SAS Viya 2021.1.1.3에서 SAS 컨테이너 런타임(SAS Container Runtime, 이하 SCR)을 출시했으며, 그 이후 많은 고객이 운영환경에서 SCR을 구현했습니다. 이 혁신적인 런타임 엔진은 SAS 모델과 의사결정을 Open Container Initiative (OCI) 호환 컨테이너에 배포하는 역할을 합니다. SCR은 표준 기술을 사용하여 SAS Viya 외부에서 모델과 의사결정을 실행합니다. 클라우드

Read More

Korean

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