Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Analytics | Learn SAS | Programming Tips

Rick WicklinOctober 24, 2022 0

Implement binary logistic regression from first principles

I recently gave a presentation about the SAS/IML matrix language in which I emphasized that a matrix language enables you to write complex analyses by using only a few lines of code. In the presentation, I used least squares regression as an example. One participant asked how many additional lines

Read More

Programming Tips

Chevell ParkerOctober 21, 2022 0

Formatting your Microsoft Excel output using ODS Excel

SAS' Chevell Parker walks you through eight formatting scenarios that can occur when using ODS Excel and how to address them using formatting and formatting values after export.

Read More

Analytics | Learn SAS | Programming Tips

Rick WicklinOctober 19, 2022 0

On solving rank-deficient systems of equations in SAS

Recently, I needed to write a program that can provide a solution to a regression-type problem, even when the data are degenerate. Mathematically, the problem is an overdetermined linear system of equations X*b = y, where X is an n x p design matrix and y is an n x 1 vector. For most

Read More

Learn SAS | Programming Tips

Leonid BatkhanOctober 18, 2022 0

Adaptive SAS programming for the Software Development Life Cycle

Leonid Batkhan reveals programming technique to build adaptive SAS programs to facilitate transition between various environments for a smoother SDLC.

Read More

Data Visualization | Programming Tips

Cindy WangOctober 14, 2022 0

Export a Visual Analytics report using REST APIs

In my previous blog Programmatically export a Visual Analytics report to PDF - SAS Users, I use the SAS Visual Analytics SDK to export a report to PDF, which is quite simple if we have basic knowledge with JavaScript programming. It works for both the latest version of SAS Viya

Read More

Programming Tips

Peter Styliadis

Peter StyliadisOctober 13, 2022 0

Getting started with Python integration to SAS® Viya® - Part 11 - Rename Columns

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, how to execute CAS actions, and how to summarize columns. Now it's time to focus on how to rename columns in CAS tables. Load and explore data

Read More

Learn SAS | Programming Tips

Rick WicklinOctober 10, 2022 0

The expected volume of a random tetrahedron in a cube

One of the benefits of social media is the opportunity to learn new things. Recently, I saw a post on Twitter that intrigued me. The tweet said that the expected volume of a random tetrahedron in the unit cube (in 3-D) is E[Volume] = 0.0138427757.... This number seems surprisingly small!

Read More

Programming Tips

Peter Styliadis

Peter StyliadisOctober 6, 2022 0

Getting Started with Python Integration to SAS® Viya® - Part 10 - Group and Aggregate CAS Tables

Group and aggregate CAS tables Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, how to execute CAS actions, and how to summarize columns. Now it's time to focus on how to group and aggregate CAS

Read More

Learn SAS | Programming Tips

Rick WicklinOctober 5, 2022 0

Checksums and data integrity in SAS programs

Have you ever typed your credit card into an online order form and been told that you entered the wrong number? Perhaps you wondered, "How do they know that the numbers I typed do not make a valid credit card number?" The answer is that credit card numbers and other

Read More

Programming Tips

Suzanne MorgenOctober 3, 2022 0

Meet our SAS Press Author of the Month -- Jane Eslinger

We publish a lot of books by SAS experts at SAS Press, but how does someone become an expert in the first place? Becoming certified is one step, but who develops the certifications in the first place? Those are the true experts. They have to have a deep understanding of

Read More

Analytics | Learn SAS | Programming Tips

Rick WicklinOctober 3, 2022 0

Compute moments of probability distributions in SAS

A previous article discusses the definitions of three kinds of moments for a continuous probability distribution: raw moments, central moments, and standardized moments. These are defined in terms of integrals over the support of the distribution. Moments are connected to the familiar shape features of a distribution: the mean, variance,

Read More

Programming Tips

Cindy WangSeptember 30, 2022 0

How to draw a swimmer plot in SAS Visual Analytics

SAS' Cindy Wang shows you how to create a swimmer plot using SAS Visual Analytics.

Read More

Learn SAS | Programming Tips

Rick WicklinSeptember 26, 2022 0

Display correlations in a list format

The correlations between p variables are usually displayed by using a symmetric p x p matrix of correlations. However, sometimes you might prefer to see the correlations listed in "long form" as a three-column table, as shown to the right. In this table, each row shows a pair of variables and the

Read More

Programming Tips | SAS Administrators

Leonid BatkhanSeptember 20, 2022 0

Automating SAS processes using Windows batch files

Leonid Batkhan shows you how to write Windows batch scripts that allow for conditional execution and effective job scheduling.

Read More

Learn SAS | Programming Tips

Rick WicklinSeptember 19, 2022 0

Generate random ID values for subjects in SAS

A common question on SAS discussion forums is how to use SAS to generate random ID values. The use case is to generate a set of random strings to assign to patients in a clinical study. If you assign each patient a unique ID and delete the patients' names, you

Read More

Programming Tips

Peter Styliadis

Peter StyliadisSeptember 14, 2022 0

Getting Started with Python Integration to SAS® Viya® - Part 9 - Summarize Columns

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, how to execute CAS actions, and how to filter CAS tables. Now it's time to focus on how to summarize columns. Load and explore data Let's first load

Read More

Learn SAS | Programming Tips

Rick WicklinSeptember 14, 2022 0

Base 26: A mapping from integers to strings

I recently showed how to represent positive integers in any base and gave examples of base 2 (binary), base 8 (octal), and base 16 (hexadecimal). One fun application is that you can use base 26 to associate a positive integer to every string of English characters. This article shows how

Read More

Learn SAS | Programming Tips

Rick WicklinSeptember 12, 2022 0

Convert integers from base 10 to another base

An integer can be represented in many ways. This article shows how to represent a positive integer in any base b. The most common base is b=10, but other popular bases are b=2 (binary numbers), b=8 (octal), and b=16 (hexadecimal). Each base represents integers in different ways. Think of a

Read More

Data Visualization | Programming Tips

Dan HeathSeptember 10, 2022 0

Complex Layouts using the SG Procedures

The Graph Template Language (GTL) is a powerful tool for creating a wide range of graphic displays. One feature GTL has is the ability to combine independent plots together into one paneled display. The SG procedures have some limited capabilities in this area; but in this post, I am going

Read More

Analytics | Learn SAS | Programming Tips

Rick WicklinSeptember 7, 2022 0

A test for monotonic sequences and functions

Monotonic transformations occur frequently in math and statistics. Analysts use monotonic transformations to transform variable values, with Tukey's ladder of transformations and the Box-Cox transformations being familiar examples. Monotonic distributions figure prominently in probability theory because the cumulative distribution is a monotonic increasing function. For a continuous distribution that is

Read More

Learn SAS | Programming Tips

Rick WicklinAugust 31, 2022 0

Two types of syntax for the SELECT-WHEN statement in SAS

The SELECT-WHEN statement in the SAS DATA step is an alternative to using a long sequence of IF-THEN/ELSE statements. Although logically equivalent to IF-THEN/ELSE statements, the SELECT-WHEN statement can be easier to read. This article discusses the two distinct ways to specify the SELECT-WHEN statement. You can use the first

Read More

Programming Tips

Ursula PoloAugust 29, 2022 0

SAS Viya Workload Orchestrator CLI Plug-in

A key tool for SAS Viya admins and many users is the command line interface (CLI). You can think of it in terms of other CLIs, but with direct access to SAS Viya. The CLI facilitates automation of tasks as well as other administrative functions. You can find information about

Read More

Data Visualization | Programming Tips

Rick WicklinAugust 29, 2022 0

Order the bars in a bar chart with PROC SGPLOT

A SAS programmer was trying to understand how PROC SGPLOT orders categories and segments in a stacked bar chart. As with all problems, it is often useful to start with a simpler version of the problem. After you understand the simpler situation, you can apply that understanding to the more

Read More

Data Visualization | Learn SAS | Programming Tips

Rick WicklinAugust 24, 2022 0

How to stagger labels on an axis in PROC SGPLOT

A SAS programmer asked how to display long labels at irregular locations along the horizontal axis of scatter plot. The labels indicate various phases of a clinical study. This article discusses the problem and shows how to use the FITPOLICY=STAGGER option on the XAXIS or X2AXIS statement to avoid collisions

Read More

Programming Tips

Kevin RussellAugust 17, 2022 0

The ADDROWID data set option maintains the order of your data when executing a DATA step in SAS® Cloud Analytic Services (CAS)

SAS' Kevin Russell compares how you order your data with a BY statement in SAS 9.4 versus in CAS using the ADDROWID data set option in SAS Viya.

Read More

Programming Tips

Teri PatsilarasAugust 10, 2022 0

SAS Visual Analytics: Automatic Actions: a three-part series

If you haven't explored data with Automatic Actions enabled yet, then read on to learn about some fast and easy ways to gain insights using One-way filters, Two-way filters or Linked Selection! Part 1 – Easy exploration for multiple data sources In this post, we focus on One-way filters. Here

Read More

Learn SAS | Programming Tips | Students & Educators

Suzanne MorgenAugust 1, 2022 0

Meet our SAS Press Author of the Month – Ron Cody

Recently, the SAS Press team moved to a new building on the SAS campus. And when the SAS Press team moves, we bring a lot of books with us! Packing and organizing all of our books gave us a chance to appreciate all of our authors’ hard work during the

Read More

Programming Tips

Ursula PoloJuly 27, 2022 0

Manage and Balance Workloads in SAS

SAS Grid Manager for Platform, SAS Grid Manager, and SAS Viya Workload Management all manage and balance job loads, right? So, are there three SAS products providing the same functionality? Let’s explore, as I am curious in your answer after you read this article. Each of the three applications has

Read More

Learn SAS | Programming Tips

Rick WicklinJuly 25, 2022 0

Monte Carlo estimates of area

I've previously shown how to use Monte Carlo simulation to estimate probabilities and areas. I illustrated the Monte Carlo method by estimating π ≈ 3.14159... by generating points uniformly at random in a unit square and computing the proportion of those points that were inside the unit circle. The previous

Read More

Programming Tips

Peter Styliadis

Peter StyliadisJuly 21, 2022 0

Getting Started with Python Integration to SAS® Viya® - Part 8 - Creating Calculated Columns

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, how to execute CAS actions, and how to filter CAS tables. Now it's time to focus on creating calculated columns on a CAS table. Load and explore

Read More

Previous 1 … 6 7 8 9 10 … 64 Next