DM07
Data Verification and Consolidation of Files with Dynamic Code Generation using SAS Macro, Data Step Programming, and System Utilities
Invited
William Pierce
Standard Technology, Inc.
Abstract:
This paper describes a process that can be used to verify and consolidate data contained in external non-SAS data sets and shows how SAS can be combined with system utilities to provide an integrated data management tool. The environment used to demonstrat
e the process centers around the scenario where a large number of data files, often numbering in the hundreds, must be checked for data errors and the data from all files consolidated into a single master SAS data set. The solution examined in this paper u
ses system utilities to dynamically generate a data set list which is passed as input to a SAS program and used to build the JCL and SAS statements to create a batch job stream to process the files. The core processing is accomplished by SAS Macro using co
de streams constructed in DATA steps. Although the specific examples are based on an IBM OS/390 mainframe environment, the concepts can easily be adapted for any platform.
Biography:
Bill Pierce has worked in the computer industry for 20 years. His career began with IBM where he worked in the areas of integrated circuit manufacturing, programming, and systems engineering. He currently is a senior systems analyst with Standard Technolog
y, Inc. where he supports Department of Defense contracts. He also holds the rank of Assistant Professor of Computer Science at Hood College where he teaches courses in computer architecture and operating systems.