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.

  1. 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.

  2. 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.

  3. 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

From · 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
To · XPT

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.

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

Questions.What people ask about PARQUET to XPT.

01OF 04

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.

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