Convert DTA to PARQUET

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

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

A Parquet table from a Stata dataset.One column per variable, with numbers, dates and text kept as stored.

  1. What you get

    One Parquet file with one column per variable. Variable names stay as the column names, and the values stay as stored.

    Byte, int and long variables become integer columns. Float and double variables become doubles. Other numbers also become doubles, and text strings stay text.

  2. Dates and times

    Stata dates, times and periods become dates and times in Parquet. This covers formats such as %td, %tc and %tm.

    Missing numbers are left empty.

  3. What it leaves behind

    Variable labels are dropped. Value labels are dropped too, so coded answers stay numbers and do not turn into their label text.

    The extended missing values .a to .z are also dropped. If you need to go the other way, PARQUET to DTA converts a Parquet file back to Stata.

DTA and PARQUET.What each format is.

The formats

From · DTA

Stata Data

Stata datasets.

Extensions
.dta
MIME type
application/x-stata-dta
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 DTA to PARQUET conversion through the API, for your app or your agent.

terminal
$ cv convert report.dta report.parquet
$ cv convert report.dta report.parquet

Questions.What people ask about DTA to PARQUET.

01OF 04

Yes. The Parquet table has one column per variable, and the variable names are kept.

No. Value labels are dropped, so coded answers stay as numbers.

Stata dates, times and periods such as %td, %tc and %tm become dates and times in the Parquet file.

Missing numbers are left empty. The extended missing values .a to .z are dropped.

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