程序:
proc sql ;
select make,model,MSRP,max(MSRP) as mMSRP
from sashelp.cars
group by make
having MSRP = mMSRP;
quit;
运行结果:
247 proc sql ;
248 select make,model,MSRP,max(MSRP) as mMSRP
249 from sashelp.cars
250 having MSRP = mMSRP;
NOTE: 查询要求将汇总统计量与原始的数据重新合并。
251 group by make
-----
180
ERROR 180-322: 语句无效或未按正确顺序使用。
252 quit;
求问:
为什么having放在group前面就会出现错误呀?