Example
PROC SQL options;
SELECT column(s)
FROM table-name | view-name
WHERE expression
GROUP BY column(s)
HAVING expression
ORDER BYcolumn(s);
QUIT;
Example 1:
proc sql;
select name
,sex
from sashelp.class ;
quit;
The SELECT statement is specified in this order :
1.select;
2.from;
3.where;
4.group by;
5.having;
6.order by.
"select" and "from" are required. The other clauses are optional.
