![]() Chapter Contents |
![]() Previous |
![]() Next |
The SQL Procedure |
Procedure features: |
| |||||||||||
Tables: | PROCLIB.STAFF, PROCLIB.PAYROLL |
Input Tables |
PROCLIB.STAFF (Partial Listing) |
![]() |
![]() |
PROCLIB.PAYROLL (Partial Listing) |
![]() |
![]() |
Program |
libname proclib 'SAS-data-library';
options nodate pageno=1 linesize=120 pagesize=40;
![]() | proc sql number; |
![]() | title 'Information for Certain Employees Only'; select Lname, Fname, City, State, IdNumber, Salary, Jobcode |
![]() | from proclib.staff, proclib.payroll |
![]() | where idnumber=idnum and idnum in ('1919','1400', '1350', '1333'); |
Output |
![]() Chapter Contents |
![]() Previous |
![]() Next |
![]() Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.