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?