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

Abstract

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.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Jul 07, 2015
Accession Number
ADA623689

Entities

People

  • Paul Genovesi

Organizations

  • United States Air Force School of Aerospace Medicine

Tags

Communities of Interest

  • Materials and Manufacturing Processes

DTIC Thesaurus Topics

  • Aerospace Medicine
  • Air Force
  • Computer Programming
  • Computer Programs
  • Department Of Defense
  • Directories
  • Information Operations
  • Language
  • Macroprogramming
  • Military Medicine
  • Operating Systems
  • Personality
  • Programming Languages
  • Separators
  • Social Security
  • Spreadsheet Software
  • Trademarks

Readers

  • Database Systems and Applications
  • Geochemistry