Please people, a little help here. I would like to calculate the accumulated value, but when I use the formula below the following error appears: PROC SQL; CREATE TABLE WORK.PARETO AS SELECT T1.CD_CLI, T1.MRG_SR, Sum(T1.MRG_SR) OVER (ORDER BY T1.PERIODO ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS 'acumulado' FROM CLSD_01 T1 WHERE T1.PERIODO = 202311 ;QUIT; ____ 22 76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored.
... View more