Hi, Something like (and this is guessing without example data): proc sql;      create table WANT as      select     CEO.CEO,                     CEO.GENDER,                     MRET.AVG_MRET3      from        (select distinct CEO,GENDER from CEO where GENDER="Female") CEO      left join     (select distinct                                   CEO,                                   AVG(MRET3) as AVG_MRET3                        from    MRET3                        group by CEO,                                        YEAR) MRET      on            CEO.CEO=MRET.CEO; quit; ... View more