Statistical Power Analysis (GLM and T-test)
Script performing power analyses and sample size calculations. It first prepares a dataset, then uses PROC GLMPOWER f...
Variable Cardinality Analysis: Specific Levels
This script uses the CARDINALITY procedure to analyze the distribution of levels for a numeric or character variable,...
Netezza Data Connector
The Netezza data connector enables SAS Cloud Analytic Services (CAS) to connect to and access data stored in a Netezz...
SAS License Verification
Displays information related to the SAS software license.
Definition of Nested Formats and Validation
Creation of custom formats with logical nesting and display testing.
Folder Creation and Data Copy
This SAS script defines a macro to create a folder on the file system, then uses it to create a specified folder and ...
Load a CSV File from a GZ Archive
This document explains how to use the `table.loadTable` action to load CSV data compressed in GZ (gzip) format into a...
Sans titre
This feature allows loading an existing SAS dataset from the SAS environment into the SAS Viya Cloud Analytic Service...
String Reversal Macro and Variable Tests
SAS script defining a macro to reverse a character string and performing simple tests to display macro variables.
INDEX Function with CHAR and VARCHAR Strings
This script illustrates the use of the INDEX function to find the position of a substring in CHAR and VARCHAR type va...
Index an Existing SASHDAT File
This script explains how to create an index on an existing SASHDAT file directly on disk, without requiring the full ...
Joining Tables from Multiple Caslibs with fedSql.execDirect
This example shows how to join three external tables using the fedSql.execDirect action. It combines a Base SAS datas...
Keeping Variables in a CAS DATA Step
Explains the use of the KEEP statement in a DATA step executed in distributed memory (CAS) to select variables to ret...
List files in a caslib data source
This feature allows listing files present in a data source associated with a CAS caslib, displaying detailed informat...
Sans titre
SAS script performing a one-sided or two-sided Student's t-test on internal data, including the manual calculation of...
Hadoop Data Connector
Allows data transfer between Hive and SAS Cloud Analytic Services (CAS).
Hide a column for most users
This example illustrates how to modify access controls on a specific column of a CAS table to hide it from all users,...
Comparison of IF vs. WHERE filtering in a macro
Script generating test data and executing a macro to repeatedly compare two filtering methods (IF vs WHERE).
Informix Data Connector
This document describes the SAS Cloud Analytic Services (CAS) data connector for Informix, allowing data to be read f...
Random Data Generation and SGPLOT Visualization
Script generating random data to create a custom scatter plot.
Force a Specific Order on a Variable (PROC CARDINALITY)
This SAS script illustrates how to use the CARDINALITY procedure in SAS Viya 4 to analyze variable cardinality and, s...
Descriptive Analysis and Normality Tests on Baseball Data
Descriptive statistical analysis script using the UNIVARIATE procedure to examine the distributions of nRuns and nHit...
Obtain FedSQL Query Execution Details
This example demonstrates how to obtain execution plan details for a FedSQL query submitted to the CAS server, using ...
Greenplum Data Connector
Enables data transfer between a Greenplum database and SAS Cloud Analytic Services (CAS).
The TEXTMINE procedure
The TEXTMINE procedure is used to perform text mining and natural language processing (NLP) tasks on textual data sto...
Creation of the Info Table
Basic script illustrating the creation of a SAS table with a single observation.
Handling Missing Values in Arithmetic Calculations
Illustration of missing value propagation during addition operations in a DATA step.
Handling Missing Values with the SUM Function
Demonstration of using the SUM function to add variables containing missing values.
CAEFFECT Procedure: Estimation by Regression Adjustment
Demonstrates the use of the CAEFFECT procedure for causal effect estimation by regression adjustment, using a pre-adj...
Selecting and Ignoring Parts of Speech and Entities in PROC TEXTMINE
This example illustrates how to use the SAS TEXTMINE procedure to analyze text while ignoring specific parts of speec...
Sans titre
This document describes how to download an ASTORE model from a CAS server to the local file system. This allows model...
Downloading an Astore Store to the Local File System
The ASTORE DOWNLOAD procedure allows downloading an analytical store (ASTORE) model, previously saved in memory on th...
Uploading a Local Analytic Store to CAS
This example demonstrates how to upload an 'analytic store' (astore) from the local file system to an in-memory table...
Rule Extraction for Binary Targets with BOOLRULE
This example demonstrates the use of the BOOLRULE procedure to extract association rules from textual data after prep...
FOREST Procedure (Random Forests)
The FOREST procedure in SAS Viya implements the random forest algorithm for classification and regression tasks. It c...
Scoring New Data with an Existing Forest Model
This script illustrates how to use the FOREST procedure to train a random forest model, save it, and then use it to p...
SVMACHINE Procedure
The SVMACHINE procedure implements Support Vector Machines (SVM) for classification and regression. It is optimized f...
Examples of delimiter management with INPUT and INFILE
Series of examples demonstrating various techniques for reading delimited data in a DATA step: managing CSVs, format ...
Password Protection for Data Tables
Example of creating an encrypted and password-protected SAS table.
Profit Report by Year and Product Line
Generates a report calculating the total profit for each year within each product line.
Report of profits by year and product line
Generates a report displaying the total profit for each year, broken down by product line.
Concatenation of SAS Tables
This script illustrates several techniques for concatenating (appending) data from one SAS table to another.
Understanding the SUM Statement and Accumulation
Example showing three different methods to perform a cumulative sum in a DATA step.
Using Interval Multipliers in Date Functions
Demonstration of using the INTNX function with interval multipliers to calculate future dates based on weeks.
Causal Effect Estimation by Doubly Robust Methods with PROC CAEFFECT
The CAEFFECT procedure estimates causal treatment effects using doubly robust methods, such as Augmented Inverse Prob...
GET Function (Expression Engine Language)
The GET function returns the element at a specified index within an Expression Engine Language (EEL) dynamic array.
Value Match Search and Variable Name Retrieval
This script creates a financial ratings dataset and demonstrates different methods to identify which column (rating a...
Creation of the PAY table with internal data
Creation of a SAS table named PAY from data entered directly into the code via DATALINES.
Designating CAS Superuser
This document describes concepts and methods for designating or managing superuser privileges in SAS Cloud Analytic S...
Defining Conditional Formatting Formats
Creation of user-defined formats for 'traffic lighting' (conditional color highlighting).
