topic Re: Updating a column based on a join from a column on another table in SAS Programming

Updating a column based on a join from a column on another table

LeeJenson — Thu, 25 Feb 2010 13:34:29 GMT

Hi,
I don't mind if the solution is in PROC SQL or datastep but I am
struggling with how to do this:-

a=tablea
b=tableb

update tablea
set a.col1 = b.col1
where a.col2 = b.col2

Regards
Lee Message was edited by: Lee2010

Re: Updating a column based on a join from a column on another table

sbb — Thu, 25 Feb 2010 13:47:14 GMT

One option: a DATA step using properly sorted input and a MERGE with a BY statement.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument, this topic/post:

merge processing site:sas.com

Re: Updating a column based on a join from a column on another table

LeeJenson — Thu, 25 Feb 2010 15:22:41 GMT

Thanks Scott

the merge worked fine.

Lee