topic Re: PROC SQL - UPDATE in SAS Programming

PROC SQL - UPDATE

scb — Fri, 17 Feb 2017 02:51:20 GMT

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 — Fri, 17 Feb 2017 03:04:21 GMT

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 — Fri, 17 Feb 2017 03:05:59 GMT

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