Title: Search and Replace in SAS ® Data Sets thru GUI
Abstract: 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. In addition, the program also allows for various common search features such as 'column selection', ‘work copy’, and ‘print result’. Using the GUI input window, the variables entered by the user will be transferred directly into the macro parameter, without disrupting code internally stored. This program should prove useful by facilitating edits without additional programming; it also presents an interactive way in working with SAS/BASE.
Publication Year: 2007
Publication Date: 2007-01-01
Language: en
Type: article
Access and Citation
AI Researcher Chatbot
Get quick answers to your questions about the article from our AI researcher chatbot