proc SQL 中的exists

proc sql;
    title1 'Frequent Flyers Who Are Employees';
    select count(name) from Sasuser1.Frequentflyers
    where  exists ( select catx(", ", lastname, firstname) as name
                        from SASUser1.Staffmaster
                        where Frequentflyers.name = calculated name);
quit;