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
How to use 'local' for grouping control variables in multiple regressionsDear all, I'm running multiple regression with the same set of controls. I use "local" command so t…
Stata16.0 the code of spmapDear all, I am using the code of spmap by Stata SE 16.0,but here some problems. The example data are…
space, global variable and combine graphsDear Statalists, I tried to use Stata command grc1leg2 in Stata 15 to combine several graphs. I have…
Latent variable scoreDear Stata users, could someone tell me how to estimate the latent variable score for a first-order…
Delete the last numbersDear All, I have this dataset Code: * Example generated by -dataex-. To install: ssc install dataex…
Subscribe to:
Post Comments (Atom)
0 Response to Compare values across rows within observation
Post a Comment