proc sql;
   connect to oracle as tempdb
           (user=student pw=sesame path=temppath 
            connection=global);
   select *
      from 
                (select ssn, lname, fname, activity
                 from members where contacts<5);
   ...
quit;