how do you add zeros to dates when reading in file? For example the file i am reading has dates as 201433 should be 20140303 or 2014133 should be 20141303 or 2013313 should be 20140313
What will you do with 2014111 ?
I would say that you can't. You will probably need to get additional information to help decide.
You might say that 201433 could only be divided into 2014-3-3, but perhaps the missing digit is a 1 or a 2 instead of a 0. Then the intended value could be 2014-03-13 or 2014-03-23. Or perhaps the 4 is the typo and it is really in ddmmyy format so that the intended value is really 1933-12-20.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.