Hi All, I tried to create a temporary table in teradata but coulnd't succeed. I want to create a temporary table in teradata for the result of the proc sql query in SAS EG. Proc sql; connect to teradata(user=user password=password server=servername database=databasename); create table test_1 as select * from connection to teradata (select Cust.UNIQUE_ID,IP.IP_NAME from temIP as IP inner join temCUST as Cust on IP.IP_ID = Cust.CUST_ID); disconnect from teradata; quit; In the above example i created a sas dataset test_1 which holds the results of the sql query. Instead of sas dataset I want to create a temporary table in teradata and use the same in other sql queries. how can I create it? Your suggestions would be of great help.Thank You.
... View more