Hi, I have this dataset DATE CD AMOUNT P N 31-Oct-18 A1 5 1 . 31-Oct-18 A2 10 1 1 31-Oct-18 A3 15 . 1 30-Nov-18 A1 20 1 . 30-Nov-18 A2 25 1 1 30-Nov-18 A3 30 . 1 31-Dec-18 A1 35 1 . 31-Dec-18 A2 40 1 1 31-Dec-18 A3 45 . 1 and I wrote this code proc sql ; create table want as select DATE, CD, (SELECT AMOUNT FROM have B WHERE P=1 AND N IS NULL AND A.DATE=B.DATE) AS C, (SELECT AMOUNT FROM have B WHERE P IS NULL AND N=1 AND A.DATE=B.DATE) AS D, FROM HAVE A; quit; to get this table DATE CD C D 31-Oct-18 A1 5 . 31-Oct-18 A3 . 15 30-Nov-18 A1 20 . 30-Nov-18 A3 . 30 31-Dec-18 A1 35 . 31-Dec-18 A3 . 45 but it's not working. Could you please help me? Thanks.
... View more