Convert XPT to PARQUET

Turn XPT files into PARQUET. A Parquet table with one column per variable.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop XPT files on the dialor turn it to pick what to do

SAS Transport data as a Parquet table.One column per variable, with dates and times typed as such.

  1. What you get

    One Parquet file with one column per variable in the XPT file. Variable names, numbers and text are kept as stored.

    Numeric variables without a format become integer columns when every value is whole. Other numbers become doubles, and text becomes strings.

  2. Dates and times

    SAS formats such as DATE9., TIME8. and DATETIME20. become dates and times in the Parquet file. The column holds a date or time value, not the raw SAS number.

  3. Missing values

    Missing numbers are left empty. The cell has no value in the column.

  4. Going back

    To turn a Parquet table into SAS Transport again, use PARQUET to XPT.

XPT and PARQUET.What each format is.

The formats

From · XPT

SAS Transport

SAS transport files, the exchange format regulators accept.

Extensions
.xpt
MIME type
application/x-sas-xport
Kind
Text and data
To · PARQUET

Parquet

The columnar data format of analytics. Compressed, typed and fast to scan.

Extensions
.parquet .pq
MIME type
application/vnd.apache.parquet
Kind
Text and data

In your code.The same XPT to PARQUET conversion through the API, for your app or your agent.

terminal
$ cv convert report.xpt report.parquet
$ cv convert report.xpt report.parquet

Questions.What people ask about XPT to PARQUET.

01OF 04

Yes. The Parquet table has one column per variable, and the variable names are kept as stored.

When the variable has no format and every value is whole. Other numbers become doubles.

Formats such as DATE9., TIME8. and DATETIME20. become dates and times in the Parquet file.

They are left empty in the Parquet table.

More conversions.Other ways in and out of XPT and PARQUET.