The SELECT clause selects all columns from the table in the FROM clause, PROCLIB.STAFF. 
proc sql;
   title "Employees Whose Last Name Sounds Like 'Johnson'";
   select *
      from proclib.staff