Matching values from a panel dataset to a cross-section dataset

[Aydin Yildirim]

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:

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:

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

[Fei Wang]

Aydin, I think you may need to reformat "year" in the first dataset before implementing the merging.

use firstdata, clear
destring year, replace

merge 1:1 name year using seconddata
drop if _merge == 2

[Aydin Yildirim]

Fei Wang thank you so much! yes, indeed I needed to destring the year variable!
Now I was able to run the command, but the merged dataset doesn't actually have any values =)

any thoughts?

[Fei Wang]

Fei Wang thank you so much! yes, indeed I needed to destring the year variable!
Now I was able to run the command, but the merged dataset doesn't actually have any values =)

any thoughts?[ATTACH=CONFIG]n1633357[/ATTACH]

Aydin, sorry that my previous codes have errors. Please refer to the updated codes in #2.