`proc sql; CREATE TABLE WORK.twentyeighteen AS SELECT a.*, INPUT(put(TransactionDate,8.),yymmdd8.) AS TransactionDate format ddmmyy10. FROM database.td AS a WHERE TransactionDate > 20180101; quit;` proc sql; CREATE TABLE WORK.trans AS SELECT SUM(CashValue + ChequeValue + TransferValue) as TotalDeposit, MONTH(TransactionDate) AS month FROM WORK.twentyeighteen WHERE TransactionCode = 1 GROUP BY month ORDER BY month; quit; I don'y receive any errors but the result is only a single row instead of a list of deposits per month
... View more