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
Filter households' data from a censusHi everyone! I'm working on my Master's thesis and I need help. I'm working with census data, and I …
How do I expand period data into data by year?Hello, relatively new user here, using stata for my university class and have a base level proficien…
Count how many variables have more than a certain number of missing valuesHi Statalists! I'm stuck on a very simple task: I would like to count how many variables in my datas…
Adding lines at 95% CI to kdensity plotHi all, I want to add red lines at the 95% confidence interval (one on each side) in this kdensity …
Difference in difference analysis, defining treatment and control groupsI want to run a difference in differences design. I have a balanced panel of individuals across 10 …
Subscribe to:
Post Comments (Atom)
0 Response to destring before append
Post a Comment