SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

Input Tables

This example creates a new table, Proclib.Newpay, by concatenating two other tables:

Proclib.Paylist and Proclib.Paylist2.

proc sql;

title 'Proclib.Paylist Table';

select * from proclib.paylist;

Figure 7.5 Proclib.Paylist Table

proc sql;

title 'Proclib.Paylist2 Table';

select * from proclib.Paylist2;

title;

Figure 7.6 Proclib.Paylist2 Table

Program

libname proclib 'SAS-library';

proc sql;

create table proclib.newpay as

select * from proclib.paylist

union

select * from proclib.paylist2;

Example 5: Combining Two Tables 279

delete

from proclib.newpay ...