PROC SQL - UPDATE

[scb]

Any idea to correct the syntax below?

PROC SQL;
UPDATE TABLEA
SET NAME='',ACCOUNT=''
WHERE ID =(SELECT ID FROM TABLEB WHERE AMOUNT LE 0);
QUIT;

I GOT THIS ERROR MESSAGE: ERROR: Subquery evaluated to more than one row.

Many Thanks.

[LaurieF]

Without having the data to prove the code on, this might work:

PROC SQL;
UPDATE TABLEA
SET NAME='',ACCOUNT=''
WHERE ID in(SELECT distinct ID FROM TABLEB WHERE AMOUNT LE 0);
QUIT;

[Ksharp]

WHERE ID  IN  (SELECT ID FROM TABLEB WHERE AMOUNT LE 0);
QUIT;