access SAS from Queryman

[bkj123]

Hello -

I am able to access Teradata through SAS. For example, I can create a SAS dataset by using PROC SQL to hit a Teradata table(s).

Is there a way to access a SAS dataset in Queryman? I'm looking to join a SAS dataset on a unix server to a teradata table.

Thank you. - Brain

 

[teralearner]

Instead of trying to access SAS dataset from Quaryman, you can use SAS teradata engine to create a Teradata table from your SAS dataset in you own permanent space (make use to use proper index to evenly distribute your rows among all AMPs) and join that table with other Tearadata tables.

 

[bkj123]

Thanks teralearner -
Hear what you are saying. I'm trying to avoid creating a permanent table due to limited available space. That's where hitting the dataset would be helpful.

 

[teralearner]

You can use volatile table.
Create a table in your permanent space first, then create a volatile table and insert data from your permanent table. Drop your permanent table. Repeat the steps as many times as needed in a SAS macro loop. Remember you need to do all of the above in one teradata session. I have used this before.

 

[fsnyder]

I know that there is a SAS ODBC driver that would allow applications such as Excel and Queryman to read a SAS dataset using SQL syntax.

You would need to use the documentation from SAS Institute to set this up. Don't know how complicated that is. Good luck.