Dear All,   I have a list of fullnames and I want to separate the first name and the last name from the fullname. The names are not in the same format and hence the substr and the scan functions I tried are given me wrong output for some names. The names are as follows:   Fullname H FULLER WILLIAM D SMITHBURG BOONE POWELL JR. W. JAMES FARRELL SAMUEL C. SCOTT III DAVID A. L. OWEN, C.H., F.R.C.P. R. S. AUSTIN JAMES PACE Ann McLaughlin Korologos SUSAN CLARK-JOHNSON   The output I desire is as follows:     Fullname                                                 First_Name              Last_Name                     H FULLER                                               H                              Fuller WILLIAM D SMITHBURG                        William                     Smithburg BOONE POWELL JR.                              Boone                      Powell W. JAMES FARRELL                              W                              Farrell    SAMUEL C. SCOTT III                            Samuel                     Scott DAVID A. L. OWEN, C.H., F.R.C.P.         David                        Owen R. S. AUSTIN                                           R                               Austin JAMES PACE                                          James                       Pace Ann McLaughlin Korologos                     Ann                            Korologos SUSAN CLARK-JOHNSON                     Susan                        Clark-Johnson   I would appreciate if someone share a code with me.   Regards, S ... View more

Hello Everyone, I need your help with the creation of a SAS code. I want to create a subsample from my full sample. My full sample has three variables: Firm_ID, YEAR, and DirCount. The full sample looks as follows: Firm_ID     YEAR     Dir_Count A               2000          0 A               2001          0 A               2002          0 A               2003          0 B               2000          1 B               2001          1 B               2002          3 B               2003          2 C               2000          0 C               2001          1 C              2002           1 C               2003          0 D              2000           0 D               2001          1 D               2002          1 D               2003          1 E               2000          2 E               2001          3 E               2002          0 E               2003          0 The variable DirCount is number of independent directors (zero means there are no independent directors. DirCount is not a dummy variable). I want to create a subsample that either changed permanently from having no independent directors to independent directors or from independent directors to no independent directors. In other words, I want the subsample to contain the following information from the above full sample: Firm_ID     YEAR     Dir_Count D              2000           0 D               2001          1 D               2002          1 D               2003          1 E               2000          2 E               2001          3 E               2002          0 E               2003          0 I would appreciate if someone provide me with the code to construct this dataset. Thanks. S ... View more

Hi All, I am trying to divide the data set into two subset. The information that I have is as follows: Firm     Year     High     Change A          2000     0          0 A          2001     1          0 A          2002     1          0 A          2003     0          1 A          2004     0          0 B          2000     0          0 B          2001     1          0 B          2002     0          0 B          2003     1          1 B          2004     0          0 I want to divide this dataset into two subset: Subset 1 will have firms where High=1 when Change=1. Subset 2 is all other firms. For instance, Subset 1 will be: Firm     Year     High     Change B          2000     0          0 B          2001     1          0 B          2002     0          0 B          2003     1          1 B          2004     0          0 Subset 2 will be: Firm     Year     High     Change A          2000     0          0 A          2001     1          0 A          2002     1          0 A          2003     0          1 A          2004     0          0 I would appreciate if someone help me with the coding. Thanks, S ... View more

Hi All, I have a dataset with the following information: Ticker, Year, and COUNT. I want to create a new subset of this data where I keep firms whose COUNT is not zero for any years in the sample. For instance my original dataset is as follows: Ticker     Year     COUNT A     2007     0 A     2008     0 A     2009     1 A     2010     1 A     2011     3 A     2012     0 B     2007     1 B     2008     3 B     2009     2 B     2010     1 B     2011     1 B     2012     1 From the above example, I want to create a new subset which will have information only for firm B because B did not have COUNT = 0 for any of the years. Ticker     Year     COUNT B     2007     1 B     2008     3 B     2009     2 B     2010     1 B     2011     1 B     2012     1 I would appreciate if someone would help me in getting this desired output. Thank you for your time. Shalmali ... View more

Hello All, I am trying to create four subsets from my current dataset. I am not good with SAS codes and thus am not able to construct them. My main dataset looks as follows: FIRM     YEAR      NAME   DUMMY    CHANGE A             2004       Mr. X     0              0 A             2005       Mr. X     0              0 A             2006       Mr. Y     0              1 A             2007       Mr. Y     0              0 A             2008       Mr. Y     0              0 B             2004       Mr. S     0              0 B             2005       Mr. S     0              0 B             2006       Mr. T     1              1 B             2007       Mr. T     1              0 B             2008       Mr. T     1              0 C             2004       Mr. M   1              0 C             2005       Mr. M   1              0 C             2006       Mr. M   1              0 C             2007       Mr. N    1              1 C             2008       Mr. N    1              0 D             2004       Mr. R     1              0 D             2005       Mr. R     1              0 D             2006       Mr. V     0              1 D             2007       Mr. V     0              0 D             2008       Mr. V     0              0 Name is the name of the CEO in a firm. Dummy is 1 if the CEO meets some condition and 0 otherwise. CHANGE is 1 when there is change in the CEO. As you may see, there are some firms like A with DUMMY to be 0 for all observations, some firms like C with DUMMY to be 1 for all observations, some firms like B with DUMMY to be 0 for years before the CEO change and 1 for new CEO firm years, and some firms like D with DUMMY to be 1 for years before the CEO change and 0 for the new CEO firm year. I am trying to create four new subsets which will be as follows: Subset 1 will have only those firms whose DUMMY was 0 for all years. That is FIRM     YEAR      NAME   DUMMY    CHANGE A             2004       Mr. X     0              0 A             2005       Mr. X     0              0 A             2006       Mr. Y     0              1 A             2007       Mr. Y     0              0 A             2008       Mr. Y     0              0 , Subset 2 will have only those firms whose DUMMY was 1 for all the years. That is FIRM     YEAR      NAME   DUMMY    CHANGE C             2004       Mr. M   1              0 C             2005       Mr. M   1              0 C             2006       Mr. M   1              0 C             2007       Mr. N    1              1 C             2008       Mr. N    1              0 . Subset 3 will have firms whose DUMMY was 0 before the CEO change and 1 after the CEO change. That is, FIRM     YEAR      NAME   DUMMY    CHANGE B             2004       Mr. S     0              0 B             2005       Mr. S     0              0 B             2006       Mr. T     1              1 B             2007       Mr. T     1              0 B             2008       Mr. T     1              0 Subset 4 will have firms whose DUMMY was 1 before the CEO change and 0 after the CEO change. That is, FIRM     YEAR      NAME   DUMMY    CHANGE D             2004       Mr. R     1              0 D             2005       Mr. R     1              0 D             2006       Mr. V     0              1 D             2007       Mr. V     0              0 D             2008       Mr. V     0              0 I would really appreciate if someone share a code with me. Thank you, SS ... View more