sas2sqlite3 0.0.2

Import sas7bdat files to sqlite3 dbase

sas2sqlite3

Import sas7bdat files to sqlite3 dbase. Uses the sas7bdat SAS dataset file parser.

Command-line and python library interface with minimal requirements.

CLI usage

Create and import data into some_dataset table in some_sqlite.db

sas2sqlite some_dataset.sas7bdat some_sqlite.db

Import data into existing some_table table in some_sqlite.db

sas2sqlite some_dataset.sas7bdat some_sqlite.db --table some_table --no-create-table

Import data storing dates and datetimes as Julian days, and times as HH:MM:

sas2sqlite some_dataset.sas7bdat some_sqlite.db \
    --time "%H:%M" --date julian --datetime julian

Install

Requires python 3.6+ and pip.

pip install sas2sqlite3

Note: the package has a '3' at the end. The executable does not.

Other tools

• sas2db: Import SAS dataset and XPT files to any database supported by SQL Alchemy. Uses pandas SAS parser under the hood.