Hello,
I have looked for guidance from other posts but could not solve this: I have two datasets- 'Dataset A has annual observations (for instance, on local infrastructure expenditure) while Dataset B has observations at interval of 5 years (for instance, on elections- winners, number of votes, winner's details). There are key variables which can be used for merging Dataset A and Dataset B- area code. But the person elected in 2001, for example, is responsible for infrastructural investment for the subsequent 5 years. How do I merge them to match each observation in Dataset A with corresponding leaser's observations in Dataset B?