Programming Tips Posts

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Rick WicklinJune 29, 2020 0

The first time I saw a formula for the pooled variance, I was quite confused. It looked like Frankenstein's monster, assembled from bits and pieces of other quantities and brought to life by a madman. However, the pooled variance does not have to be a confusing monstrosity. The verb "to

English

Programming Tips

Ron CodyJune 24, 2020 0

Multi-way lookup tables

A lookup table is a programming technique where one or more values can be used to retrieve another value. For example, many years ago, I had benzene exposure estimates for 10 years (1940 to 1949) for each of five locations in a factory. Given a year and a job location,

English

Analytics | Programming Tips

Rick WicklinJune 24, 2020 0

The Kolmogorov D distribution and exact critical values

If you have ever run a Kolmogorov-Smirnov test for normality, you have encountered the Kolmogorov D statistic. The Kolmogorov D statistic is used to assess whether a random sample was drawn from a specified distribution. Although it is frequently used to test for normality, the statistic is "distribution free" in

English

Programming Tips

Kevin RussellJune 22, 2020 0

Partition your CAS tables to greatly improve performance

Kevin Russell of SAS Technical Support shows you how partitioning CAS tables speeds processing.

English

Data Visualization | Programming Tips

Rick WicklinJune 22, 2020 0

Visualize the structure of a sparse matrix

Sometimes in matrix computations, it is important to display the nonzero elements of a matrix. This can be useful for visualizing the structure of a sparse matrix (one that has many zeros) and it is also useful when describing a matrix algorithm (such as Gaussian elimination) that introduces zeros at

English

Programming Tips

Peter StyliadisJune 19, 2020 0

Getting Started with Python Integration to SAS® Viya® - Part 2 - Working with CAS Actions and CASResults Objects

In the second post of the Getting Started with Python Integration to SAS® Viya® series we will learn about Working with CAS Actions and CASResults Objects. CAS actions are commands sent to the CAS server to run a task, and CASResults objects contain information returned from the CAS server. This

English

Programming Tips

Peter StyliadisJune 19, 2020 0

Getting Started with Python Integration to SAS® Viya® - Index

Index of articles on Getting Started with Python Integration to SAS® Viya®. Part 1 - Making a Connection Part 2 - Working with CAS Actions and CASResults Objects Part 3 - Loading a CAS Action Set Part 4 - Exploring Caslibs Part 5 - Uploading Data into CAS Part 6

English

Programming Tips

Elena ShternJune 17, 2020 0

How to access Federal Reserve Economic Data (FRED) with SASEFRED in SAS/ETS® software

SAS Public Sector's Elena Shtern is your guide as you extract data from the Federal Reserve Economic Data site using the SASEFRED interface engine, part of SAS/ETS® software.

English

Government

Advanced Analytics | Learn SAS | Programming Tips

Architecture of an MPP session in SAS Viya. The client calls an action, which can use multiple nodes and threads.

Rick WicklinJune 17, 2020 0

Write a CAS data table by using the iml action

A previous article shows how to use the iml action to read a CAS data table into an IML matrix. This article shows how to write a CAS table from data in an IML matrix. You can read an overview of the iml action, which was introduced in SAS Viya

English

Advanced Analytics | Learn SAS | Programming Tips

Rick WicklinJune 15, 2020 0

Read a CAS data table by using the iml action

A previous article compares a SAS/IML program that runs in PROC IML to the same program that runs in the iml action. (You can read an overview of the iml action.) The example in the previous article was very simple and did not read or write data. This article compares

English

Programming Tips

Rick WicklinJune 12, 2020 0

Getting started with the iml action in SAS Viya

A previous article provides an introduction and overview of the iml action, which is available in SAS Viya 3.5. The article compares the iml action to PROC IML and states that most PROC IML programs can be modified to run in iml action. This article takes a closer look at

English

Programming Tips

Susan SlaughterJune 11, 2020 0

What's wrong with this code?

Whether you enjoy debugging or hate it, for programmers, debugging is a fact of life. It’s easy to misspell a keyword, scramble your array subscripts, or (heaven forbid!) forget a semicolon. That’s why we include a chapter on debugging in The Little SAS® Book and its companion book, Exercises and

English

Learn SAS | Programming Tips

Rick WicklinJune 10, 2020 0

An introduction to the iml action in SAS Viya

This article introduces the iml action, which is available in SAS Viya 3.5. The iml action supports most of the same syntax and functionality as the SAS/IML matrix language, which is implemented in PROC IML. With minimal changes, most programs that run in PROC IML also run in the iml

English

Learn SAS | Programming Tips | Students & Educators

Joe FurbeeJune 3, 2020 0

How to save Jupyter notebooks in assorted formats

Learning never stops. When SAS had to change this year’s SAS Global Forum (SASGF) to a virtual event, everyone was disappointed. I am, however, super excited about all of the papers and stream of video releases over the last month (and I encourage you to register for the upcoming live

English

Programming Tips

Yinliang WuJune 2, 2020 0

Transform word vector tables from long to wide

In natural language processing, word vectors play a key role in making technologies such as machine translation and speech recognition possible. Let's talk about how to transform word vector tables from long to wide in SAS, so we can potentially get sentence vectors to process further.

English

Programming Tips

Ron CodyMay 29, 2020 0

Using SAS to estimate the link between ozone and asthma (and a neat trick)

While working at the Rutgers Robert Wood Johnson Medical School, I had access to data on over ten million visits to emergency departments in central New Jersey, including ICD-9 (International Classification of Disease – 9th edition) codes along with some patient demographic data. I also had the ozone level from

English

Health Care | Life Sciences

Learn SAS | Programming Tips

Leonid BatkhanMay 27, 2020 0

Multi-purpose macro function for getting information about data sets

SAS' Leonid Batkhan describes programming technique for creating multi-purpose SAS® Macro functions.

English

Programming Tips

Rick WicklinMay 20, 2020 0

Bilinear interpolation in SAS

This article shows how to perform two-dimensional bilinear interpolation in SAS by using a SAS/IML function. It is assumed that you have observed the values of a response variable on a regular grid of locations. A previous article showed how to interpolate inside one rectangular cell. When you have a

English

Learn SAS | Programming Tips

Chris HemedingerMay 19, 2020 0

How to copy files in SAS Enterprise Guide

One of the problems that trips up experienced SAS users when they begin to use SAS Enterprise Guide is a result of simple geography. The SAS Enterprise Guide application runs here, on your desktop. The SAS Workspace session (which accesses data and cranks through your analysis) runs over there, on

English

Data Visualization | Programming Tips

Robert AllisonMay 18, 2020 0

I'm just an ordinary average curve ...

If you're close to my age, you probably remember Joe Walsh's song Ordinary Average Guy. That song popped into my head when I was writing this example about moving averages, so I encourage you to listen to it while reading the blog post. Many people are looking at graphs lately

English

Health Care

Programming Tips

Rick WicklinMay 18, 2020 0

What is bilinear interpolation?

I've previously written about linear interpolation in one dimension. Bilinear interpolation is a method for two-dimensional interpolation on a rectangle. If the value of a function is known at the four corners of a rectangle, an interpolation scheme gives you a way to estimate the function at any point in

English

Programming Tips

Chevell ParkerMay 14, 2020 0

How to Add Sticky Headers with ODS HTML

This blog demonstrates how to modify your ODS HTML code to make your column headers “sticky,” or fixed in position. Using sticky headers is most beneficial when you have long tables on your web page and you want the column headers to stay in view while scrolling through the rest of the page.

English

Analytics | Learn SAS | Programming Tips | Work & Life at SAS

Aubrey BarfieldMay 12, 2020 0

What to expect when you take SAS training: Before, during and after

You’ve chosen the right class, added-to-cart, and hit submit. You’re committed – now what? Once you book a class with us, no matter the format, you can expect an email confirming your request within 24 hours. For instructor-led training courses, a reminder email is sent 3-5 days before the course

English

Analytics | Programming Tips

Rick WicklinMay 11, 2020 0

Cubic spline interpolation in SAS

I recently showed how to use linear interpolation in SAS. Linear interpolation is a common way to interpolate between a set of planar points, but the interpolating function (the interpolant) is not smooth. If you want a smoother interpolant, you can use cubic spline interpolation. This article describes how to

English

Data Visualization | Programming Tips

Debpriya SarkarMay 8, 2020 0

Visualizing COVID-19 data using SGPLOT and SGPANEL

As we continue to process and understand the ongoing effects of the novel coronavirus, many of us have grown used to viewing COVID-19 dashboards and visualizations, including this popular coronavirus dashboard from SAS. If you are more accustomed to building graphs and visualizations using the SGPLOT and SGPANEL procedures, this

English

Learn SAS | Programming Tips

Kathryn McLawhornMay 5, 2020 0

Using STYLE/MERGE and STYLE/REPLACE in PROC REPORT

In this edition of Problem Solvers, SAS Technical Support's Kathryn McLawhorn walks you through two PROC REPORT techniques.

English

Analytics | Programming Tips

Rick WicklinMay 4, 2020 0

Linear interpolation in SAS

SAS programmers sometimes ask about ways to perform one-dimensional linear interpolation in SAS. This article shows three ways to perform linear interpolation in SAS: PROC IML (in SAS/IML software), PROC EXPAND (in SAS/ETS software), and PROC TRANSREG (in SAS/STAT software). Of these, PROC IML Is the simplest to use and

English

Advanced Analytics | Data Visualization | Programming Tips

Xavier BizouxApril 28, 2020 0

Continuous Integration/Continuous Delivery – Using Python and REST APIs for SAS Visual Analytics reports

With increasing interest in Continuous Integration/Continuous Delivery (CI/CD), many SAS Users want to know what can be done for Visual Analytics reports. In this article, I will explain how to use Python and SAS Viya REST APIs to extract a report from a SAS Viya environment and import it into another environment.

English

Analytics | Programming Tips

Rick WicklinApril 27, 2020 0

The circular law for eigenvalues

I've previously written about how to generate points that are uniformly distributed in the unit disk. A seemingly unrelated topic is the distribution of eigenvalues (in the complex plane) of various kinds of random matrices. However, I recently learned that these topics are somewhat related! A mathematical result called the

English

Advanced Analytics | Analytics | Machine Learning | Programming Tips | Students & Educators

Cristiane RodriguesApril 23, 2020 0

9 passos para uma modelagem preditiva eficaz

Modelos de machine learning estão cada dia mais em alta no mercado de trabalho. Mas o que são esses modelos? Por que eles ganharam tanto destaque? Por que todos querem usar? Gosto de dizer que modelos de machine learning são modelos estatísticos acrescidos de poder computacional, e que as empresas

Brazilian Portuguese

1 2 3 … 48 Next

Blogs

Blogs

Programming Tips