Tag: tips & techniques

Creating a Microsoft Excel report using SAS, Python and SQL!

The addition of the PYTHON procedure and Python editor in SAS Viya enables users to execute Python code in SAS Studio. This new capability in SAS Viya adds another tool to SAS’s existing collection. With this addition I thought, how can I utilize this new found power? In this example, […]

Creating a Microsoft Excel report using SAS, Python and SQL! was published on SAS Users.

Export a Visual Analytics report using REST APIs

In my previous blog Programmatically export a Visual Analytics report to PDF – SAS Users, I use the SAS Visual Analytics SDK to export a report to PDF, which is quite simple if we have basic knowledge with JavaScript programming. It works for both the latest version of SAS Viya […]

Export a Visual Analytics report using REST APIs was published on SAS Users.

Getting Started with Python Integration to SAS® Viya® – Part 11 – Rename 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 summarize columns. Now it’s time to focus on how to rename columns in CAS tables. Load and explore data […]

Getting Started with Python Integration to SAS® Viya® – Part 11 – Rename Columns was published on SAS Users.

Getting Started with Python Integration to SAS® Viya® – Part 10 – Group and Aggregate CAS Tables

Group and aggregate CAS tables 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 summarize columns. Now it’s time to focus on how to group and aggregate CAS […]

Getting Started with Python Integration to SAS® Viya® – Part 10 – Group and Aggregate CAS Tables was published on SAS Users.

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 […]

Getting Started with Python Integration to SAS® Viya® – Part 9 – Summarize Columns was published on SAS Users.

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 […]

Getting Started with Python Integration to SAS® Viya® – Part 8 – Creating Calculated Columns was published on SAS Users.