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.
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.
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
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
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.
$ cv convert report.sqlite report/ --to xpt$ cv convert report.sqlite report/ --to xptQuestions.What people ask about SQLITE to XPT.
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.