Append blank values in SQL server instead of Null

[shiv999]

Hello SAS ppl
I am trying append the data in sql server using sas.
I was using below libname passthrough for appending the data. But while appending all the blank columns are converting into NULL in sqlserver.

I see we can use NULLChar = SAS|YES |NO
But I am not able to get them properly can some one please help.

How I can use this NULLCHAR ?


Libanme sqlserver ODBC DSN =XXXXX SCHEMA =XXXXX UID=XXXX PWD=XXXX IGNORE_Read-only_column= YES INSTERBUFF= 10000;

PROC APPEND BASE = sqlserver.table_want data=inputdata ;
Run

[JosvanderVelden]

Does the answer:
SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Fifth Edition (nullchar=no)
from @jakarman help?
https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=acreldb&docsetTarget=n1hm...