06-26-2015 10:22 AM
You need to define a format for yourself .
format a fmt12.
06-26-2015 10:35 AM
Alternatively just create a text field:
length new_date $10;
06-26-2015 12:11 PM
Is your date really a character variable? If so, I would urge you to convert it into a SAS date value first.
If your date is stored as a SAS date value, RW9's solution won't work without additional coding. If it is a character value, then you won't be able to do any calulations with it without code to do that transformation to a SAS date value. Xia's solution is the easiest way of dealing with the fact that SAS does not have every possible date format available. Only change I would make is I would use a more descriptive format name than "fmt".
IMHO, there is no reason to represent a date as a character variable in a SAS table or view, UNLESS you are dealing with complex ISO8601 dates and need to calculate ISO durations and intervals using CALL IS8601_CONVERT.