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.
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.
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.
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
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 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.
$ cv convert report.parquet report.sas7bdat$ cv convert report.parquet report.sas7bdatQuestions.What people ask about PARQUET to SAS7BDAT.
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.