Agreed on switching to a single value vs split. Not sure why it would be split, actually.
One clarification to the above posts. SAS does not have a 'date' value. It only understands characters and numbers. It can interpret a number as a date but it has no idea if something is a date or a number until you tell it.
Today, as a date for example, is 22194 which is the number of days since Jan 1, 1960. If you constrain a value between a certain range, 10000-20000 say, you will get the numbers needed to display dates in that range. If you want to add a day, add 1.
See: http://dictionary.sensagent.com/epochal%20date/en-en/
... View more