Cheers, Chirantan.
> Answers interspersed below.
>
> Nick [email protected]
>
> Chirantan Chatterjee
>
> About the new in_EE or in_OECD variable which takes 1 or 0, i essentially
> need a variable irrespective of Pub_nbr observations, that is 1 for any EE
> inventor or OECD inventor observation - right? Why then do i need the
> -merge- command, am i missing something here.
>
>>>> You don't need the -merge- approach, and I didn't say that you do,
> but it is a good one. Why it is a good idea and how it works are explained
> in detail in the two FAQs I directed you towards.
>
> About the code: bysort pub_nbr (in_OECD) : gen byte any_in_OECD =
> in_OECD[_N] == 1
>
> Doesnt this generate a new variable, which takes 1, if all inventors in
> pub_nbr, stacked one upon another are OECD inventors - whereas i need it
> to be 1, even when i find just one inventor is from an OECD country.
>
>>>> No. The subscript [_N] ensures that you will get precisely what you
>>>>
> want. Even if there is only one such inventor, the observation for that
> inventor will be last within each patent group, given the sort order, so
> that it will still be true that -in_OECD[_N] == 1-. The command does quite
> a lot at once. For a tutorial on -by:- see
> <http://www.stata-journal.com/sjpdf.html?articlenum=pr0004>
>
> SJ-2-1 pr0004 . . . . . . . . . . Speaking Stata: How to move step by:
> step . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . N. J. Cox
> Q1/02 SJ 2(1):86--102 (no commands)
> explains the use of the by varlist : construct to tackle a variety of
> problems with group structure, ranging from simple calculations for each
> of several groups to more advanced manipulations that use the built-in _n
> and _N
>
> About the last variable, i need to do the same, even if one of the patent
> applicant is from an OECD country - guess if you clarify the above can
> figure that out for myself.
>
>>>> I trust so.
>
>
> * * 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/
>
>
--
*
* 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/