topic Re: The SAS Based "The Link King" in New SAS User

The SAS Based "The Link King"

Ihsan-Mahdi — Thu, 22 Jun 2023 20:41:31 GMT

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!

Re: The SAS Based "The Link King"

ballardw — Thu, 22 Jun 2023 21:00:51 GMT

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?

Re: The SAS Based "The Link King"

Ihsan-Mahdi — Thu, 22 Jun 2023 21:29:53 GMT

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:)

Re: The SAS Based "The Link King"

Ihsan-Mahdi — Thu, 22 Jun 2023 21:30:36 GMT

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