SAS Certified Professional Prep Guide

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