SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Peter StyliadisAugust 10, 2023 0

Python Integration to SAS® Viya® - Part 20 - Remove Duplicate Rows

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In this post I'll discuss how to remove duplicate rows from a distributed CAS table using the both the Pandas API in the SWAT package and the native CAS action. The Pandas API drop_duplicates method was

English

Programming Tips

Leonid BatkhanMay 30, 2023 22

Embedding any code anywhere into SAS programs

SAS expert Leonid Batkhan presents the %embed macro function as a way to embed both “foreign” and SAS native code from a file into a SAS program, preventing clutter in your code.

English

Programming Tips

Peter StyliadisMay 30, 2023 0

Getting Started with Python Integration to SAS® Viya® - Part 19 - Load Multiple CSV Files

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In this post I'll discuss how to load multiple CSV files into memory as a single table using the loadTable action. Load and prepare data on the CAS server To start, we need to create multiple

English

Programming Tips

George BeeversMay 4, 2023 2

Debunking the myth that SAS code doesn't work in Viya: One billion lines later and the results are...

The SAS 9 Content Assessment is a collection of applications that are designed to help users understand the various characteristics of their deployment. SAS Content Assessment delivers information that is critical to helping you to upgrade to the latest version of SAS (Viya).

English

Learn SAS | Programming Tips

Lee Ann DietzApril 21, 2023 2

Public Health Transformation: Ways to use SAS Viya

We demonstrate a few common and essential public health functions using SAS Viya. Our goal is to show the art of the possible within the realm of accessibility.

English

Programming Tips

Peter StyliadisApril 19, 2023 0

Getting Started with Python Integration to SAS® Viya® - Part 18 - Update rows in a table

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In this post I'll discuss how to update rows in a distributed CAS table. Load and prepare data in the CAS server I created a script to load and prepare data in the CAS server. This

English

Programming Tips

Kathryn McLawhornApril 18, 2023 0

Adding dynamic counts in headings in the PROC REPORT output

SAS' Kathryn McLawhorn reveals an elegant option to introduce dynamic header data using DATA step logic and the FORMAT procedure.

English

Programming Tips

Peter StyliadisApril 6, 2023 0

Getting Started with Python Integration to SAS® Viya® - Part 17 - Saving CAS tables

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In this post I'll discuss saving CAS tables to a caslib's data source as a file. This is similar to saving pandas DataFrames using to_ methods. Load and preview the CAS table First, I imported the

English

Data Management | Programming Tips

Melodie RushApril 5, 2023 0

Getting Started with Python Integration to SAS Viya for Predictive Modeling - Working with Dates

In part 1 of this series, we examined our data before building any models. Among the discoveries was a column that seemed to contain a SAS date value. Here, we will discuss what exactly is meant by a 'SAS date', how to format it correctly, and how to create a

English

Programming Tips

Peter StyliadisApril 3, 2023 0

Getting Started with Python Integration to SAS® Viya® - Part 16 - Execute SQL

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In this post I'll discuss how to execute SQL with the Python SWAT package in the distributed CAS server. Prepare and load data to the CAS server I created a Python function named createDemoData to prepare

English

Blogs

Blogs

Programming Tips