Hi All, I need your help. I am trying to create a variable "Change" that takes value 1 for years after the CEO change. The information I have includes TIC (firm identifier), YEAR, and CEO. For instance, TIC YEAR CEO A     2005     Frank A     2006     Frank A     2007     TOD A     2008     TOD A     2009     TOD The output I am trying to get is: TIC YEAR CEO     CHANGE A     2005     Frank     0 A     2006     Frank     0 A     2007     TOD     1 A     2008     TOD     1 A     2009     TOD     1 I would appreciate if someone share with me the right code. Thank you SS ... View more

Dear All, I need your help in creating a new sample out of my current sample. My original sample has information about the firm (tic), year, and CEO. The sample period range from 2003 to 2013. I am trying to create a new sample that meets the following requirements: 1) the sample period should be from 2005 to 2012. 2) include only those firms that changed CEO only once and ceo should be changed between 2007 and 2010. FOr instance if my original sample is as follows: TIc year ceo A 2003 Tim A 2004 Tim A 2005 Tim A 2006 Tim A 2007 Tim A 2008 John A 2009 John A 2010 John A 2011 John A 2012 John A 2013 John B 2003 Lin B 2004 Lin B 2005 Lin B 2006 Sam B 2007 Sam B 2008 Sam B 2009 Sam B 2010 Sam B 2011 Sam B 2012 Sam B 2013 Sam C 2003 Dan C 2004 Dan C 2005 Dan C 2006 Dan C 2007 Dan C 2008 Dan C 2009 Dan C 2010 Dan C 2011 Jack C 2012 Jack C 2013 Jack D 2003 Ali D 2004 Ali D 2005 Ali D 2006 Ali D 2007 Bill D 2008 Bill D 2009 Bill D 2010 Frank D 2011 Frank D 2012 Frank D 2013 Frank IN the above example, A, B, and C has only one CEO change. However CEO was changed for firm B in 2006 and for firm C in 2011. So I dont want to keep B and C in my new sample. Firm D has two ceo change. So I want to exclude it too. In other words, my new sample should be A 2005 Tim A 2006 Tim A 2007 Tim A 2008 john A 2009 John A 2010 John A 2011 John A 2012 John I would appreciate if someone can share  the code with me that will help me create the desired sample. THank you ... View more

Hi All, I have a dataset and want to created a new variable, POST, based on the information I have. The data includes information on ticker, year, and Restate. I want to create a new variable, POST, which will take value 1 for period post restatement (period after Restate =1). That is, if my sample data is as follows: DATA HAVE;   INPUT  TICKER $ year RESTATE ; CARDS; A  2000    0 A  2001     0 A  2002     0 A  2003     0 A  2004     1 A  2005     0 A  2006      0 B  2000    0 B  2001    0 B  2002    1 B  2003    0 B  2004    0 B  2005    0 B  2006     0 ; RUN; For firm A, restatement occurred in 2004. I want POST to be 0 for period prior to 2004 and 1 for period 2004 onwards.  Similarly for B, POST will be 0 for period prior to 2002 and 1 for period post restatement. That is, the output should be: ticker year     restate     POST A  2000           0               0 A  2001          0               0 A  2002          0               0 A  2003          0               0 A  2004          1               1 A  2005          0               1 A  2006          0               1 B  2000          0               0 B  2001          0               0 B  2002          1               1 B  2003          0               1 B  2004          0               1 B  2005          0               1 B  2006          0               1 If a company has two restatement in the sample period, then I want POST to be 2 after the second restatement. For instance if the data is as follows: DATA HAVE;   INPUT  name $ year RESTATE ; CARDS; A  2000    0 A  2001     1 A  2002     0 A  2003     0 A  2004     1 A  2005     0 A  2006      0 ; RUN; The output should be ticker year     restate     POST A  1999           0               0 A  2000           0              0 A  2001          1               1 A  2002          0               1 A  2003          0               1 A  2004          1               2 A  2005          0               2 A  2006          0               2 I would appreciate if someone could share a code with me. Thank you for your time. ... View more

Hi, I want a sample with firm identifier, dates, begin date, and end date. I want to create a new variable, SUMRET, that will be a sum of returns between begin date and end date. The subsample of my data looks as follows: Ticker ret date begindate enddate A 2.5 1/31/2004 4/1/2004 3/31/2005 A 2.1 2/29/2004 4/1/2004 3/31/2005 A 2.3 3/31/2004 4/1/2004 3/31/2005 A 2.25 4/30/2004 4/1/2004 3/31/2005 A -2.3 5/31/2004 4/1/2004 3/31/2005 A 2.2 6/30/2004 4/1/2004 3/31/2005 A 2.6 7/31/2004 4/1/2004 3/31/2005 A 2.2 8/31/2004 4/1/2004 3/31/2005 A 2.4 9/30/2004 4/1/2004 3/31/2005 A 2.3 10/31/2004 4/1/2004 3/31/2005 A 2.25 11/30/2004 4/1/2004 3/31/2005 A -2.3 12/31/2004 4/1/2004 3/31/2005 A 2.2 1/31/2005 9/1/2005 10/31/2006 A 2.6 2/28/2005 9/1/2005 10/31/2006 A 2.2 3/31/2005 9/1/2005 10/31/2006 A 2.6 4/30/2005 9/1/2005 10/31/2006 A 2.55 5/31/2005 9/1/2005 10/31/2006 B 2.5 1/31/2005 9/1/2005 8/31/2006 B 2.1 2/28/2005 9/1/2005 8/31/2006 B 2.3 3/31/2005 9/1/2005 8/31/2006 B 2.25 4/30/2005 9/1/2005 8/31/2006 B -2.3 5/31/2005 9/1/2005 8/31/2006 B 2.2 6/30/2005 9/1/2005 8/31/2006 B 2.6 7/31/2005 9/1/2005 8/31/2006 B 2.2 8/31/2005 9/1/2005 8/31/2006 B 2.4 9/30/2005 9/1/2005 8/31/2006 B 2.3 10/31/2005 9/1/2005 8/31/2006 B 2.25 11/30/2005 9/1/2005 8/31/2006 B -2.3 12/31/2005 9/1/2006 8/31/2006 B 2.2 1/31/2006 9/1/2006 8/31/2007 B 2.6 2/28/2006 9/1/2006 8/31/2007 B 2.2 3/31/2006 9/1/2006 8/31/2007 B 2.6 4/30/2006 9/1/2006 8/31/2007 B 2.55 5/31/2006 9/1/2006 8/31/2007 B 2.5 6/30/2006 9/1/2006 8/31/2007 B 2.1 7/31/2006 9/1/2006 8/31/2007 B 2.3 8/31/2006 9/1/2006 8/31/2007 B 2.25 9/30/2006 9/1/2006 8/31/2007 B 2.2 10/31/2006 9/1/2006 8/31/2007 B 2.6 11/30/2006 9/1/2006 8/31/2007 B 2.2 12/31/2006 9/1/2006 8/31/2007 I am trying to create an output as follows: Ticker ret date begindate enddate SUMRET A 2.5 1/31/2004 4/1/2004 3/31/2005 18.6 A 2.1 2/29/2004 4/1/2004 3/31/2005 18.6 A 2.3 3/31/2004 4/1/2004 3/31/2005 18.6 A 2.25 4/30/2004 4/1/2004 3/31/2005 18.6 A -2.3 5/31/2004 4/1/2004 3/31/2005 18.6 A 2.2 6/30/2004 4/1/2004 3/31/2005 18.6 A 2.6 7/31/2004 4/1/2004 3/31/2005 18.6 A 2.2 8/31/2004 4/1/2004 3/31/2005 18.6 A 2.4 9/30/2004 4/1/2004 3/31/2005 18.6 A 2.3 10/31/2004 4/1/2004 3/31/2005 18.6 A 2.25 11/30/2004 4/1/2004 3/31/2005 18.6 A -2.3 12/31/2004 4/1/2004 3/31/2005 18.6 A 2.2 1/31/2005 9/1/2005 10/31/2006 A 2.6 2/28/2005 9/1/2005 10/31/2006 A 2.2 3/31/2005 9/1/2005 10/31/2006 A 2.6 4/30/2005 9/1/2005 10/31/2006 A 2.55 5/31/2005 9/1/2005 10/31/2006 B 2.5 1/31/2005 9/1/2005 8/31/2006 23.7 B 2.1 2/28/2005 9/1/2005 8/31/2006 23.7 B 2.3 3/31/2005 9/1/2005 8/31/2006 23.7 B 2.25 4/30/2005 9/1/2005 8/31/2006 23.7 B -2.3 5/31/2005 9/1/2005 8/31/2006 23.7 B 2.2 6/30/2005 9/1/2005 8/31/2006 23.7 B 2.6 7/31/2005 9/1/2005 8/31/2006 23.7 B 2.2 8/31/2005 9/1/2005 8/31/2006 23.7 B 2.4 9/30/2005 9/1/2005 8/31/2006 23.7 B 2.3 10/31/2005 9/1/2005 8/31/2006 23.7 B 2.25 11/30/2005 9/1/2005 8/31/2006 23.7 B -2.3 12/31/2005 9/1/2006 8/31/2006 23.7 B 2.2 1/31/2006 9/1/2006 8/31/2007 B 2.6 2/28/2006 9/1/2006 8/31/2007 B 2.2 3/31/2006 9/1/2006 8/31/2007 B 2.6 4/30/2006 9/1/2006 8/31/2007 B 2.55 5/31/2006 9/1/2006 8/31/2007 B 2.5 6/30/2006 9/1/2006 8/31/2007 B 2.1 7/31/2006 9/1/2006 8/31/2007 B 2.3 8/31/2006 9/1/2006 8/31/2007 B 2.25 9/30/2006 9/1/2006 8/31/2007 B 2.2 10/31/2006 9/1/2006 8/31/2007 B 2.6 11/30/2006 9/1/2006 8/31/2007 B 2.2 12/31/2006 9/1/2006 8/31/2007 The value of SUMRET for firm A for year 2004 is calculated by adding ret from period 04/30/2004 till 03/31/2005. This is because the begin date is 04/1/2004 and end period is 03/31/2005. Similarly the SUMRET for firm B for 2005 is calculated by adding ret from the period 09/30/2005 till 08/31/2006. This is because the begin date is 09/1/2005 and end period is 08/31/2006. Thanks. ... View more

Hi I have a data set and would like to remove certain firms. The sample has firm identifier, year , and exec_fullname. I want to create a new sample where there is no executive change between 2004 and 2012.  In other words, my final sample should start from year 2004 and there should not be any change in the executive. For instance, a subset of my data looks as follows: Tic       Year     Exec_fullname A         2003    Mr. John A         2004    Mr. John A         2005    Mr. John A         2006    Mr. John A         2007    Mr. John A         2008    Mr. John A         2009    Mr. John A         2010    Mr. John A         2011    Mr. John A         2012    Mr. John B          2002    Mr. Smith B          2003    Mr. Smith B          2004    Mr. Smith B          2005    Mr. Smith B          2006    Mr. Smith B          2007    Mr. Smith B          2008    Mr. Thompson B          2009    Mr. Thompson B          2010    Mr. Thompson B          2011    Mr. Thompson B          2012    Mr. Thompson Output Tic       Year     Exec_fullname A         2004    Mr. John A         2005    Mr. John A         2006    Mr. John A         2007    Mr. John A         2008    Mr. John A         2009    Mr. John A         2010    Mr. John A         2011    Mr. John A         2012    Mr. John I would appreciate if someone provide me with the code. Thank you. ... View more