Hoping someone can help me with a problem involving dividing up a
variable. My data consists of patent numbers and inventors and looks
like this:
nmi
wku
Schmitt, Ty; Gandre, Jerry
5586003
Sato, N. Albert; Baker, David C.; Waldron, Christie J. 5586324
Swamy, N. Deepak
5587885
I would like it to look like this:
nmi
wku
Schmitt, Ty
5586003
Gandre, Jerry
5586003
Sato, N. Albert
5586324
Baker, David C.
5586324
Waldron, Christie J.
5586324
Swamy, N. Deepak
5587885
That is, I want to create a record containing each inventor and his or
her associated patent number. If Ty Schmitt had five patents, he should
show up in five records. The number of inventors per patent varies from
one to many.
I've looked for egen functions (and their extensions) and done some
experimenting, but am floundering. Any help would be very appreciated!
Glenn H.
Glenn Hoetker
Assistant Professor of Strategy
Department of Business Administration
University of Michigan at Urbana-Champaign
217-355-4891
[email protected]
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
