The SQL Procedure

Example 11: Retrieving Values with the SOUNDS-LIKE Operator

Procedure features:

ORDER BY clause

SOUNDS-LIKE operator

Table:

PROCLIB.STAFF

This example returns rows based on the functionality of the SOUNDS-LIKE operator in a WHERE clause.

Input Table

PROCLIB.STAFF

libname proclib 'SAS-data-library';

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

proc sql;
   title "Employees Whose Last Name Sounds Like 'Johnson'";
   select *
      from proclib.staff

      where lname=*"Johnson"
      order by 2;

Output

title "Employees Whose Last Name Sounds Like 'Sanders'"; select * from proclib.staff where lname=*"Sanders" order by 2;