topic Re: Update with criteria- inner join in New SAS User

Update with criteria- inner join

cmemtsa — Wed, 09 Jan 2019 12:53:24 GMT

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 — Wed, 09 Jan 2019 15:18:04 GMT

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 — Wed, 09 Jan 2019 15:49:03 GMT

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 — Thu, 10 Jan 2019 06:44:15 GMT

It worked!!

Thanks a lot!