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?
"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).
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.