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!
Search results for query: *
- Users: bpowell555
- Order by date
-
SAS Proc SQL UPDATE problem!
I got that same error message. It appears you can only use UPDATE with one table as it won't take a comma to list a second table and if you list a second table name separated by a space then that will behave as an alias. Obviously for SQL UPDATE it is sometimes necessary to refer to more than...- bpowell555
- Post #4
- Forum: SAS Institute, Inc. solutions
-
How to update one field from other table
Proc SQL Update will only allow you to work with 1 table apparently - this is a poor limitation if I'm right! - although I know there are any number of alternative methods like that above, cheers,- bpowell555
- Post #5
- Forum: SAS Institute, Inc. solutions
-
SAS Proc SQL UPDATE problem!
I think I know the answer: you can't. I'll have to try and manipulate a merge or data step update, cheers, :-(- bpowell555
- Post #2
- Forum: SAS Institute, Inc. solutions
-
SAS Proc SQL UPDATE problem!
I've been struggling with this for a couple of days as a relative SAS developer newbie - this is my first 1000 lines of code ;-) I can't update more than one table!?! I've tried copied the syntax over from Access and no chance. I've fiddled with everything and can't get it to go. It won't take...- bpowell555
- Thread
- Replies: 3
- Forum: SAS Institute, Inc. solutions
