xport 0.3.0

SAS XPORT file reader

Python reader for SAS XPORT data transport files (*.xpt).

What’s it for?

XPORT is the binary file format used by a bunch of United States government agencies for publishing data sets. It made a lot of sense if you were trying to read data files on your IBM mainframe back in 1988.

The official SAS specification for XPORT is relatively straightforward. The hardest part is converting IBM-format floating point to IEEE-format, which the specification explains in detail.

How do I use it?

This module mimics the csv module of the standard library:

import xport
with open('example.xpt', 'rb') as f:
    for row in xport.reader(f):
        print row

Each row will be a namedtuple, with an attribute for each field in the dataset. Values in the row will be either a unicode string or a float, as specified by the XPT file metadata. Note that since XPT files are in an unusual binary format, you should open them using mode 'rb'.

You can also use the xport module as a command-line tool to convert an XPT file to CSV (comma-separated values).:

$ python -m xport example.xpt > example.csv

The reader object also has a handful of metadata:

• reader.fields – Names of the fields in each observation.

• reader.version – SAS version number used to create the XPT file.

• reader.os – Operating system used to create the XPT file.

• reader.created – Date and time that the XPT file was created.

• reader.modified – Date and time that the XPT file was last modified.

Random access to records

If you want to access specific records, you should either consume the reader in a list (lst = list(xport.reader(f)))) or use one of itertools recipes for quickly consuming and throwing away unncessary elements.

Recent changes

• Improved the API.

• Fixed handling of NaNs.

• Fixed piping the file from stdin in Python 3.

Authors

Jack Cushman wrote the original verision in 2012. Michael Selik re-wrote this current version from scratch to simplify the code, to fix a few bugs, and to more closely mimic the standard library csv module.