Statistics
Predicting Choice Probabilities with PROC BCHOICE

Calculation of predicted choice probabilities for new scenarios using a Bayesian logit model.

View code
Statistical
Example 5 for PROC ANOVA

This SAS script performs an analysis of variance for a strip-split plot design to study the effect of soil, fertilize...

View code
Macro
Differential Snapshot of WORK Datasets

Utility macro to identify newly created SAS tables in the WORK library between two steps.

View code
Macro
Macro for Retrieving Table Names

Macro generating a list of all datasets present in a given SAS library via a global macro variable.

View code
Macro
AHGlibpath Macro - Retrieving the Physical Path of a Library

Utility macro to retrieve the system path associated with a given SAS libref.

View code
Macro
AHG Utility Macros for String Manipulation

Definition of three utility macros (AHGstartwith, AHGtestANDcut, AHGmask) for string manipulation and verification. T...

View code
Général
Sans titre

Utility macro that generates and displays IF-THEN-DO instruction blocks in the SAS log for a given variable and list ...

View code
Macro
Left-Right Justified Alignment Macro

Utility macro for aligning text left and right over a defined width.

View code
Test
Test of the _nobs.sas macro

Unit test script to validate the behavior of the '_nobs.sas' macro in various scenarios.

View code
Macro
Macro _NULL: Determining the System's Null Device

This macro provides the null device path (_NULL) adapted to the current operating system (Unix or Windows), allowing ...

View code
Reporting
Opening Dummy HTML Page (_openDummyHTMLPage)

Technical macro opening an ODS HTML4 destination to a temporary file to optimize report generation performance.

View code
Macro
Dataset Option Extraction Macro

Utility macro to isolate and return the 'options' part of a SAS dataset name provided as a string.

View code
Général
Sans titre

This SAS macro, named _PAD, is designed to generate a repeated character string ('pad') to fill a space up to a speci...

View code
Macro
_pdfjam Macro for Merging PDF Files

This SAS macro uses the external utility 'pdfjam' to merge a main PDF file with a series of sequentially numbered PDF...

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
Configuration
Git Authentication Variables Configuration

Initialization of macro variables required for Git repository authentication and connection.

View code
Général
Sans titre

Utility macro for physically deleting SAS datasets, indexes, and catalogs via system (OS) commands.

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
ETL
Sans titre

This SAS script demonstrates the use of the Teradata Parallel Transporter (TPT) option with SAS/ACCESS to bulk load d...

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
Data Quality
PROC DMSRVPROCESSSVC

The DMSRVPROCESSSVC procedure is used to execute processing services on a DataFlux Data Management server. It allows ...

View code
Data Quality
Execute a DataFlux Data Management Studio Service (PROC DMSRVDATASVC)

The DMSRVDATASVC procedure allows you to execute a DataFlux Data Management Studio service on a DataFlux Data Managem...

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
Statistical
Analysis of Nonlinear Mixed Models (NLMIXED) for Binomial Data

This SAS script performs a statistical analysis of binary data using nonlinear mixed models (NLMIXED). It explores tw...

View code
Statistical
Alcohol-Malformation Relationship Analysis

Script analyzing the relationship between alcohol consumption and malformations through internal data creation and a ...

View code
Général
Sans titre

Analysis of the association between maternal alcohol consumption and congenital malformations.

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
ETL
Data Formatting and Payroll Calculation

Script illustrating multi-line data reading, derived variable calculation, and application of display formats.

View code
ETL, Reporting
Creation and Display of City-Weather Data

This SAS script creates two datasets, 'stat.Punjab' and 'stat.Punjab1', from raw data embedded via DATALINES. It defi...

View code
Statistics
Statistical and Graphical Analysis of Biomedical and Epidemiological Data

This SAS script performs a statistical and graphical exploration of two internally created datasets: 'Athelate' (biom...

View code
Reporting
ODS Style Examples Generation

Program generating example HTML files for all ODS styles available in the SAS installation.

View code
Statistics
Elementary Statistical Calculations on Internal Data

Demonstration script manually creating data and performing simple statistical calculations.

View code
Général
Sans titre

This SAS script analyzes teratology data using binomial logistic regression with PROC GENMOD to model the proportion ...

View code
Statistics
Analysis of Overdispersion in Teratology

This SAS script analyzes teratology data to detect and model overdispersion. It uses a DATA step to create the datase...

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

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