https://communities.sas.com/t5/SAS-Programming/reading-in-dates-with-supressed-zeros/m-p/232997#M42508 <P>If this is the case, you are having a dirty data problem beyond any programming can fix. First, make sure your data is YYYYMMDD or YYYYDDMM. Then Consider this: 2015111. Is it 20150111 or 20151101?</P> Tue, 03 Nov 2015 23:33:31 GMT Haikuo 2015-11-03T23:33:31Z https://communities.sas.com/t5/SAS-Programming/reading-in-dates-with-supressed-zeros/m-p/232992#M42503 <P>how do you add zeros to dates when reading in file?&nbsp; For example the file i am reading has dates as <STRONG>201433</STRONG> should be 20140303 or <STRONG>2014133</STRONG> should be 20141303 or <STRONG>2013313</STRONG> should be 20140313</P> Tue, 03 Nov 2015 22:45:33 GMT https://communities.sas.com/t5/SAS-Programming/reading-in-dates-with-supressed-zeros/m-p/232992#M42503 myboys2 2015-11-03T22:45:33Z https://communities.sas.com/t5/SAS-Programming/reading-in-dates-with-supressed-zeros/m-p/232997#M42508 <P>If this is the case, you are having a dirty data problem beyond any programming can fix. First, make sure your data is YYYYMMDD or YYYYDDMM. Then Consider this: 2015111. Is it 20150111 or 20151101?</P> Tue, 03 Nov 2015 23:33:31 GMT https://communities.sas.com/t5/SAS-Programming/reading-in-dates-with-supressed-zeros/m-p/232997#M42508 Haikuo 2015-11-03T23:33:31Z https://communities.sas.com/t5/SAS-Programming/reading-in-dates-with-supressed-zeros/m-p/233114#M42545 <P>At this point the question is can you go to the data source and have them clean up the dates, either provide the leading 0 as needed or separate year, month and day columns.</P> Wed, 04 Nov 2015 16:45:54 GMT https://communities.sas.com/t5/SAS-Programming/reading-in-dates-with-supressed-zeros/m-p/233114#M42545 ballardw 2015-11-04T16:45:54Z