DATA Step, Macro, Functions and more

how to join SAS table with teradata

Reply
Contributor
Posts: 36

how to join SAS table with teradata

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.

 

Regular Contributor
Posts: 195

Re: how to join SAS table with teradata

What happens when you execute the syntax you posted?
PROC Star
Posts: 2,215

Re: how to join SAS table with teradata

how many records in T2?

Ask a Question
Discussion stats
  • 2 replies
  • 83 views
  • 0 likes
  • 3 in conversation