proc sql outobs=15;
select empid, jobcode, salary,
salary * .10 as Bonus
from sasuser.payrollmaster
where salary>75000
order by salary desc;
quit;
200 proc sql outobs=15;
201 select empid, jobcode, salary,
202 salary * .10 as Bonus
203 from sasuser.payrollmaster
204 where salary>75000
205 order by salary desc;
NOTE: 正在写入 HTML Body(主体)文件: sashtml28.htm
ERROR: 创建排序失败。
206 quit;
NOTE: 由于出错,SAS 系统停止处理该步。
NOTE: “PROCEDURE SQL”所用时间(总处理时间):
实际时间 0.03 秒
CPU 时间 0.04 秒