Update with criteria- inner join

[cmemtsa]

Trying to set Column A on Table CONT with value of 1 based on criteria of Column CU on Table CONT and Column Flag on Table CUST.

proc sql;

UPDATE CONT

SET A = 1

WHERE CONT.DATE = CUST.DATE AND CONT.C = CUST.C

AND CUST.FLAG = 'A' AND CONT.CU=1;

QUIT;

[LinusH]

You cannot just refer to different tables in the WHERE caluse, you need to speficy a join somehow.

There are laods of examples on how to this on the internet (this is not a SAS specific task, it's plain SQL).

[PGStats]

You might want to try

proc sql;
UPDATE CONT
SET A = 1
WHERE cu = 1 and 
exists (select * from CUST where date = CONT.DATE AND c = CONT.C and FLAG = 'A');
QUIT;

[cmemtsa]

It worked!!

Thanks a lot!