The SQL Procedure

Example 4: Joining Two Tables

Procedure features:

FROM clause

table alias

inner join

joined-table component

PROC SQL statement option

NUMBER

WHERE clause

IN condition

Tables:

PROCLIB.STAFF, PROCLIB.PAYROLL

This example joins two tables in order to to get more information about data that are common to both tables.

Input Tables

PROCLIB.STAFF (Partial Listing)

PROCLIB.PAYROLL (Partial Listing)

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');