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