Data Management

From Unfriendly Text File to SAS Dataset - Reading Character Strings

Date Added: Mar 2010
Format: PDF

What does it take to automatically clean unwieldy text files in SAS9? It takes business necessity and intermediate - to-advanced combinations of SAS9 options, statements, character and date functions, call routines, macros, and OS commands. This paper describes how to automate an otherwise tedious and error-prone process of extracting data from text files with inconsistent structure and format. The data is then used in a real-life project.