Syntax, ORDER BY clause:
PROC SQL <options>;
SELECT column-1 <,...column-n>
FROM input-tables
WHERE expression
GROUP
BY column-name <,column-name>
ORDER
BY column-name <DESC> <,column-name>;
QUIT;
|
proc sql;
select empid,jobcode,salary,
salary*.06 as bonus
from certadv.payrollmaster
where salary<32000
order by jobcode;
quit;
proc sql;
select empid,jobcode,salary,
salary*.06 as bonus
from certadv.payrollmaster
where salary<32000
order by jobcode,empid;
quit;
proc sql;
select empid, jobcode, salary, dateofhire
from certadv.payrollmaster
where salary<32000
order by 4, 2;
quit;