Convert SQLITE to SAS7BDAT

Turn SQLITE files into SAS7BDAT files. A SAS 9 data set in UTF-8.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

One file per table, ready for SAS.Each table with rows becomes its own SAS7BDAT data set. Views are skipped.

  1. What you get

    A SAS 9 data set in UTF-8 for each table, named after the table and written in name order. The conversion can return one or more files.

    Integers and reals become numbers. Columns declared DATE or TIMESTAMP become dates and date-times. NULL becomes missing.

  2. What changes on the way

    Text columns stay text, even when they hold dates. Blobs become escaped text. A table with text stored in a number column is written as text.

    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.

  3. What is left out

    Views are skipped. Tables without rows are left out with a warning, so no file is written for them.

    Text longer than 32,767 bytes is cut.

SQLITE and SAS7BDAT.What each format is.

The formats

From · 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
To · SAS7BDAT

SAS Data

SAS datasets.

Extensions
.sas7bdat
MIME type
application/x-sas-data
Kind
Text and data

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

terminal
$ cv convert report.sqlite report/ --to sas7bdat
$ cv convert report.sqlite report/ --to sas7bdat

Questions.What people ask about SQLITE to SAS7BDAT.

01OF 04

Every table with rows does, named after the table. Tables without rows are left out with a warning, and views are skipped.

It stays text. Only columns declared DATE or TIMESTAMP become dates and date-times.

They become SAS names of up to 32 Latin letters, digits and underscores. The original name is kept as the variable label.

Yes. Text longer than 32,767 bytes is cut.

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