Currently, I work with SAS and teradata. I notice, we have two possibilities to connect SAS to teradata. One possibility is to create a remote library. The definition is:
libname Td_direc teradata tdpid ="127.0.0.1" user="tduser" password="tduser" database="financial";
Another possibility is to create an explicit connection:
proc sql;
connect to teradata as td(tdpid="127.0.0.1"
user="tduser"
password="tduser"
database="financial");
create table work.dataX as
select *
from connection to td
(select * from dataX);
quit;
This explicit connection can also be used to create a table on teradata:
proc sql;
connect to teradata as td(tdpid="127.0.0.1"
user="tduser"
password="tduser"
database="financial");
execute
(create table dataY(x integer, y integer))
by td;
execute(commit work) by td;
quit;