![]() Chapter Contents |
![]() Previous |
![]() Next |
The SQL Procedure |
Procedure features: |
| |||
Tables: | PROCLIB.STAFF2, PROCLIB.SCHEDULE2, PROCLIB.SUPERV2 |
Input Tables |
PROCLIB.STAFF2 |
![]() |
![]() |
PROCLIB.SCHEDULE2 |
![]() |
![]() |
PROCLIB.SUPERV2 |
![]() |
![]() |
Program |
libname proclib 'SAS-data-library';
options nodate pageno=1 linesize=80 pagesize=60;
![]() | proc sql; title 'All Flights for Each Supervisor'; select s.IdNum, Lname, City 'Hometown', Jobcat, Flight, Date |
![]() | from proclib.schedule2 s, proclib.staff2 t, proclib.superv2 v |
![]() | where s.idnum=t.idnum and t.idnum=v.supid; |
Output |
![]() Chapter Contents |
![]() Previous |
![]() Next |
![]() Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.