Data Management
Picture Formats and Date Directives

Demonstration of creating and using custom picture formats for dates and times using directives.

View code
Statistical
Paired T-Test on CAFFIENE data

Execution of a T-test for paired samples to compare baseline and caffeine measurements.

View code
Reporting
Advanced Customization of Graphic Legends with PROC SGPLOT

Demonstration of legend customization capabilities in SAS graphics, including symbol dimension management and Unicode...

View code
Statistical
Cutpoint Binning

The BINNING procedure with the CUTPTS method allows grouping continuous values of one or more variables into discrete...

View code
ETL
Detailed Journey of a DATA Step Program

This document describes in detail the steps to execute a DATA Step program in the Cloud Analytic Services (CAS) envir...

View code
Administration
Text Search by Unix System Command

Utility script to search for character strings in server files via Unix system commands.

View code
Data Quality
PROC DATAMETRICS: Advanced Data Quality Analysis

This script illustrates the advanced use of the PROC DATAMETRICS procedure to generate data quality metrics, utilizin...

View code
Data Quality
PROC DATAMETRICS: Advanced Data Quality Analysis

This script illustrates the advanced use of the PROC DATAMETRICS procedure to generate data quality metrics, leveragi...

View code
Data Quality
PROC DATAMETRICS: Advanced Data Quality Analysis

This script illustrates the advanced use of the PROC DATAMETRICS procedure to generate data quality metrics, leveragi...

View code
ETL
Amazon Redshift Data Connector

This connector enables the transfer of data between an Amazon Redshift database and SAS Cloud Analytic Services (CAS)...

View code
ETL
Amazon Redshift Data Connector

This connector allows data transfer between an Amazon Redshift database and SAS Cloud Analytic Services (CAS). It sup...

View code
ETL
Amazon Redshift Data Connector

This connector allows data transfer between an Amazon Redshift database and SAS Cloud Analytic Services (CAS). It sup...

View code
Graph
Annotated Statistical Visualization with PROC GPLOT

Calculation of descriptive statistics by group and generation of a custom graph via the annotation mechanism to visua...

View code
ETL
Displaying SASHELP Data and Local Creation

Demonstration script displaying a system table and creating a custom table.

View code
Reporting
Creating a Composite Graph Panel with GTL

Generation of a complex graphical dashboard combining scatter plot, bar chart, and box plots using the Graphics Templ...

View code
Statistical
Beyond PROC PRINT: How to Audit Data Quality and Spot Inconsistencies in SAS

This SAS script demonstrates common data exploration and validation techniques using base SAS procedures (PRINT, MEAN...

View code
Statistics
Student's t-test on simulated data

Generation of random data and execution of a Student's t-test to compare two groups.

View code
Data Manipulation
Demonstration of String Length Functions

Example of using SAS functions to determine the length of character strings.

View code
ETL
Example of table merging by identifier

Script illustrating the creation of manual data and their merging via a Data Step.

View code
Statistical
Exam Score Correlation Analysis

Creation of an exam response dataset, calculation of total score, and analysis of correlation between questions and t...

View code
Statistical
Dose-Response Linear Regression Analysis

Statistical analysis exploring the relationship between drug dosage and blood pressure.

View code
Statistical
Creating Frequency Charts with PROC FREQ

This program uses the PROC FREQ procedure to generate different types of frequency charts (bar charts) for univariate...

View code
Data Manipulation
Using the CEIL and FLOOR mathematical functions

Script demonstrating the CEIL and FLOOR rounding functions on numerical data.

View code
ETL
Dataset Creation with Datalines and Display

This script creates a SAS dataset from inline data and displays the result.

View code
ETL
Creating and Displaying the prob12_8 Table

Script generating a SAS dataset from embedded data (datalines) and displaying the result.

View code
ETL
Restructuring SAS Tables (Wide to Long and vice versa)

Demonstration of restructuring SAS datasets: converting a 'wide' format (multiple columns per subject) to a 'long' fo...

View code
ETL
Fahrenheit to Celsius Temperature Conversion

Temperature conversion script using arrays and an iterative loop.

View code
ETL
Time Unit Conversion using Arrays and Loops

Data transformation script converting numerical values through iterative processing on grouped variables.

View code
Général
Sans titre

SAS script to read, clean, and convert weight data with varied units (kg, lbs) into a standardized unit (lbs).

View code
Général
Sans titre

Separates data into valid and invalid sets by checking for the presence of non-alphanumeric characters.

View code
Language Fundamentals
Demonstration of DO Loops and Iterative Processing

Educational script illustrating various ways to use DO loops and the OUTPUT statement in the DATA step.

View code
Général
Sans titre

This script performs a survival analysis on data from laryngeal cancer patients. It prepares the data, fits Cox propo...

View code
Statistical
Descriptive Analysis of Numerical Variables

Descriptive analysis of a numerical variable (`lskew`) using PROC UNIVARIATE, including the creation of an internal d...

View code
ETL
Bonus Calculation and New Salary by Classification

Script for creating a salary table including a conditional bonus calculation based on the employee's class.

View code
Algorithmic
Solution to the 100 Doors Problem

Algorithmic simulation of the 100 Doors problem using a SAS Data Step.

View code
ETL
Bulk Loading Data to Snowflake via SAS/ACCESS

This SAS script demonstrates the use of SAS/ACCESS bulk loading functionality to transfer data from a temporary SAS d...

View code
ETL
Bulk Data Loading

This SAS script illustrates bulk data loading to an external database via SAS/ACCESS, using the PROC SQL BULKLOAD met...

View code
ETL
Bulk Load Example (BULKLOAD)

This SAS script demonstrates the use of the BULKLOAD option to load data into an external database table via SAS/ACCE...

View code
ETL
Bulkload - SAS/ACCESS Greenplum Example

This SAS script demonstrates two methods for bulk loading data into a Greenplum database via SAS/ACCESS. It includes ...

View code
ETL
Bulk Data Loading (Bulkload)

This SAS script demonstrates two methods for bulk loading data to an external database (potentially HAWQ as indicated...

View code
ETL
PROC SQL vs. Data Step: Mastering High-Performance Bulk Loads in SAS

This SAS script demonstrates two methods for bulk loading data into an external relational database (potentially Impa...

View code
ETL
Bulk Load via ODBC to SQL Server

Example of bulk loading data to a SQL Server database via ODBC.

View code
ETL
Bulk Load Programs Example

This SAS script demonstrates bulk loading data from an internally created SAS dataset to an external database table v...

View code
Data Loading
Example of Bulk Load (BULKLOAD) to Oracle

This SAS script illustrates the use of the BULKLOAD option in a DATA step to efficiently load data into an Oracle dat...

View code
Statistical
Bucket Binning and Weight of Evidence Calculation

This feature of the BINNING procedure allows grouping continuous or categorical variables into categories (bins) and ...

View code
Administration
DMS Tasks and Logs Cleanup

This functionality allows generating a report on DataFlux Data Management Server tasks, then using this report to sto...

View code
ETL
Bulkload Example

This SAS script illustrates a bulkload example of data to a DBMS table using SAS/ACCESS. It first creates an in-memor...

View code
Data Quality
Basic Usage of PROC DATAMETRICS

The DATAMETRICS procedure calculates a set of data quality metrics for variables in a SAS table. These metrics can in...

View code
Statistical
CARDINALITY Procedure: Variable with User-Defined Format

This example illustrates how the SAS Viya CARDINALITY procedure handles variables with user-defined formats. It demon...

View code
Data Quality
PROC DATAMETRICS: Advanced Data Quality Analysis

This script illustrates the advanced use of the PROC DATAMETRICS procedure to generate data quality metrics, leveragi...

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