BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Ihsan-Mahdi
Obsidian | Level 7

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!

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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?

View solution in original post

3 REPLIES 3
ballardw
Super User

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
Obsidian | Level 7

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
Obsidian | Level 7
To answer your question, No, my total records are close to 1 M.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

From SAS Users blog
Want more? Visit our blog for more articles like these.
5 Steps to Your First Analytics Project Using SAS

For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 194 views
  • 1 like
  • 2 in conversation