Tag: SAS programmers

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.

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.

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.

The ADDROWID data set option maintains the order of your data when executing a DATA step in SAS® Cloud Analytic Services (CAS) 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.