Help using Base SAS procedures

proc sql update statement

Accepted Solution Solved
Reply
Contributor
Posts: 23
Accepted Solution

proc sql update statement

Attempting to update a field in my table that requires a join from another table as such:

proc sql;

update work.table_01 as t1

set t1.region = 'North'

from work.table_01 as t1 inner join work.table_02 as t2 on t1.ID = t2.ID

where

t2.state in ('PA');

quit;

Received errors in the from clause and also read that SAS does not recgonize joins in the update statement.  Is there another way to write this proc sql or maybe adding a sub query (not sure where in the code) to get this to work?  If someone can provide an example based on above, that would be great as well.

Thanks in advance


Accepted Solutions
Solution
‎03-12-2015 06:18 PM
Respected Advisor
Posts: 4,646

Re: proc sql update statement

Not always easy to do UPDATEs in SAS/SQL. But in this case, it is quite simple:

proc sql;

update table_01

set region = 'North'

where ID in (select ID from table_02 where state in ('PA'));

quit;

PG

PG

View solution in original post


All Replies
Solution
‎03-12-2015 06:18 PM
Respected Advisor
Posts: 4,646

Re: proc sql update statement

Not always easy to do UPDATEs in SAS/SQL. But in this case, it is quite simple:

proc sql;

update table_01

set region = 'North'

where ID in (select ID from table_02 where state in ('PA'));

quit;

PG

PG
Contributor
Posts: 23

Re: proc sql update statement

That did the trick! Thank you very much =D

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 346 views
  • 0 likes
  • 2 in conversation