Général
Sans titre

This script lists active CAS sessions and exports the results to a local SAS table.

View code
Administration
View effective access to a table

Analyzes effective (net) access to a table or caslib in SAS Viya using the `accessControl.whatIsEffective` action.

View code
Administration
Simple Row-Level Filtering

This document explains how to define a simple row-level filter to control user access to data in a CAS table.

View code
Statistical
BART Procedure: Storage and Scoring

This documentation explains how to use the BART (Bayesian Additive Regression Trees) procedure to store a trained mod...

View code
Development
Unlock SAS Viya Flexibility: The Pro Way to Generate and Run Dynamic Code on the Fly

The SOURCE statement in PROC CAS allows you to embed text or SAS/CASL code directly into a CASL program and assign it...

View code
Troubleshooting
Troubleshooting CAS LIBNAME Engine Errors

This document addresses common errors encountered when using the CAS LIBNAME engine, specifically the 'The call to Cl...

View code
Data Management
Permanent Formats Provided by SAS

This document explains that SAS provides permanent formats usable with SAS Cloud Analytic Services. For a complete li...

View code
Macro
Using the Macro Facility to Generate CAS DATA Step Code

This article explains how to use the SAS macro facility to dynamically generate SAS DATA Step code that interacts wit...

View code
Machine Learning
Multithreading in Data Mining and Machine Learning Procedures

This document describes the functioning of multithreading within SAS Visual Data Mining and Machine Learning (Viya 8....

View code
ETL
Visualize DATA Step Processing Information with Automatic Variables

This document explains how to use DATA Step automatic variables, especially '_THREADID_', to understand and control d...

View code
Général
Sans titre

This SAS script demonstrates how to execute a DATA step directly within the SAS Cloud Analytic Services (CAS) environ...

View code
ETL
Execute a DATA step in CAS on a CAS table

This document explains how to execute a DATA step in the CAS (Cloud Analytic Services) environment using a CAS table ...

View code
DATA Step
Execute DATA Step in Multi-threads (CAS)

This example demonstrates how to execute a DATA step in multi-threaded mode within a SAS Cloud Analytic Services (CAS...

View code
Général
Sans titre

This example reads a data file into a specified real-time service, and the service's output appears in the indicated ...

View code
Administration
Remove a Direct Access Control

This example explains how to remove a direct access control on a CAS table, allowing access to be inherited or derive...

View code
Général
Sans titre

Enables data transfer between a PostgreSQL database and SAS Cloud Analytic Services (CAS) in the SAS Viya 4 environment.

View code
Statistical
Probit Model for Binary Data with PROC BART

Demonstrates the use of the BART procedure to fit a Probit model on binary data, using an email dataset to classify s...

View code
Data Manipulation
SAS Data Types in CAS

This document describes the data types supported by SAS Cloud Analytic Services (CAS) for table columns, including fi...

View code
Administration
Promote a Format Library

Explains how to make a user-defined SAS format library available to all CAS sessions or promote it for use by other u...

View code
Statistics
Quantile Binning (BINNING Procedure)

This documentation describes and illustrates the use of the BINNING procedure to perform quantile binning in SAS Visu...

View code
Development
Mastering SAS Viya Syntax: How to Use Parameter Coercion for Cleaner CASL Code

Explains the concept of parameter coercion in CASL, a feature that simplifies code writing by allowing the omission o...

View code
Administration
Make a new global CAS library available

This example makes the data in a new global CAS library available to a specific group. To provide read access to CAS ...

View code
Statistical
Variable Cardinality Analysis: Specific Levels

This script uses the CARDINALITY procedure to analyze the distribution of levels for a numeric or character variable,...

View code
Data Access
Netezza Data Connector

The Netezza data connector enables SAS Cloud Analytic Services (CAS) to connect to and access data stored in a Netezz...

View code
ETL
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...

View code
Général
Sans titre

This feature allows loading an existing SAS dataset from the SAS environment into the SAS Viya Cloud Analytic Service...

View code
Data Manipulation
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...

View code
Data Management
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 ...

View code
ETL
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...

View code
Data Manipulation
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...

View code
Administration
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...

View code
Data Access
Hadoop Data Connector

Allows data transfer between Hive and SAS Cloud Analytic Services (CAS).

View code
Administration
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,...

View code
Data Access
Informix Data Connector

This document describes the SAS Cloud Analytic Services (CAS) data connector for Informix, allowing data to be read f...

View code
Statistical
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...

View code
Data Analysis
Obtain FedSQL Query Execution Details

This example demonstrates how to obtain execution plan details for a FedSQL query submitted to the CAS server, using ...

View code
Data Access
Greenplum Data Connector

Enables data transfer between a Greenplum database and SAS Cloud Analytic Services (CAS).

View code
Text Analysis
The TEXTMINE procedure

The TEXTMINE procedure is used to perform text mining and natural language processing (NLP) tasks on textual data sto...

View code
Statistics
CAEFFECT Procedure: Estimation by Regression Adjustment

Demonstrates the use of the CAEFFECT procedure for causal effect estimation by regression adjustment, using a pre-adj...

View code
Natural Language Processing (NLP)
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...

View code
Général
Sans titre

This document describes how to download an ASTORE model from a CAS server to the local file system. This allows model...

View code
Machine Learning
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...

View code
Modeling
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...

View code
Text Analysis, Machine Learning
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...

View code
Machine Learning
FOREST Procedure (Random Forests)

The FOREST procedure in SAS Viya implements the random forest algorithm for classification and regression tasks. It c...

View code
Predictive Modeling
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...

View code
Machine Learning
SVMACHINE Procedure

The SVMACHINE procedure implements Support Vector Machines (SVM) for classification and regression. It is optimized f...

View code
Statistics
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...

View code
Macro
GET Function (Expression Engine Language)

The GET function returns the element at a specified index within an Expression Engine Language (EEL) dynamic array.

View code
Administration
Designating CAS Superuser

This document describes concepts and methods for designating or managing superuser privileges in SAS Cloud Analytic S...

View code

Derniers codes ajoutés

Boost Performance & Security: Creating Composite Indexes and Passwords with PROC DATASETS
This example illustrates the modification of two SAS data sets using the MODIFY statement and its sub-statements. It shows how to: modify SAS files, label a SAS data set, add a read password to a SAS data set, indicate the current sort order of a SAS data set, create an index for a SAS data set, assign informats and formats to variables, rename variables, and label variables in a SAS data set.
ETL
SAS Data Step Efficiency: When to Use Explicit OUTPUT vs. Implicit Rules
Writes the current observation to a SAS dataset.
Data Manipulation CAS
Stop Struggling with Data Ingestion: Efficiently Move CSVs to Memory with PROC CASUTIL
The CASUTIL procedure offers several table and caslib management functions, including displaying table metadata, deleting files, unloading and loading tables, promoting tables, and saving tables.
ETL CAS
Beyond the WORK Library: Mastering the 4 Default SAS Libraries You Must Know
This document describes the default SAS libraries: Work (temporary), User (user), Sashelp, and Sasuser. It explains their role and behavior within the SAS Viya 4 environment.
Data Access
Seamless Integration: How to Attach Data Step Outputs Directly to SAS Viya Jobs
The SAS Viya Platform File Service allows storing, retrieving, and deleting files kept in the SAS Infrastructure Data Server database repository. This repository is not considered a complete 'file system' but contains individual files directly accessible by their file identifier (UUID).
Administration
From SAS 9 to Viya: The Ultimate Guide to Migrating User-Defined Formats to CAS
In the SAS Viya platform, you can store user-defined formats in catalogs for use in a SAS session, or you can store them in a format library on the CAS server. Format libraries are associated with a CAS session, or they can be promoted to global scope to be available to all CAS sessions. User-defined formats in a format library are server-side formats that the server uses when an analysis is performed based on formatted values. You can migrate existing user-defined formats from SAS to the SAS Viya platform.
Tools CAS
Instant Performance Boost: Creating Indexes on the Fly with the INDEX= Data Set Option
Defines one or more indexes for a new output SAS data set.
Général
Stop Bloating Your Datasets: The Definitive Guide to Variable Selection with KEEP
Specifies variables to include in output SAS data sets.
ETL CAS
Combine and Conquer: Mixing Physical Paths and Existing Librefs in One LIBNAME Statement
Explains the concept of SAS library concatenation, allowing several libraries to be logically grouped under a single reference (libref).
Data Access
Stop Importing, Start Connecting: A Master Class in SAS/ACCESS Engines and SQL Pass-Through
This document provides examples of using SAS engines to access and process various types of external data, including delimited files, Excel files, databases (DBMS), XML, and JSON.
Data Access