Dear all,
I hope you can help me with what seems to be a rather simple issue that i cannot seem to figure out.
I have a cross-section dataset that has information of 140 firms, ordered by id and year – it looks like this:
Array
I need values of revenue (rev) and employment (empl) inserted to this dataset from a panel one, which has information of the same 140 firms, but arranged in a panel format for between 2011-2020 – it looks like this:
Array
Is there a way to match or merge the dataset, somehow being able to insert rev and empl data from the panel one to the cross-section one - only for those years matching in the main 1st dataset? Any ideas? I am new to stata so this might be a rather stupid question but any help is appreciated!
Thanks,
Aydin
Related Posts with Matching values from a panel dataset to a cross-section dataset
Why has Stata dropped observations from my fixed effects model?Hi, I have a dataset of 318 local authorities and am running a fixed effects regression. However wh…
Renaming graphsHi, I would like to plot a graph titled "Crude Oil Production". As I type in the code, Code: two…
Embedded quotes questionHello, I'm trying to auto-generate do-files by copy/pasting from datasets created by the do-file th…
-tabout- -show(all)- and -mi- not workingHello all, First and foremost, thank you in advance to anybody that is able to help out. I tried se…
Creating a Regression Table from 2SLS RegressionsHi everyone! I would like to create two regression tables from nine 2SLS regressions. I have run m…
Subscribe to:
Post Comments (Atom)
0 Response to Matching values from a panel dataset to a cross-section dataset
Post a Comment