06-25-2015 03:51 PM
I have dates stored in character format. They look like - "15Jul2014". I need to convert it into 2014-Jul-15 i.e. YYYY-MMM-DD . Is there any easy way to convert it?
Thanks in anticipation!
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.