These programming scripts have initially been developed for Jonas Ranstam's personal usage but are available for download. Most of the programs have been developed in a Linux environment and may need to be adapted to other operating system. Suggestions for improvement are welcome.
Validation of sqlite.ado
. use "https://www.stata-press.com/data/r16/lifeexp", clear
(Life expectancy, 1998)
. save "lifeexp.dta", replace
file lifeexp.dta saved
. sqlite export lifeexp.db lifeexp
(note: file temp.csv not found)
file temp.csv saved
. sqlite import lifeexp.db "SELECT * FROM lifeexp;"
(6 vars, 68 obs)
. cf _all using "lifeexp.dta", all verbose
© Copyright 2019 Jonas Ranstam. All rights reserved.