https://communities.sas.com/t5/SAS-Programming/Append-blank-values-in-SQL-server-instead-of-Null/m-p/725763#M225499 Hello SAS ppl<BR />I am trying append the data in sql server using sas.<BR />I was using below libname passthrough for appending the data. But while appending all the blank columns are converting into NULL in sqlserver.<BR /><BR />I see we can use NULLChar = SAS|YES |NO<BR />But I am not able to get them properly can some one please help.<BR /><BR />How I can use this NULLCHAR ?<BR /><BR /><BR />Libanme sqlserver ODBC DSN =XXXXX SCHEMA =XXXXX UID=XXXX PWD=XXXX IGNORE_Read-only_column= YES INSTERBUFF= 10000;<BR /><BR />PROC APPEND BASE = sqlserver.table_want data=inputdata ;<BR />Run Fri, 12 Mar 2021 11:39:59 GMT shiv999 2021-03-12T11:39:59Z https://communities.sas.com/t5/SAS-Programming/Append-blank-values-in-SQL-server-instead-of-Null/m-p/725763#M225499 Hello SAS ppl<BR />I am trying append the data in sql server using sas.<BR />I was using below libname passthrough for appending the data. But while appending all the blank columns are converting into NULL in sqlserver.<BR /><BR />I see we can use NULLChar = SAS|YES |NO<BR />But I am not able to get them properly can some one please help.<BR /><BR />How I can use this NULLCHAR ?<BR /><BR /><BR />Libanme sqlserver ODBC DSN =XXXXX SCHEMA =XXXXX UID=XXXX PWD=XXXX IGNORE_Read-only_column= YES INSTERBUFF= 10000;<BR /><BR />PROC APPEND BASE = sqlserver.table_want data=inputdata ;<BR />Run Fri, 12 Mar 2021 11:39:59 GMT https://communities.sas.com/t5/SAS-Programming/Append-blank-values-in-SQL-server-instead-of-Null/m-p/725763#M225499 shiv999 2021-03-12T11:39:59Z https://communities.sas.com/t5/SAS-Programming/Append-blank-values-in-SQL-server-instead-of-Null/m-p/725773#M225506 Does the answer:<BR />SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Fifth Edition (nullchar=no)<BR />from <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/9411">@jakarman</a> help?<BR /><A href="https://documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.5&amp;docsetId=acreldb&amp;docsetTarget=n1hmopc3y74oy2n1svhu03pfoiy9.htm&amp;locale=en" target="_blank">https://documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.5&amp;docsetId=acreldb&amp;docsetTarget=n1hmopc3y74oy2n1svhu03pfoiy9.htm&amp;locale=en</A> Fri, 12 Mar 2021 12:50:51 GMT https://communities.sas.com/t5/SAS-Programming/Append-blank-values-in-SQL-server-instead-of-Null/m-p/725773#M225506 JosvanderVelden 2021-03-12T12:50:51Z