Is there a way to do this all at one? I have 70 excel files looking to convert to dta files so I can just easily append it to a master dta file. Stata novice here.
-
Login or Register
- Log in with
xls2dta , clear : append
xls2dta : import excel "/Users/dinardorodriguez/Desktop/SNAPP Raw Data" xls2dta , clear : append
xls2dta , clear : append using "/Users/dinardorodriguez/Desktop/SNAPP Raw Data"
help language
xls2dta [ , generate(newvar1) ]
xls2dta
xls2dta , generate(newvar1)
xls2dta , generate(filename)
cd "your directory" local excels: dir . files "*.xlsx" foreach excel in `excels' { import excel using `excel',clear save `excel'.dta,replace }
Comment