Just what does a "Policy_vintage" value of 3328-12 mean? Typically, and from the axis of the first graph, that might mean year 3328 with a months of December. So, what policy do you have that a date in 3328????
I suspect that somewhere along the line you have some values that are not dates being treated as such or possibly you are aggregating dates (sum or similar) so that you create values that are way of your expected range.
I have no idea why it shows this date and that's the problem.
Do you actually LOOK in the data set named DIFF_POLICY_ACT with your own eyes and see what is in there? Can you show us this data set (screen capture is fine)? You can do some debugging yourself.
Did you try the suggestion by @Reeza to run PROC FREQ on this data set both with and without the formats? What happened?
Please don't ignore the suggestions people make for debugging this.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.