how to join SAS table with teradata

[mrdlau]

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.

[error_prone]

What happens when you execute the syntax you posted?

[ChrisNZ]

how many records in T2?