LIBNAME tera TERADATA SERVER=myserver USER=myuser PASSWORD=mypass ; options dbidirectexec; options msglevel=i; options sastrace=',,,d' sastraceloc=saslog; *options sql_ip_trace=all; /* DROP OUTPUT TABLE */ proc sql; drop table tera.class1107; *drop table tera.class1107_out; drop table tera.myobs; drop table mysasobs; quit; data tera.class1107; set sashelp.class; run; /* You get only 5 rows here when creating a SAS dataset from a Teradata table */ proc sql inobs=5; create table mysasobs as select * from tera.class1107; quit; proc sql ; select * from mysasobs; quit; /* You will not get 5 rows here when creating a Teradata table from another Teradata table */ proc sql inobs=5; create table tera.myobs as select * from tera.class1107; quit; proc sql; select * from tera.myobs; quit;