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
Getting formula rightDear all, I want to calculate the following decomposition below, which synthesizes how much of the …
How Do I Use a Seemingly Unrelated Regression To Compare the Magnitude of AMEs Between Two Models with Different Dependent Variables?Let's say I have two DVs, Anti-Muslim Sentiment (ranging continuous 0 to 1 inclusive) and Anti-Abori…
Xtitle: Unrecognized command errorHello. I am trying to replicate a figure from the code I got from the authors of a paper. When I ru…
Why can't I run the margins dydx command twice for different sets of covariates?So for some context, here is my regression model (a GLM estimation): Code: glm racial_support_inde…
Using statplot to plot averages of one variable, grouped by a list of different variablesHello, Apologies for the potentially confusing title. This is my first post on Statalist and I coul…
Subscribe to:
Post Comments (Atom)
0 Response to Matching values from a panel dataset to a cross-section dataset
Post a Comment