I HAVE the following:   DIRECTORID            COMPANYID             DATESTARTROLE               DATEENDROLE 1                                              1001                            01JUL1998                 05MAR2021 2                                              1001                            01APR2020                05MAR2021 3                                              1001                            01JUL2010                 01MAY2011 1                                              1002                            06MAR2021               07MAR2024 2                                              1002                            06JUL2023                 05MAY2024 4                                              1002                            01APR1988                15JUN2023   I WANT the following:   DIRECTORID            MATCHES 1                                              3 2                                              1 3                                              1 4                                              1   Where MATCHES captures the unique number of DIRECTORIDs where employment at the COMPANYID overlaps.   I have over 3,000,000 observations.   Are there any suggestions on how to get my expected output?   Thank you!! ... View more

Hi All,   I am wanting to keep only observations where this is both a CEO and a CFO for every GVKEYYEAR.   I HAVE the following:   Name CEOANN CFOANN GVKEYYEAR Batman CEO   2008185 Robin   CFO 2008185 Mickey CEO   2001053 Mikey   CFO 2088087 Leo CEO   2088087 Goofy   CFO 2109087 Superman CEO   2089171 Peanut Butter CEO   1089721 Jelly   CFO 1089721   What I WANT is the following: Name CEOANN CFOANN GVKEYYEAR Batman CEO   2008185 Robin   CFO 2008185 Mikey   CFO 2088087 Leo CEO   2088087 Peanut Butter CEO   1089721 Jelly   CFO 1089721   What code may help me do this?   Thank you! ... View more

Hi Everyone,   I am merging two data sets - A and B;   Data Set A firstname   secondnameinitial    thirdname John                          A                          Doe John                          A                          Doe John                          A                          Doe James                       B                         Crow Jim                             C                        Throw Jonathan                  D                         Brown   Data Set B Forename1    Forename2Initial    Surname         ID John                           A                         Doe           12345 John                          A                          Doe           67890 James                       B                           Crow         15123 James                       B                          Crow          12518 Jim                            C                          Throw       30987 Jane                          D                          Scott         23484   I want matches with all of the information from both tables. I am merging on first name, middle initial, and last name using the following code:   proc sql; create table want as select * from have a inner join have b on (upper(trim(a.firstname))=upper(trim(b.Forename1))) and (upper(trim(a.thirdname))=upper(trim(b.Surname))) and (upper(trim(a.SecondNameInitial))=upper(trim(b.Forename2Initial))); quit;   My question is this: My output is about 10,000 names. How do I identify the duplicate matches that were eliminated during the merge process due to identical names? I can manually look at additional information to determine which names should be properly matched.   Thank you!         ... View more