Not null variable produces Null values

David_Billa — Wed, 12 Feb 2020 09:32:01 GMT

I'm loading the data from SAS to SQL table via SCD type 2 loader. There are two fields which are defined as Null in SQL but after loading I could see the Null values. These two fields are not Primary key in SQL and it is under 'Detect changes' in SCD type 2 from SAS.

May I know what might be the potential cause for this issue?

Re: Not null variable produces Null values

Patrick — Wed, 12 Feb 2020 10:20:55 GMT

"There are two fields which are defined as Null in SQL but after loading I could see the Null values."

What does that mean? There had been blanks instead of NULL? Or the SCD2 loader loaded a change record even though nothing changed?

SAS not having a concept of NULL will make things really hard. The md5 digest value gets created on the SAS side so I would assume that a change from blank to NULL (or the other way round) wouldn't create a change record as for SAS it's both times a blank.

How a missing/blank then gets inserted into the DB (as blank or as NULL) will depend on your option settings (NULLCHAR, NULLCHARVAL).

topic Re: Not null variable produces Null values in SAS Programming

Not null variable produces Null values

Re: Not null variable produces Null values