topic reading dates that has supressed zeros in SAS Procedures

reading dates that has supressed zeros

myboys2 — Tue, 03 Nov 2015 22:34:55 GMT

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

Re: reading dates that has supressed zeros

dkb — Wed, 04 Nov 2015 00:05:52 GMT

What will you do with 2014111 ?

Re: reading dates that has supressed zeros

Tom — Wed, 04 Nov 2015 01:15:20 GMT

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.