You know what...today we completed an upgrade in our SAS environment (specifically, how we connect to Teradata) and this option magically started working. So I think the syntax I was using was correct, and it was some configuration issue then. Thanks to all. ... View more

Ksharp wrote: After check the documentatin about Teradata. To control how SAS missing character values are handled by Teradata, use the NULLCHAR= and NULLCHARVAL= data set options. Yes, those are the options I'm trying to use - but I can't get them working, unless I'm using NULLCHAR incorrectly. ... View more

Hmmm...I'm not sure what you mean by looking at the Teradata table. My libname statement looks like this if that's what you mean: libname td teradata user="&username." password="&password." database="&db." server="&servername" logdb=spool_reserve; What my script is doing: 1. Create a SAS data set using passthrough SQL to Teradata 2. Delete all data from the Teradata target table 3. Insert the data set to the Teradata target using the SAS in my first post I was hoping the NULLCHAR option would convert the missing values to NULLs on the 3rd step - I should say I'm open to other ways of accomplishing this. (Doesn't have to be NULLCHAR!) More code below - does that help? Thanks again for your help. proc sql;    connect to teradata (user="&username" password="&password" database="&db" server="&servername" mode=teradata);    CREATE table mydataset as    select * from connection to teradata (     SELECT yada yada yada from various tables disconnect from teradata; quit; proc sql;    connect to teradata (user="&username" password="&password" database="&db" server="&servername" mode=teradata);    execute(delete from "&database.".mytable) by teradata; quit;  proc append base=td.mytable (nullchar=yes fastload=yes TPT=yes TPT_MAX_SESSIONS=8 TENACITY=6 SLEEP=1)    DATA=mydataset force; run; ... View more