SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Peter StyliadisMarch 21, 2023 1

Getting Started with Python Integration to SAS® Viya® - Part 15 - Count Missing Values in a CAS Table

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In this post I'll discuss how to count missing values in a CAS table using the Python SWAT package. Load and prepare data First, I connect my Python client to the distributed CAS server and named

English

Data Management | Programming Tips

Melodie RushMarch 20, 2023 0

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

Welcome to my series on getting started with Python integration to SAS Viya for predictive modeling. Exploring Data - Learn how to explore the data before fitting a model Working with Dates - Learn how to format a SAS Date and calculate a new column Imputing Missing Values - Learn

English

Data Management | Programming Tips

Melodie RushMarch 20, 2023 0

Getting Started with Python Integration to SAS Viya for Predictive Modeling - Exploring Data

Welcome to the first post in my series Getting Started with Python Integration to SAS Viya for Predictive Modeling. I'm going to dive right into the content assuming you have minimal knowledge on SAS Cloud Analytic Services (CAS), CAS Actions and Python. For some background on these subjects, refer to

English

Programming Tips

Ron CodyFebruary 22, 2023 3

DATA Step or PROC? It depends...

Which SAS technique should you use? Consider how often the program is to be run, your comfort level and more.

English

Programming Tips

Peter StyliadisFebruary 13, 2023 0

Getting Started with Python Integration to SAS® Viya® - Part 14 - CAS Table to DataFrame

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In this post I'll discuss how to bring a distributed CAS table back to your Python client as a DataFrame. In this example, I'm using Python on my laptop (Python client) to connect to the

English

Programming Tips | SAS Administrators

Joe FurbeeFebruary 7, 2023 69

Authentication to SAS Viya: a couple of approaches

In my blog series regarding SAS REST APIs (you can read all of my posts on this topic here) I outlined how to integrate SAS analytical capabilities into applications. I detailed how to construct REST calls, build body parameters and interpret the responses. I've not yet covered authentication for the

English

Analytics | Programming Tips

Peter StyliadisFebruary 7, 2023 2

Getting started with Python integration to SAS® Viya® - Part 13 - Loading a Client-Side CSV File into CAS

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 your data is organized on the CAS server. In this post I'll discuss loading client-side CSV files into

English

Analytics | Programming Tips

Peter StyliadisJanuary 17, 2023 0

Getting started with Python integration to SAS® Viya® - Part 12 - Count of Unique Values

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, working with CAS actions and CASResults objects, and how to summarize columns. Now it's time to focus on how to get the count of unique values

English

Programming Tips | SAS Administrators

Leonid BatkhanJanuary 11, 2023 10

Automatic cloning of SAS metadata user groups and roles

SAS expert Leonid Batkhan demonstrates how to automatically replicate/clone metadata users’ groups and roles from one user to another.

English

Programming Tips

Ron CodyJanuary 10, 2023 1

Understanding the _TYPE_ variable in output data sets

When you use PROC MEANS or PROC SUMMARY to create a summary data set and include a CLASS statement, SAS includes two variables, _FREQ_ and _TYPE_, in the output data set. This blog shows you two ways to interpret and use _TYPE_ using the data set Shoes in the SASHELP

English

Blogs

Blogs

Programming Tips