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
estadd local not working in Stata 17Since I started using Stata 17, I encountered a problem that I cannot seem to fix. Normally, I would…
Using -xtologit- postestimation tools (particularly margins) when independent variables include an interaction of two binary variablesHi Users, Long time quiet reader, first time poster - I hope I have followed the community recommen…
Merging two datasetsHello, I have to merge two datasets. The key variable is str32. The problem I'm facing is that in o…
Is it possible to tag duplicates sequentially?Hi Everyone! My data looks like below and I request for any syntax that helps to tag the duplicates …
Tabulating (counting) within many groups in a dataset does one company appearHello, I'm working with a many:1 dataset where each observation represents a single insurance polic…
Subscribe to:
Post Comments (Atom)
0 Response to Matching values from a panel dataset to a cross-section dataset
Post a Comment