Convert DTA to SQLITE

Turn DTA files into SQLITE. A SQLite database with one table named data and 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 Stata dataset as a SQLite table.One table named data, with one column per variable.

  1. What you get

    A SQLite database in one file. It holds a single table named data, and each variable in the DTA file becomes a column. Variable names, numbers and text are kept as stored.

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

  2. Dates and times

    Stata dates, times and periods, such as %td, %tc and %tm, become dates and times in the database. They are stored as text, for example 2024-02-03 for a date and 2024-02-03 09:15:00 for a date with a time.

  3. What it leaves behind

    Variable labels and value labels are dropped. A coded answer stays a number, so you need your own list of codes to read it.

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

    To go the other way, use SQLITE to DTA.

DTA and SQLITE.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 · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data

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

terminal
$ cv convert report.dta report.sqlite
$ cv convert report.dta report.sqlite

Questions.What people ask about DTA to SQLITE.

01OF 04

One, named data. Each variable in the DTA file is a column in it.

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

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

As text. A date looks like 2024-02-03, and a date with a time looks like 2024-02-03 09:15:00.

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