White Papers

Search and Replace in SAS Data Sets Thru GUI

Overview In managing data with SAS/BASE software, performing a search and replace is not a straight forward task (unlike when working within a word processor or spreadsheet program). Because time and productivity are valuable, a utility to search and replace data values would enable users to easily make repetitive modifications while working with SAS data sets. This paper introduces a SAS program written in SAS/BASE, with a simple search and replace function through the use of a Graphical User Interface (GUI) in the SAS Display Manager environment. This program presents an intuitive way of searching through the contents of a SAS data set for specific character or numeric string patterns, with the option of replacing one string with another.

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
SAS Institute
File Format
PDF
Date Published
Dec 24, 2008
Format
White Papers
Topics
GUI, Knowledge and Data Management, Programming Languages

SAS Institute White Papers

A Clever Demonstration of the SAS SUBSTR Function

A Clever Demonstration of the SAS SUBSTR Function

The SAS SUBSTR function differs from the substring function in other programming languages as it can be used on either s

Publisher: SAS Institute

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

The explosion of customer data in the last twenty years has increased the need for data mining aimed at Customer Relatio

Publisher: SAS Institute  |  Tags: crm, customer service, data, data mining

An Animated Guide: Proc Transpose

An Animated Guide: Proc Transpose

If one can think about a SAS data set as being made up of columns and rows, one can say Proc Transpose "Flips" the colum

Publisher: SAS Institute  |  Tags: data

Cool New Features in SAS Enterprise Miner 5.3

Cool New Features in SAS Enterprise Miner 5.3

SAS released Enterprise Miner 5.3 in late 2007 with a veritable plethora of cool new features for data miners everywhere

Publisher: SAS Institute  |  Tags: data, software

An Introduction to SAS Character Functions

An Introduction to SAS Character Functions

SAS software is especially rich in its assortment of functions that deal with character data. This class of functions is

Publisher: SAS Institute  |  Tags: data, software