I created a Teradata table with a data step in SAS EG, but can't see the new table under libraries even after I refresh. According to the SAS log, the table is created with the expected number of observations and variables. I also do not see the new table when I attempt to view it using Teradata SQL Assistant. Has anyone else experienced this issue? Please advise. Thanks.
libname tlibrary teradata server='ABC.XYZ.COM' connection=global dbmstemp=yes database="ABC_TST" user="a12345@LDAP" pwd="XXXXXX" mode=Teradata;
data tlibrary.new_t_table;
set ds1 ds2 ds3;
run;
Try to add option SCHEMA= in libname statement .
The following code could check Schema.
proc sql; connect to teradata(database="ABC_TST" user="a12345@LDAP" pwd="XXXXXX") ; select * from connection to teradata(teradata::SQLTables) ; quit;
Did you intend to create a volatile table in Teradata? It is not clear to me that the SAS tools to show lists of datasets in a library will work to show volatile tables in a Teradata session. Try using the Teradata command HELP VOLATILE TABLE to see what volatile tables exist in your session.
proc sql ;
connect using tlibrary ;
select * from connection to tlibrary (help volatile table);
quit;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.