Convert SQLITE to XPT

Turn SQLITE files into XPT files. A SAS transport file of version 5, the kind SAS and the FDA read.

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 Transport.Each table in the database becomes its own XPT file, named after the table.

  1. What you get

    One XPT file for every table, named after it and written in name order. Views are skipped, so only real tables produce files.

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

  2. What changes on the way

    Text columns stay text, even when they hold dates. Only columns declared DATE or TIMESTAMP become dates. Blobs become escaped text.

    A table with text stored in a number column is written as text.

    Column names are cut to 8 letters, digits and underscores. When a name changes, up to 40 characters of the original are kept as its label.

    Dates are written as DATE9., date-times as DATETIME20. and times as TIME8. Text longer than 200 bytes is cut.

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

SAS Transport

SAS transport files, the exchange format regulators accept.

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

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

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

Questions.What people ask about SQLITE to XPT.

01OF 04

Yes. Each table is written to one XPT file named after it, in name order. Views are skipped.

They are cut to 8 letters, digits and underscores. If the name changes, up to 40 characters of the original stay as the column label.

No. Text columns stay text. Only columns declared DATE or TIMESTAMP become dates and date-times.

No. Text longer than 200 bytes is cut.

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