Hello everybody, I have a table in Oracle which needed to be updated. there for I used following code, proc sql ; connect to oracle(user=rrimal orapw=XXXXXX path=clrabc); execute( merge into clrabc.TEST_DATA A USING (SELECT * FROM clrabc.tEST_DATA_TWO ) B ON (A.ENCOUNTER= B.ENCOUNTER AND A.MEASURE=B.MEASURE ) WHEN MATCHED THEN UPDATE SET A.VALUE = B.VALUE WHEN NOT MATCHED THEN INSERT (A.ENCOUNTER,A.MEASURE,A.VALUE) VALUES (B.ENCOUNTER,B.MEASURE,B.VALUE) by oracle; disconnect from oracle; quit; But it did not update table test_data. If I run same code inside Oracle it works smoothly. I am wondering if there is a way to fix this issue. following are the demo table Test_data Encounter Measure Value 1 PSI2 1 2 PSI1 1 3 PSI3 1 4 PSI4 1 1 PSI5 1 1 PSI6 1 1 PSI7 1 2 PSI8 1 2 PSI9 1 2 PSI10 1 11 PSI11 1 12 PSI12 1 13 PSI13 1 14 PSI14 1 15 PSI15 1 16 PSI16 1 Test_data_Two Encounter Measure Value 1 PSI2 2 2 PSI1 2 3 PSI3 2 4 PSI4 2 1 PSI5 2 1 PSI6 2 1 PSI7 2 2 PSI8 2 2 PSI9 2 2 PSI10 2 18 PSI11 2 18 PSI12 2 18 PSI13 2 18 PSI14 2 18 PSI15 2 18 PSI16 1 Test Data after update statement 1 PSI2 2 2 PSI1 2 3 PSI3 2 4 PSI4 2 1 PSI5 2 1 PSI6 2 1 PSI7 2 2 PSI8 2 2 PSI9 2 2 PSI10 2 11 PSI11 1 12 PSI12 1 13 PSI13 1 14 PSI14 1 15 PSI15 1 16 PSI16 1 18 PSI11 2 18 PSI12 2 18 PSI14 2 18 PSI13 2 18 PSI16 1 18 PSI15 2 Thanks
... View more