Data Manipulation

CODE SAS

Examples: WHERE Statement Processing

This document provides examples illustrating the use of the WHERE clause to conditionally select ...

CODE SAS

Examples: Data Update

This document presents examples of using the UPDATE statement in SAS to modify a master dataset f...

CODE SAS

Examples: Processing BY Groups with FIRST. and LAST. DATA Step Variables

This document explains and demonstrates the use of automatic FIRST. and LAST. variables in the SA...

CODE SAS

Examples: Processing BY Groups in the DATA Step

This document provides examples illustrating how to process BY groups (BY-Groups) in a SAS DATA s...

CODE SAS

Examples: Match-Merge Data

This document provides examples of match-merging SAS datasets using the MERGE and BY statements i...

CODE SAS

Examples: One-to-One Data Merging

This document presents examples of using the MERGE statement without the BY statement to perform ...

CODE SAS

Examples: Controlling variables and observations in datasets

This document provides SAS code examples for controlling variables and observations when manipula...

CODE SAS

Example: PROC CASUTIL

This example uses three PROC CASUTIL statements to load, partition, and modify a data table in th...

CODE SAS

Example: Data Set Options

This example shows how to use the FIRSTOBS= and OBS= data set options with the WHERE statement to...

CODE SAS

Merging Data with a Hash Table

This example illustrates the use of a hash table to merge two SAS datasets (one-to-many or many-t...

CODE SAS

SAS Dataset Definitions

A SAS dataset is a collection of tabular data in a SAS file format, containing both data and meta...

CODE SAS

Executing DATA Step in Single-Threaded Mode

This document explains how to execute a SAS DATA step program in single-threaded mode within a CA...

CODE SAS

Group Variables in Descending Order Using the DATA Step BY Statement

This document explains how to group variables in descending order using the DATA Step BY statemen...

CODE SAS

Examples: Prepare Data

This document contains detailed examples on preparing and manipulating SAS data before combining ...

CODE SAS

Examples: Processing BY Groups in the DATA Step

This document presents practical examples on how to group and process data observations using the...

CODE SAS

Examples: Interleaving Data

This document provides examples illustrating how to interleave SAS datasets using the SORT proced...

CODE SAS

Examples: Controlling Variables and Observations in Data Sets

This document provides practical examples on how to control which variables and observations are ...

CODE SAS

Examples: DO Loops

This document provides examples of using DO loops in SAS, including simple iterative, nested, wit...

CODE SAS

Example: PROC CASUTIL

This example uses three PROC CASUTIL statements to load, partition, and modify a CAS table. It de...

CODE SAS

Example: Merge Data Using a Hash Table

This example illustrates the use of a hash table to merge two datasets sharing a common variable....

CODE SAS

Example: Modifying Data

This example illustrates how to modify a master dataset by adding or updating observations from a...

CODE SAS

DROP Statement

Excludes variables from output SAS datasets.

CODE SAS

Generating Current Temporal Variables

This script creates a table containing the current system date, time, and datetime.

CODE SAS

SAS Data Types in CAS

This document describes the data types supported by SAS Cloud Analytic Services (CAS) for table c...

CODE SAS

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...

CODE SAS

Keeping Variables in a CAS DATA Step

Explains the use of the KEEP statement in a DATA step executed in distributed memory (CAS) to sel...

CODE SAS

Handling Missing Values with the SUM Function

Demonstration of using the SUM function to add variables containing missing values.

CODE SAS

Using Interval Multipliers in Date Functions

Demonstration of using the INTNX function with interval multipliers to calculate future dates bas...

CODE SAS

Value Match Search and Variable Name Retrieval

This script creates a financial ratings dataset and demonstrates different methods to identify wh...

CODE SAS

Demonstration of String Length Functions

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

CODE SAS

Using the CEIL and FLOOR mathematical functions

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

CODE SAS

Removing left spaces with the LEFT function

Script illustrating the use of the LEFT function to remove leading spaces from a character string.

CODE SAS

Using the MEAN function

Simple example showing how to calculate the mean of variables in a DATA step.

CODE SAS

Using COUNT and COUNTC functions

This SAS script demonstrates the use of COUNTC and COUNT functions to count character and substri...

CODE SAS

Demonstration of the CHOOSEC function

Simple example of using the CHOOSEC function in a DATA _null_ step.

CODE SAS

CATX() Function Demonstration

This SAS script demonstrates the use of the CATX() function for variable concatenation, specifica...

CODE SAS

Monetary Data Formatting

Script for creating a cost table and applying a monetary format.

CODE SAS

Using SAS Numeric Functions

This SAS script demonstrates the use of several built-in numeric functions (CEIL, FLOOR, INT, ROU...

CODE SAS

Substring Extraction

This SAS script demonstrates the use of the SUBSTR function to extract a substring from a text va...

CODE SAS

Using the ZIPCITY function

Script demonstrating the use of the ZIPCITY function to get a city name from a postal code.

CODE SAS

Date Manipulation with INTNX

Script illustrating the use of the INTNX function to calculate future dates based on regional con...

CODE SAS

Creation and Sorting of the CLASSTEST Table

Creation of a 'classtest' dataset via internal data, followed by sorting by name and subject.

CODE SAS

Demonstration of Adding SAS Data Sets

This SAS script demonstrates the use of the PROC APPEND procedure to add observations from one SA...