how to join SAS table with teradata

mrdlau — Wed, 14 Mar 2018 04:15:51 GMT

I'm using SAS to query for data located in Teradata, but I want to filter my data based on a SAS table. how would I be able to do this? I only have read-access to the teradata, so I'm unable to move my SAS table to Teradata.

My end result would be something like:

Proc SQL;

SELECT *
FROM Teradata_Table T1
WHERE T1.Name in (SELECT Names from SASTable T2);
Quit;

I read something about volatile table, but I'm still new to teradata and SAS so I dont quite understand the syntax to make it happen.

Re: how to join SAS table with teradata

error_prone — Wed, 14 Mar 2018 07:17:37 GMT

What happens when you execute the syntax you posted?

Re: how to join SAS table with teradata

ChrisNZ — Wed, 14 Mar 2018 07:45:19 GMT

how many records in T2?

topic how to join SAS table with teradata in SAS Programming

how to join SAS table with teradata

Re: how to join SAS table with teradata

Re: how to join SAS table with teradata