Convert SAS7BDAT to SQLITE

Turn SAS7BDAT 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 SAS7BDAT files on the dialor turn it to pick what to do

A SQLite database from a SAS dataset.One table named data, with one column per variable.

  1. What you get

    A single SQLite file. It holds one table named data, and each variable in the SAS7BDAT file becomes one column in that table.

    Variable names are kept. Numbers and text are kept as stored, and text becomes strings.

  2. Missing values

    A missing number is left NULL in the table. The cell is empty rather than filled with a stand-in value.

    The conversion lists no options, so there is nothing to set. The result is always one table in one file.

  3. Next steps

    To work with other SQLite files, see every SQLITE conversion. To combine several databases into one, you can merge SQLITE.

SAS7BDAT and SQLITE.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 · 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 SAS7BDAT to SQLITE conversion through the API, for your app or your agent.

terminal
$ cv convert report.sas7bdat report.sqlite
$ cv convert report.sas7bdat report.sqlite

Questions.What people ask about SAS7BDAT to SQLITE.

01OF 04

One. It is named data, and it has one column for each variable in the SAS dataset.

Yes. Each variable name is kept as the name of its column.

They are left NULL in the table.

No. It has no options, and it produces one file.

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