Hello,

I'm trying to merge two datasets that have basically the same observations but with different variable names.

One has for example "AUS1954" (Australia 1954) as country_id. The other dataset has "AUS" and "1954" in two separate variables (country and year). Is it possible to merge these who in a new variable so they can match AUS1954 in the first dataset?

Thank you in advance, i'm a beginner.