I'm excited to bring a series of posts centered on CAS Actions. The topics in the list below will be covered in posts set to publish in the next few weeks. Please check back often for new releases.
-
- CAS Actions and Action Sets - a brief intro - Introduction to the CAS server and CAS actions
- CAS-Action! fetch CAS, fetch! - Part 1 - Use the fetch action to return rows n rows from a CAS table. Use parameters to sort, subset and create a new column.
- CAS-Action! fetch CAS, fetch! - Part 2 - Visualize the results of the fetch action.
- CAS-Action! Show me the ColumnInfo! - View the column attributes of a CAS table. Take the results and create a CSV file.
- CAS-Action! Simply Distinct - Part 1 - View the number of unique and missing values in each column of a CAS table. Visualize the results.
- CAS-Action! Simply Distinct - Part 2 - Create a calculated column on the results table of the distinct action to find the percentage of distinct values for each column. Export the result table to a CSV file.
- CAS-Action! Executing SQL in SAS Viya - Execute SQL queries on the CAS server using an action.
- CAS-Action! Executing the SAS DATA Step in SAS Viya - Execute most of the traditional SAS DATA step in CAS using an action.
- How to use CASL to develop and work with user-defined CAS actions - Learn to create your own user defined action set.
- Partition your CAS tables to greatly improve performance - One way you can improve performance is by partitioning a table. A partitioned table enables the data to load faster when that data needs to be grouped by the common values of a variable.
- CAS-Action! Filtering Rows in CAS Tables - Learn to filter rows in CAS tables for use in CAS actions.
- CAS-Action! Create Columns in CAS Tables - Part 1- Use the CAS procedure to create columns in CAS tables for use in CAS actions.
- CAS-Action! Create Columns in CAS Tables - Part 2 - Use the computedVars sub-parameter to modify computed column formats, and the SAS LENGTH statement to modified the length of a computed column.
- CAS-Action! Rename CAS Table Columns - Use the CAS language (CASL) to execute the alterTable CAS action to rename a column.
- CAS-Action! Simple Frequency Tables - Part 1 - Generate frequency distributions for one or more columns using the simple.freq CAS action.
- CAS-Action! Saving Frequency Tables - Part 2 - Save the results of the simple.freq action as a SAS data set or a distributed CAS table.
- CAS-Action! Grouping Frequency Tables - Part 3 - Learn how to group the results of the simple.freq CAS action.
- CAS-Action! Advanced Frequency Tables - Part 4 - Generate more advanced one-way frequency and crosstabulation tables.
- Create User Defined Functions (UDFs) for the CAS Server on SAS Viya - Learn how to create UDFs for the CAS cluster.