I am trying to build a simple conversion table so that I can easily convert my data into date, working day, period, month, year, etc...whenever I want.
It is simply the above headings with their associated values, created in Excel. The plan was to turn it into a SAS dataset, however it's not working.
When I open my table in EG 'month&year' (mmmyy) and 'date' (ddmmyy) are being converted into datetimes (I understand why this happens). I have used the DATEPART function to split the numbers but it is not producing the correct results, i.e. 1st Sep 09 is giving me a date from 1949!!!
Any ideas?