Hi all,
So I am trying to append 3 excel sheets into one Stata file but I would need to destring one of the sheets (Sheet3) first in order to append. I am using the xls2dta command to append but it says "previous command was not xls2dta". What should I do?
This is what I did:
ssc install xls2dta
xls2dta ,allsheets : import excel using "/Users/xyz/Downloads/list_of_treaties.xlsx", firstrow clear
use list_of_treaties_3.dta
destring YEAR YEAR_START YEAR_VALID, replace force
xls2dta ,clear : append
Thank you!
Related Posts with destring before append
xtpcse with ols coefficients and ar(1) standard errorsDear users, I have a panel with n=40 states and t=30 years which I would like to estimate with the …
Exporting/Displaying boottest resultsHi everyone, I am running a difference in differences regression with Panel data on Stata version 1…
A question about GDP interacted with Quarter Fixed EffectsHi! What could be the idea behind interact GDP with Quarter Fixed Effects in a Difference in Differ…
Interpreting coefficients with two interaction termsHello, I have a general question about how to interpret regression coefficients, when you have more…
Getting value of specific value labelDear Statalisters, I've got a (probably very easy) problem and I'm somehow blind for the answer.. …
Subscribe to:
Post Comments (Atom)
0 Response to destring before append
Post a Comment