The FROM Clause
FROM Clause Syntax
After writing the SELECT
clause, use the FROM clause to specify the tables or views to be queried.
Enter the keyword FROM, followed by the name of the table.
|
Syntax, FROM clause:
PROC SQL <options>;
SELECT column-1 <,...column-n>
FROM input-tables;
QUIT;
|
Example: Querying a Single Table Using the FROM Clause
Suppose you want to
query a permanent SAS table called Payrollmaster, which is stored
in the Certadv library. The FROM clause specifies Certadv.Payrollmaster
to be queried.
proc sql;
select empid, jobcode, salary, salary*0.06 as bonus
from certadv.payrollmaster
where salary<32000
order by jobcode;
quit;
Last updated: October 16, 2019
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.