Hi I am extracting data from a SQL Server table, loading it into SAS and performing some lookups, and then loading it into another SQL Server table in a different schema. The problem I have is that some of the character values are blank in the source table, but when SAS loads it into the target table, the blanks are loaded as NULL. I know this is because SAS treats blanks as NULLs, but is there a way to preserve the blank values when loading back into SQL Server? I.e. if the source data is NULL I want to load NULL, but if it is blank I want to load blank. Thanks!
... View more