libname test teradata server=myteradataserver user=myuser password=mypass;

proc sql;
drop table test.vc_class;
quit;

data test.vc_class (dbtype=(name='varchar(40)')); set sashelp.class;
run;

/* this LIBNAME when submitted will cause the problem in the SQL pass-through code below */

options remote=local sascmd="!sascmd";
   signon local;
   libname rwork slibref=work server=local;

/* non pass-through code works fine to this table, the name field is not blank*/

proc sql;
create table mytable as
select * from test.vc_class;
quit;

proc print data=mytable;
format name $hex32.;
run;

/* sql passthru to teradata with remote library, the varchar name field is blank */

libname rwork clear;
run;

proc sql;
connect to teradata ( server=myteradataserver user=myuser password=mypass);
create table work.myvarchar as
select * from connection to teradata 
(
select * from vc_class
);
disconnect from teradata;
quit;

proc print data=work.myvarchar;
format name $hex32.;
run;