Hello all,
New here, new to statistics, programming, and brand new to Stata so bear with me.
I am trying to merge three separate Excel files (Location: "C:\Stata") into a single Stata dataset ('MERGED') for analyses.
File names:
AE.xls
FZ.xls
WEIGHTS.xls
Unique Identifier (in all three): ID
What would be the code to go about creating this new data set? Thank you so much in advance.
Related Posts with Merging Excel Files to Create a Stata Dataset
Treatment and Period omitted because of collinearity (DiD)Dear Statalist Community, I am hopeful that you help me on this one as you did before. I have a mis…
factor variables may not contain noninteger valuesHi, I am trying to run the following regression: reg logchildwage logheadwage POOR age NPERSONS URB…
re-arrange dataHi, I have this type of table in Stata: industry_id period_1 period_2 sales_1 sales_2 11 1 0 10…
reg3 and xtabond2 Dear Statalist, I have estimated the 3SLS model below. reg3 (eq1: y1 = x1 x2 x3 x4 x5 dum1 dum2 d…
Remove margin below X-titleHi Statalist, I need to embed a local polynomial graph inside a LaTeX document. In order to keep th…
Subscribe to:
Post Comments (Atom)
0 Response to Merging Excel Files to Create a Stata Dataset
Post a Comment