InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 18:09:36 GMT20http://www.teradata.com/teradataforum/Topic9367-1-1.aspxWow! it worked. Thanks Bobduell..Sun, 09 Mar 2008 23:00:58 GMTOblakhttp://www.teradata.com/teradataforum/Topic9367-1-1.aspxIt's very simple; use PROC SQL. For convenience sake, I create SAS macro variables "terauser" and "terapass" that contain my Teradata login ID and password. I put the macro definitions in my autoexec.sas program (which is read-only to my ID). That way, my code doesn't need to change whenever my password changes.Here's a trivial example to create a SAS dataset containing the Teradata system date:proc sql; connect to teradata (user="&terauser" password="&terapass" mode=TERADATA); create table TERADATA_DATE as select * from connection to teradata ( /* Teradata SQL goes here */ select current_date );quit;The "from connection to teradata" structure is part of the FROM component of the SELECT statement and means to submit everything between the parentheses to Teradata.To run a Teradata SQL statement that does not return a result (like CREATE TABLE or COLLECT STATISTICS), use the SAS "execute" statement:proc sql; connect to teradata (user="&terauser" password="&terapass" mode=TERADATA); execute ( collect statistics on mydb.mytable index (myindex) ) by teradata;quit;Wed, 24 Oct 2007 14:50:24 GMTbobduellhttp://www.teradata.com/teradataforum/Topic9367-1-1.aspxAnybody who knows how to do a pass through statement from SAS to Teradata?Tue, 23 Oct 2007 23:41:21 GMTOblak