Hello. I have a folder with about 50 data files. I want to merge the files either on 1 or 2 variables depending on if the data contains one or both of these variables. I have to repeat this process for about 10 different folders. Therefore, I would not like to open up each file and see which merging variables the file contains.
Also it is possible that a few files may have missing observations for the merging variables and would result in stata telling me the merging variables do not uniquely identify observations. I want to avoid checking each file and deleting these missing observations.
Any suggestions would be greatly appreciated! Thanks.
Amit
Related Posts with Merging multiple files in multiple folder on different variables in a loop
Using Wald Test for Complex Interaction ModelsDear all: My name is Siyu. I am running a random-effects logit model involving many interaction ter…
rename all words of localDear all, I have trouble finding my way through all possible local manipulations to find what I nee…
Gravity model, low R2-withinHi all ! I'm running a bilateral trade panel data of 42 reporter with 186 partner for the year 2015…
Meta-regression with WLS: Wrong sign due to weightingDear Statalist, I'm asking for advice to solve a problem with my meta-regression model based on a W…
Drop base variables from fvexpand listI want to modify the variable list produced by fvexpand, e.g. Code: . webuse nhanes2f, clear . f…
Subscribe to:
Post Comments (Atom)
0 Response to Merging multiple files in multiple folder on different variables in a loop
Post a Comment