hi, suppose that for each company-date combination I have a dummy variable called Duality and a description of a director: company date duality description A 31/12/2010 1 chairman ahah A 31/12/2009 1 chariman 57hf A 31/12/2009 1 ceo kgk9g9g B 20/10/2014 0 ceo gk9 C 13/2/2002 0 chairman chairmans I would like to create a new dummy variable ceo_dummy such that: whenever the word 'ceo' appears in the description ceo_dummy=1, BUT, if for any company-date duality=1 and there is no description entry with the word 'ceo', then whenever the word 'chairman' appears in the description ceo_dummy=1. so the result shuold be the following: company date duality description ceo_dummy A 31/12/2010 1 chairman ahah 1 A 31/12/2009 1 chariman 57hf 0 A 31/12/2009 1 ceo kgk9g9g 1 B 20/10/2014 0 ceo gk9 1 C 13/2/2002 0 chairman chairmans 0 like this every company-date combination has only one ceo_dummy=1 thank you! ... View more

Hi, suppose that for a given company-date combination I have the following info about the directors and categories: company date director category A 30/12/2000 John 1 A 30/12/2000 John 2 A 30/12/2000 John 3 A 30/12/2000 Bill 1 A 30/12/2000 Bill 3 A 30/12/2000 Suzan 1 What I would like to get is the total sum of each category into new variables (for each company-date combination): Header 1 Header 2 category1 category2 category3 A 30/12/2000 3 1 2 Thank you! ... View more

Hi, suppose that I have a population of 1000 objects categorized into 3 different types and that 50% of the total objects are Type1, 30% are Type2 and the remaining 20% are Type3. What I would like to do is to simulate a sample of 100 objects and randomly classify them into 3 types, and the types having the distribution of the population described above. I found how to simulate samples with embedded distributions, but have difficulty with the empirical distribution. Thank you! ... View more

hi, suppose that I have the folllowing table: text The banks and financial companies The bankers association First bank of England financial banking institutions If either the element "banks" or "financial" is present in an entry, then the new dummy variable =1, else 0. So the table should be like this: text Header 2 The banks and financial companies 1 The bankers association 0 First bank of England 0 financial banking institutions 1 thank you! ... View more