Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

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

Learn SAS | Programming Tips

Rick WicklinJuly 20, 2022 0

A tip for visualizing the density function of a distribution

It isn't easy to draw the graph of a function when you don't know what the graph looks like. To draw the graph by using a computer, you need to know the domain of the function for the graph: the minimum value (xMin) and the maximum value (xMax) for plotting

Read More

Learn SAS | Programming Tips

Rick WicklinJuly 18, 2022 0

Tips for computing right-tail probabilities and quantiles

A colleague was struggling to compute a right-tail probability for a distribution. Recall that the cumulative distribution function (CDF) is defined as a left-tail probability. For a continuous random variable, X, with density function f, the CDF at the value x is F(x) = Pr(X ≤ x) = ∫

Read More

Programming Tips

Dr. Christian FG Schendera

Dr. Christian FG SchenderaJuly 12, 2022 0

Why learn SQL?

SQL (Structured Query Language) is the most widely used programming language for relational databases worldwide. No other programming language produces more hits for a web search than SQL and interest is growing rapidly. In June 2010, Google showed 135 million hits versus 586 million hits in June 2020. SQL is

Read More

Advanced Analytics | Analytics | Data Visualization | Programming Tips

Yinliang WuJuly 11, 2022 0

A better 3D scatter plot macro

SAS SGPLOT already provides the necessary graphical elements for complex visualization. 3D or high-dimensional data can be easily visualized after being projected appropriately. With SAS' strong support for animation features, SAS users can create complicated 3D or high dimension visualizations quickly.

Read More

Data Management | Learn SAS | Programming Tips

Leonid BatkhanJuly 7, 2022 0

Splitting a data table into multiple sheets of an Excel workbook

Leonid Batkhan shows how to split a data table into multiple Excel spreadsheets in a single workbook.

Read More

Learn SAS | Programming Tips

Rick WicklinJuly 6, 2022 0

Use functions in a WHERE statement to filter observations

Many people know that you can use "WHERE processing" in SAS to filter observations. A typical use is to process only observations that match some criterion. For example, the following WHERE statement processes only observations for male patients who have high blood pressure: WHERE Sex='Male' & Systolic > 140; In

Read More

Programming Tips

Peter Styliadis

Peter StyliadisJune 29, 2022 0

Getting Started with Python Integration to SAS® Viya® - Part 7 - Filtering CAS Tables

Welcome to the seventh installment in 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 work with the results. Now it's time to learn how to filter CAS tables. Load and explore data

Read More

Analytics | Data Visualization | Programming Tips

Rick WicklinJune 29, 2022 0

Compute the multivariate t density function

A previous article shows how to compute the probability density function (PDF) for the multivariate normal distribution. In a similar way, you can compute the density function for the multivariate t distribution. This article discusses the density function for the multivariate t distribution, shows how to compute it, and visualizes

Read More

Analytics | Programming Tips

Rick WicklinJune 27, 2022 0

The derivative of a quantile function

Recently, I needed to solve an optimization problem in which the objective function included a term that involved the quantile function (inverse CDF) of the t distribution, which is shown to the right for DF=5 degrees of freedom. I casually remarked to my colleague that the optimizer would have to

Read More

Learn SAS | Programming Tips

Leonid BatkhanJune 16, 2022 0

Automating Excel workbooks creation using SAS

Leonid Batkhan shows you how to automate and improve a sometimes onerous hands-on process of creating Excel workbooks.

Read More

Learn SAS | Programming Tips

Rick WicklinJune 13, 2022 0

Detect palindromes and rotational palindromes in SAS

A palindrome is a sequence of letters that is the same when read forward and backward. In brief, if you reverse the sequence of letters, the word is unchanged. For example, 'mom' and 'racecar' are palindromes. You can extend the definition to phrases by removing all spaces and punctuation marks

Read More

Programming Tips

Kathryn McLawhornJune 10, 2022 0

A comparison of the ODS destinations for writing to Microsoft Word

There are several alternatives to writing to a Microsoft Word file when you use the SAS® Output Delivery System (ODS). The RTF, TAGSETS.RTF and TAGSETS.RTF_SAMPLE destinations create an RTF formatted file. The WORD destination, which is still considered preproduction, creates a DOCX formatted file. The destinations provide many of the same functions, although some features are unique to each one. The destination that you choose might vary depending on your desired final output.

Read More

Previous 1 … 8 9 10 11 12 … 65 Next