Help using Base SAS procedures

reading dates that has supressed zeros

Reply
Contributor
Posts: 20

reading dates that has supressed zeros

 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

Contributor dkb
Contributor
Posts: 53

Re: reading dates that has supressed zeros

What will you do with 2014111 ?

Super User
Super User
Posts: 7,059

Re: reading dates that has supressed zeros

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.

 

Ask a Question
Discussion stats
  • 2 replies
  • 243 views
  • 0 likes
  • 3 in conversation