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