access sas dataset through 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. - Brian

 

[klaz2002]

bkj123,
I can't give you an answer as I do not have SAS on UNIX & no access to a teradata file. But I can give you some places to start.

http://gsbwww.uchicago.edu/computing/research/SASManual/accdb/znid-540.htm

(This is just the SASdocs also available on

http://v8docs.sas.com/sashtml

)
I hope that this helps you.
Klaz

 

[ChrisW75]

I would say almost certainly not. SAS can see the Teradata data because a link is set up and it uses the correct protocol to talk to the remote system, I've never heard of any other system being able to read SAS datasets (but then, I've never tried).
The real question is though "What are you trying to achieve?"
You should be able to join a SAS dataset to a Teradata table using SAS, and, if you want the hard work done by Teradata, you can do this too. Look up the DBKEYS and DBNULLKEYS options in the SAS documentation which KLAZ has linked above, these can help you to optimise the queries, pushing some of the work back to the DBMS.
As an example

Proc sql;
create table test as
select *
from teradat.table1(dbkey=person_id dbnullkeys=NO) as tab1
,sassys.table2 as tab2
where tab1.person_id = tab2.persn_cd
;
quit;

This will do your join, but will actually use the persn_cd field to extract only the matching rows from the remote table, the DBKEY option telling the DBMS what key to use on the table. If you don't use this option, it will extract EVERYTHING from the teradata table and then join it to your SAS dataset. This is supposed to be most efficient for "small" SAS datasets joining to "large" DBMS tables.

 

[klaz2002]

ChrisW75,
I have had a sas dataset 'exposed', read by another app. This can be done by using the existing ODBC driver that ships with SAS for windows. I would guess that the equiv is available for a non-windows environment too.
Klaz