Please help me to fix this problem
BTW, what does '19626 is too large" mean?
Thanks
ERROR: There are only 8 columns to GROUP BY. 19626 is too large.
procsql;
create table actetwaittime
as
SELECT CASE
WHEN datepart(a.triage_time) = today()-1 THEN 'Yesterday'
ELSE put(datepart(a.triage_time), yymmddd8.)
END
as thedate,
CASE WHEN S.ZONE_ID = 1 THEN 'North Zone' ELSE 'South Zone' END
as Zone,
S.SITE_DESC as site,
a.ctas,
AVG (
CASE
WHEN b.predicted_wt <= 0.5 THEN 0.5 ELSE b.predicted_wt
END)
as Pmean,
AVG (a.time_seen_by_doctor - a.triage_time) * 24 as Amean,
( AVG (a.time_seen_by_doctor - a.triage_time) * 24 / AVG ( CASE WHEN b.predicted_wt <= 0.5 THEN 0.5 ELSE b.predicted_wt END) - 1) * 100 as rate,
today() as Today
FROM rec.wait_time a, rec.snapshot b, REC.SITE s
WHERE a.snap_shot_id = b.snapshot_id
AND b.predicted_wt IS NOT NULL
AND a.time_seen_by_doctor IS NOT NULL
AND a.fasttrack IS NULL
AND put(S.SITE_ID,2.) = A.SITE_ID
AND A.CTAS IS NOT NULL
AND A.TRIAGE_TIME >= '01-JAN-2013'd AND A.TRIAGE_TIME <'02-JAN-2013'd GROUP BY
CASE
WHEN datepart(a.triage_time) = today()-1 THEN 'Yesterday'
ELSE put(datepart(a.triage_time), yymmddd8.)
END
,
CASE WHEN S.ZONE_ID = 1 THEN 'North Zone' ELSE 'South Zone' END
,
S.SITE_DESC ,
a.ctas,
today()
; Quit;
上面的例子中， group by 后 不应该跟
CASE
WHEN datepart(a.triage_time) = today()-1 THEN 'Yesterday'
ELSE put(datepart(a.triage_time), yymmddd8.)
END
而应该用 thedate 来代替它？
扫码加好友，拉您进群
全部版块
我的主页
收藏
