SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

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

English

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.

English

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

English

Learn SAS | Programming Tips | Students & Educators

Suzanne MorgenAugust 1, 2022 2

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

English

Programming Tips

Ursula PoloJuly 27, 2022 2

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

English

Programming Tips

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

English

Programming Tips

Dr. Christian FG SchenderaJuly 12, 2022 6

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

English

Data Management | Learn SAS | Programming Tips

Leonid BatkhanJuly 7, 2022 7

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.

English

Programming Tips

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

English

Learn SAS | Programming Tips

Leonid BatkhanJune 16, 2022 24

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.

English

Blogs

Blogs

Programming Tips