Jonas Ranstam PhD

        Home     Biography     Publications     Programs     Tips     Mdas AB  


Programs

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.

Bash
Excel
PHP commandline
Stata ado

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
. 
. clear
. 
. sqlite import lifeexp.db "SELECT * FROM lifeexp;"
(6 vars, 68 obs)
. 
. cf _all using "lifeexp.dta", all verbose
          region:  match
         country:  match
       popgrowth:  match
            lexp:  match
           gnppc:  match
       safewater:  match
. 



© Copyright 2019 Jonas Ranstam. All rights reserved. Privacy policy. Admin.