After writing
the SELECT clause, you specify the table to be queried in the FROM
clause. Enter the keyword FROM, followed by the name of the table,
as shown:
proc sql;
select empid,jobcode,salary,
salary*.06 as bonus
from sasuser.payrollmaster
where salary<32000
order by jobcode;
The PROC SQL step above
queries the permanent SAS table Payrollmaster, which is stored in
a SAS library to which the libref Sasuser has been assigned.