Convert PARQUET to SAS7BDAT

Turn PARQUET files into SAS7BDAT. A SAS 9 data set in UTF-8.

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 data set from your Parquet table.One SAS 9 file in UTF-8, with numbers, dates and text mapped to SAS types.

  1. What you get

    A SAS 9 data set in UTF-8. Integers, decimals and doubles become numbers, and true and false become 1 and 0.

    Dates and times become dates and times in UTC. Empty values become missing.

  2. What changes

    Lists, structs, maps and binary values become text, such as [20.1, 40.2]. Whole numbers beyond 2^53 become text so no digit is lost.

    Column names become SAS names of up to 32 Latin letters, digits and underscores. When a name changes, the original is kept as the variable label.

    Dates get the format E8601DA, date-times E8601DT and times E8601TM. In a table with text longer than 2,045 bytes, they keep their SAS values without a format instead.

  3. What gets cut or stops

    Text longer than 32,767 bytes is cut.

    A table without rows fails with unsupported_elements, so the file needs at least one row. For more Parquet tools, see every PARQUET conversion.

PARQUET and SAS7BDAT.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 · SAS7BDAT

SAS Data

SAS datasets.

Extensions
.sas7bdat
MIME type
application/x-sas-data
Kind
Text and data

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

terminal
$ cv convert report.parquet report.sas7bdat
$ cv convert report.parquet report.sas7bdat

Questions.What people ask about PARQUET to SAS7BDAT.

01OF 04

Names are changed to SAS names of up to 32 Latin letters, digits and underscores. A changed name keeps the original as its variable label.

Lists, structs, maps and binary values become text, such as [20.1, 40.2].

The table has no rows. A table without rows stops with unsupported_elements.

Dates get E8601DA, date-times E8601DT and times E8601TM. If the table has text longer than 2,045 bytes, they keep their SAS values without a format.

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