Examples: Data Update

This document presents examples of using the UPDATE statement in SAS to modify a master dataset from the values of a transaction dataset. Examples cover basic updating, handling duplicate values for the BY variable, and the impact of missing and d...

View this code now

Codes in same category

Examples: WHERE Statement Processing

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

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

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

Examples: Processing BY Groups in the DATA Step

This document provides examples illustrating how to process BY groups (BY-Gro...

Examples: Match-Merge Data

This document provides examples of match-merging SAS datasets using the MERGE...

Examples: One-to-One Data Merging

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

Examples: Controlling variables and observations in datasets

This document provides SAS code examples for controlling variables and observ...

Example: PROC CASUTIL

This example uses three PROC CASUTIL statements to load, partition, and modif...

Example: Data Set Options

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

Merging Data with a Hash Table

This example illustrates the use of a hash table to merge two SAS datasets (o...

SAS Dataset Definitions

A SAS dataset is a collection of tabular data in a SAS file format, containin...

Executing DATA Step in Single-Threaded Mode

This document explains how to execute a SAS DATA step program in single-threa...

Group Variables in Descending Order Using the DATA Step BY Statement

This document explains how to group variables in descending order using the D...

Data Manipulation