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
boxplots across groups?Dear All, My purpose is to replicate the following graph from a paper. Array
The original dataset …
Already defined variable in a loopHello. I am trying to generate confidence interval for some regressed variables. This is the code:
…
Generating new variables containing summary statistics with 'importance' weights?Dear Statalist,
I have microdata on individuals, where I have assigned those individuals to geograp…
Plot graphs in multiple windowsHey,
I have some accounting data for companies, matched into 58 industry codes. I want to plot grap…
Multiple imputation?Hello everyone,
First post here and I have to say I really enjoy my first months with Stata, even t…
Subscribe to:
Post Comments (Atom)
0 Response to Compare values across rows within observation
Post a Comment