Hello,
I am struggling with the following task that already kept me bugging for hours.
This is the process step by step:
1. Import individual file (names: file2002, file2004, file2006, file2008, file2010)
2. Keep only the variables: id aa001_* aa004_* ba016_* ca001_* ea104_* eb001_* eb002_* ec023_* eh041_*. * should be replaced with 2002, 2004, 2006, 2008, 2010.
3. Join files on the first file using the id variable as key
Having spent more than 5 hours now, I didn't get far. The main problem involves the joining of multiple files. Is there a possibility to perform this task using simple code? I can imagine that there's are fairly frequently performed operations.
Thank you very much.
Sincerely,
Simon
Related Posts with Loop to open, keep variables, and join different files
RIF functionHello Everyone, I have been reading some literature on Recentered Influence function and Influence …
quantile regressionHello everyone, I am doing an analysis on "Socio economic inequality on childhood health outcomes".…
General structure of data.How can I describe the structure of the dataset using summary statistics, graphical analysis and var…
Question about multivariate regression analysisDear colleagues, Good morning. I would like to ask about multivariate regression analysis. I researc…
Graph the marginal effect of x1 on y (y-axis) against x2 (x-axis)?Dear All, Suppose I run the following regression: Code: // ssc install interflex, interactplot sysu…
Subscribe to:
Post Comments (Atom)
0 Response to Loop to open, keep variables, and join different files
Post a Comment