update a column based on a column in another table
in [SAS]
|
Prev: update a column based on a column in another table
Next: dsread - Windows command-line utility for SAS7BDAT files
From: SAS User on 25 Feb 2010 08:38 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
From: montura on 25 Feb 2010 09:06 Two operations. Perform the join first. Then perform the update.
From: Tom Abernathy on 25 Feb 2010 13:42
Data new; merge a b(keep=col2 col1); by col2; run; On Feb 25, 8:38 am, SAS User <sasuser2...(a)googlemail.com> wrote: > 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 |