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
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?
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.