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
Creating one more observation systematicallyI just want to create one more observation. I did this sysuse auto, clear count local count=r(N) lo…
Bootstrapping with dummiesDear Stata Forum, I have data with a small number of clusters but with a large number of individuals…
Overlaying two KM graphs: same dataset, different stssetHello Statalisters, I use Stata 15 on Mac and would like to overlay two KM graphs, obtained using t…
Expand panel data to the latest datapoint available by groupHi, I would like to expand the data to the latest datapoint available by group ("unit_id" in my cas…
Two questionsHello, I have two questions regarding the data set below. First I have two data sets, one that shows…
Subscribe to:
Post Comments (Atom)
0 Response to Compare values across rows within observation
Post a Comment