표준편차 STDDEV와 분산 VARIANCE는 어떻게 사용하는 건가요?
예제 3-11에서 처럼 하면 안되더군요...
DATA: GV_CARRID2 TYPE SFLIGHT-CARRID
, GV_CONNID2 TYPE SFLIGHT-CONNID
, GV_PAYMENTSUM TYPE I "AVG 평균
, GV_SEATSOCC_F TYPE I "SUM 합계
, GV_SEATSOCC_MAX TYPE I "MAX 최대값
, GV_SEATSOCC_MIN TYPE I "MIN 최소값
, GV_SEATSMAX TYPE I "STDDEV 표준편차
, GV_SEATSOCC TYPE I. "VARIANCE 분산
SELECT CARRID STDDEV( SEATSMAX ) AS INTEGER ) AS STDDEV_MAX
INTO ( GV_CARRID2, GV_SEATSMAX )
FROM SFLIGHT
GROUP BY CARRID.
WRITE: / GV_CARRID2, GV_SEATSMAX.
ENDSELECT.
SELECT CARRID VARIANCE( SEATSOCC ) AS VAR_OCC
INTO ( GV_CARRID2, GV_SEATSOCC )
FROM SFLIGHT
GROUP BY CARRID.
WRITE: / GV_CARRID2, GV_SEATSOCC.
ENDSELECT.
에러가 아래와 같이 납니다.
The function "STDDEV" is unknowm.
The function "VARIANCE" is unknowm.