Thanks much Nick.
Sorry, no more attachments or fwd messages appended.
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.
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.
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.
Much appreciate your thoughts..
Thanks, Chirantan.
*
* 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/