05-24-2017 09:01 AM
Step one, test from a non-SAS client on the same machine. Like Excel.
Then there can be tons of reasons: authorization, source table names not comply with SAS naming conventions (table names longer than 32 char as an example).
Also, check with the DBA if they can spot any messages during your access.
Can you perform an explicit SQL pass through?
05-25-2017 04:05 AM
So how did you create this? In code, in SAS Management Console, or some other means? Without details of how you set this up we can only guess what might be wrong.
05-26-2017 06:03 AM