求教各位,
为什么下面代码中,
WHERE p2.&IDVar= p1.&IDVar 这句不能去掉?
p1 p2 p3 是否可以去掉?
proc sql noprint;
create table &DSout as
SELECT &IDVar , MIN( &XVar ) AS mode
FROM (
SELECT &IDVar, &XVar
FROM &Dsin p1
GROUP BY &IDVar, &XVar
HAVING COUNT( * ) =
(SELECT MAX( CNT )
FROM (SELECT COUNT( * ) AS CNT
FROM &Dsin p2
WHERE p2.&IDVar= p1.&IDVar
GROUP BY p2.&XVar
) AS p3
)
) AS p
GROUP BY p.&IDVar
;
quit;