Hi
I have two (or several matrices), which are datasets with an identifier for year and company, and then they have different data. One of the matrix have more data on each unique year and firm, and the other only has one observation for each year and firm, and some year / firm can be represented in only one of the matrixes.
So i need to link these matrixes together, so the year/firm that is not represented in both matrices are removed, and if there is more observations in matrix A with same year/firm it will have the data from matrix B repeated each time that year / firm is represented in matrix A.
Is there any function that can do this or do i have to run through alot of loops / if statements or what's the approach?
If needed i can provide the data :-)
Best regards,
Oskar
