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.
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.
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.
Missing values
Missing numbers are left empty. The cell has no value in the column.
Going back
To turn a Parquet table into SAS Transport again, use PARQUET to XPT.
XPT and PARQUET.What each format is.
The formats
SAS Transport
SAS transport files, the exchange format regulators accept.
- Extensions
- .xpt
- MIME type
- application
/x -sas -xport - Kind
- Text and data
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.
$ cv convert report.xpt report.parquet$ cv convert report.xpt report.parquetQuestions.What people ask about XPT to PARQUET.
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.