Posted by: MN_Nepali December 1, 2008
SAS Indian Consultancy
Login in to Rate this Post:     0       ?        

 

lonelyguy

Teradata and SAS goes hand in hand in corporate structures.

SAS does the data manipulation and Teradata holds the data.

In general cases all you need to know is how to get the data from teradata and how to upload data into teradata.

There are two ways of connecting to teradata.

1) Implicit connection and (using a libname),

2) Explicit connection (using proc sql),

1) Implecit is the one when you declear a libname and make the connection.

 libname test teradata user=sas_usr password="XXXXXX" database=SALES server=tdProod;

data xx.SAS_data_from_teradata;

set test.SAS_data_from_teradata;

RUN;

2) Explicit connection,

libname xx 'a:\atupadhy';

proc sql;

connect to teradata as b(user=sas_usr password="XXXXXX" database=SALES  server=tdProod);

create table xx.abcd as

select * from connection to b (select

c.xxx,

c.yyy,

d.abc,

 

from KKK c, SSSS d

where c.xxx=d.xxx);

disconnect  from b;

quit;

 

Also you can use the same to upload data into a teradata (assuming you have the right privileges)

Read this document for more info. AND, lastly, Oracle connection is almost same as teradata.

http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_teradata_7370.pdf

Thx

 

Read Full Discussion Thread for this article