Tool that Uses the SAS (registered trademark) PRX Functions to Fix Delimited Text Files.

摘要

Delimited text files are often plagued by appended and/or truncated records. Writing customized SAS (registered trademark) code to import such a text file and break out into fields can be challenging. If only there was a way to "fix" the file before importing it. Enter the file_fixing_tool, a SAS (registered trademark) Enterprise Guide (registered trademark) project that uses the SAS PRX functions to import, fix, and export a delimited text file. This fixed file can then be easily imported and broken out into fields. The file_fixing_tool project was written using SAS Enterprise Guide 5.1 and SAS 9.3 on a Windows 7 Enterprise operating system.