data Lizz; informat ID $2. Banana $1. Apple $1. Job $10.; input ID $ Banana $ Apple $ Job $; datalines; AA Y Y Doctor BB Y N Student CC Y N Lawyer DD N N Doctor EE Y N Doctor FF N Y Student GG Y N Lawyer ; run; proc sql; select Job, Count(Job) as Count from lizz where Banana='Y' and Apple='N' group by Job; quit;