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
Using value labels in graphs through loopsHi all, I am trying to create a graph of weekly_count_visittype (Y axis) and week_num (X axis) separ…
Inclusion of both Age and Time Indicators in Panel Data AnalysisDear Colleagues, I am analyzing a panel data that collects information on children every two years …
Fillin/expand with panel and different datesHi All, please, could someone help me? I have the data below: Code: * Example generated by -dataex-…
How to reset a loop with a continues set of codes?Hi everyone, I hope you are doing well. I'm posting here because I have a doubt regarding a loop I'…
How to use the results of LCA(Latent Class Analysis) in the next step of regression analysis?Hello! I used gsem to perform an LCA analysis and separated the categories. How can I use this cate…
Subscribe to:
Post Comments (Atom)
0 Response to Loop to open, keep variables, and join different files
Post a Comment