I have two data-sets for my firms. My main data (A) is at month level. The other one (B), contains a variable I need, but is at year level. I have the company names as the shared identifier. How do I combine these two datasets so that the variable in B merges with my data A, and repeats itself for each of the 12 months in a given year? I tried the following but no luck:
merge m:1 company year using B
error: variables company year do not uniquely identify observations in the using data
which makes sense, because I have the data in A at month level. How can I go around this problem?
Thank you in advance for any help.
merge m:1 company year using B
error: variables company year do not uniquely identify observations in the using data
which makes sense, because I have the data in A at month level. How can I go around this problem?
Thank you in advance for any help.
Comment