Data Management

From Unfriendly Text File to SAS Dataset - Reading Character Strings

Download Now Free registration required

Executive Summary

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.

  • Format: PDF
  • Size: 626.5 KB