Convert PARQUET to XPT
Turn PARQUET files into XPT. A SAS transport file of version 5, the kind SAS and the FDA read.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop PARQUET files on the dialor turn it to pick what to do
A SAS Transport file from your Parquet data.Typed columns become numbers, dates and text in one XPT file.
What you get
One XPT file that holds the table from your Parquet file. Integers, decimals and doubles become numbers. True and false become 1 and 0. Empty values become missing.
Dates and times become dates and times in UTC. Dates use the DATE9. format, date-times use DATETIME20. and times use TIME8.
Values that become text
Lists, structs, maps and binary values become text, such as [20.1, 40.2]. Whole numbers beyond 2^53 also become text, so no digit is lost.
Text longer than 200 bytes is cut.
Column names
Column names are cut to 8 letters, digits and underscores. When a name changes, it keeps up to 40 characters of the original as its label.
To go the other way, use XPT to PARQUET.
PARQUET and XPT.What each format is.
The formats
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
SAS Transport
SAS transport files, the exchange format regulators accept.
- Extensions
- .xpt
- MIME type
- application
/x -sas -xport - Kind
- Text and data
In your code.The same PARQUET to XPT conversion through the API, for your app or your agent.
$ cv convert report.parquet report.xpt$ cv convert report.parquet report.xptQuestions.What people ask about PARQUET to XPT.
They become 1 and 0.
Whole numbers beyond 2^53 become text, so no digit is lost.
Names are cut to 8 letters, digits and underscores. A changed name keeps up to 40 characters of the original as its label.
Text longer than 200 bytes is cut.