Desktop productivity for business analysts and programmers

How to change de format of a SAS DATE

Reply
New Contributor
Posts: 3

How to change de format of a SAS DATE

Hi everyone,

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).

Thank you

Grand Advisor
Posts: 10,241

Re: How to change de format of a SAS DATE

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

month= month(Decision_date);

Occasional Contributor
Posts: 12

Re: How to change de format of a SAS DATE

Hi Dominic,

If you want to change your date directly to month, this is the code.

data one;

input date:datetime22.;

Month_of_your_date=month(datepart(date));

datalines;

26NOV2010:00:00:00.000

;

run;

Ask a Question
Discussion stats
  • 2 replies
  • 348 views
  • 0 likes
  • 3 in conversation