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.
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;
WHERE ID IN (SELECT ID FROM TABLEB WHERE AMOUNT LE 0); QUIT;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: