I used the following command to import several Excel sheets into a dta file. It worked well. However, when I come back to my codes and re-run them, I get the following error message: "already exists". I thought using the replace command in some way would help but it didn't. Instead, I get another error message saying: "invalid 'replace"
xls2dta, save() allsheets generate(filename month):import excel using "LGH ESM OPD Appt QView - Diab Endo - Nov 2017 to Dec 2018_Cleaned 080120.xlsx",firstrow case(preserve)
Thank you!
0 Response to How to use the "replace" option with xls2dta command
Post a Comment