Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Syntax error updating a table with a Join
Hey Sasbuddy, Looks like you are the confused one, I am using proc sql (pretty obvious I thought) and I am using update, also pretty evident from the line "update bell.ldbase2011". I think the error is a bug - this is SAS9.2.- LongerSAS
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Syntax error updating a table with a Join
This is driving me crazy, why is the following code: update bell.ldbase2011 set FORBEARANCE_IND = FORBEARANCE_IND FROM bell.forbearance2 AS f left join bell.ldbase2011.FORBEARANCE_IND AS b ON f.ACCT_ID = b.ACCT_ID Give me an error in the log: 1544 update bell.ldbase2011 k...- LongerSAS
- Thread
- Replies: 2
- Forum: SAS Institute, Inc. solutions
