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

Figure 7.13 Proclib.Staff

Program to Select Names That Sound like 'Johnson'

libname proclib 'SAS-library';

proc sql;

title "Employees Whose Last Name Sounds Like 'Johnson'";

select idnum, upcase(lname), fname

from proclib.staff

where lname=*"Johnson"

order by 2;

Program Description

Declare the Proclib library. The Proclib library is used in these examples to store

created tables.

libname proclib 'SAS-library';

Select the columns and the table from which the data is obtained. The SELECT

clause selects all columns from the table in the FROM clause, Proclib.Staff.

proc sql;

title "Employees Whose Last Name Sounds Like 'Johnson'";

select idnum, upcase(lname), ...