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.
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
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.