Regarding the passthru issue, the suggestion I just asked Chris to post would be the way to get it to work if you were NOT using explicit passthru. That is, having a separate library setup each of which could access the tables you want to use.
I believe if you are using passthru you would need to actually connect with the user id which is the owner or else has the correct default schema (depending on which database you are working with).
I think there should be a way for you to get it to work unless you are trying to join data from different owners/schemas. But in any case if you're unable to get your example to work by altering the login, then please contact SAS Technical Support and we'll track the issue.
... View more