• orders rows by the values that were assigned to the seasons in the Sorter column that
was created with the in-line view
Notice that the Sorter column is not included in the SELECT statement. That causes a
note to be written to the log indicating that you have used a column in an ORDER BY
statement that does not appear in the SELECT statement. In this case, that is exactly
what you wanted to do.
Conditionally Updating a Table
You want to update values in a column of a table, based on the values of several other
columns in the table.
There is one table, called Incentives, that contains information about sales data. There is
one record for each salesperson that includes a department code, a base pay rate, and
sales of two products, gadgets and whatnots.
input @1 Name $18. @20 Department $2. Payrate
Lao Che M2 8.00 10193 1105
Jack Colton U2 6.00 9994 2710
Mickey Raymond M1 12.00 6103 1930
Dean Proffit M2 11.00 3000 1999
Antoinette Lily E1 20.00 2203 4610
Sydney Wade E2 15.00 4205 3010
Alan Traherne U2 4.00 5020 3000
Elizabeth Bennett E1 16.00 17003 3003
title 'Sales Data for Incentives Program';
select * from incentives;
200 Chapter 6 • Practical Problem-Solving with PROC SQL