11-08-2012 01:10 PM
I have a data set (data_set11) where the format of a variable (Decision_Date) is: 26NOV2010:00:00:00.000.
I would like to change it to 2010/11/26 AND extract the month (11).
11-08-2012 01:28 PM
The value example you display means the variable is likely a DATETIME variable unless it is character, in which formats won't help a lot.
If it is datetime, there are limited SAS supplied formats but E8601DA10. or E8601DN10. come closest depending on whther you want single digit months and days to appear with a leading 0. There will be - instead of /
Or convert it to an actual date as Decision_date= datepart(Decision_date);
If you want a new variable then
month=month(datepart(Decision_date)); If you converted it to a date as above then
11-08-2012 02:55 PM
If you want to change your date directly to month, this is the code.