The SQL Procedure

Example 5: Combining Two Tables

Procedure features:

DELETE statement

IS condition

RESET statement option

DOUBLE

UNION set operator

Tables:

PROCLIB.NEWPAY, PROCLIB.PAYLIST, PROCLIB.PAYLIST2

This example creates a new table, PROCLIB.NEWPAY, by concatenating two other tables: PROCLIB.PAYLIST and PROCLIB.PAYLIST2.

Input Tables

PROCLIB.PAYLIST

PROCLIB.PAYLIST2

libname proclib 'SAS-data-library';

options nodate pageno=1 linesize=80 pagesize=60;

proc sql;
   create table proclib.newpay as
      select * from proclib.paylist
      union
      select * from proclib.paylist2;

   delete
      from proclib.newpay
      where jobcode is missing or salary is missing;

   reset double;
   title 'Personnel Data';
   select *
      from proclib.newpay;