Hi,
My datasets are like following forms:
Inventorid patentyear firmid
3930988 2000 13928
3930988 2001 13928
3930988 2002 15892
3890212 2001 15892
3890212 2001 15892
I'm trying to compare firmid for the same inventor and generate a variable move = 1 if firmid != firmid in the previous rows. The desired results is as follows. For example, for inventor 3930988, he is regarded as move = 1 when the firmid change (15892 VS 13928).
NOTE that, comparison of the firms only within observations. For example, for inventor 3930988, compare firmid within the first 3 rows. for Inventor 3890212, compare within the last two rows. Many thanks if you could provide any suggestions!
Inventorid patentyear firmid move
3930988 2000 13928 0
3930988 2001 13928 0
3930988 2002 15892 1
3890212 2001 15892 0
3890212 2001 15892 0
Related Posts with Compare values across rows within observation
Add Confidence intervals to median splineI would like to add 95% confidence intervals to a median spline. It does not appear to be an option …
Heckman modelDear Stata Users, I am applying the two step Heckmam model, but I am having a problem. After havin…
xtoprobit vs xtreg, feI want to run a fixed effects regression model in stata using panel data to examine the change in in…
statistical significanceHi, How check in stata statistical significance between price and country of origin from data stata.…
How to test correlation between two variables – Panel dataHi all! I wonder how it is possible to test for correlation between two variables (panel data). Wha…
Subscribe to:
Post Comments (Atom)
0 Response to Compare values across rows within observation
Post a Comment