The SAS Based "The Link King"

[Ihsan-Mahdi]

Hello. I'm using the Link King to link two data sets together. When importing my matching set I keep getting a warning that I have over 35 K records with missing date of birth values, which is not the case! My date of birth variable is a string formatted as YYYYMMDD. Anyone knows why this is happening and how to fix it?

Thank you!

[ballardw · Accepted solution]

Not familiar with "The Link King".

This however " date of birth variable is a string formatted as YYYYMMDD" is something to consider. If the program wants actual date values then perhaps you need to take a pass through the data to make sure the strings are converted to SAS date values.

By any chance does the "35 K records with missing date of birth values" correspond with how many records you have in the set, i.e. about 35 K total records?

[Ihsan-Mahdi]

Thank you so much for responding. I created a new numeric date of birth variable and formatted it YYMMDD10. and it worked! You are right, using a string DOB variable probably wasn't the best option.

I'm very grateful for this community, you guys are awesome:)

[Ihsan-Mahdi]

To answer your question, No, my total records are close to 1 M.