Convert SAS7BDAT to PARQUET

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

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

SAS datasets as a Parquet table.One column per variable, with the values kept as stored.

  1. What you get

    One Parquet file with one column for each variable in the SAS dataset. The variable names carry over as column names.

    Text becomes strings. Numbers and text are kept as stored, so the values in the table are the ones in the SAS file.

  2. Missing values

    Missing numbers are left empty. They do not become zero or any other placeholder, so an empty cell in the Parquet table marks a number that was missing in the SAS dataset.

  3. Where to go next

    The conversion has no options to set. For other targets, see every SAS7BDAT conversion. To combine several Parquet files after converting, you can merge PARQUET.

SAS7BDAT and PARQUET.What each format is.

The formats

From · SAS7BDAT

SAS Data

SAS datasets.

Extensions
.sas7bdat
MIME type
application/x-sas-data
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 SAS7BDAT to PARQUET conversion through the API, for your app or your agent.

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

Questions.What people ask about SAS7BDAT to PARQUET.

01OF 04

One table with one column per variable in the SAS dataset. The conversion produces one file.

Yes. Each variable name becomes the name of its column.

They are left empty in the Parquet table.

No. There are no options for this conversion.

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