topic Re: How to convert 8w. format to mmddyyw. format? in SAS Programming

How to convert datew. format to mmddyyw. format?

takpdpb7 — Mon, 27 Jul 2020 18:32:10 GMT

For example: I have the original DOB as '01JAN2020'. I would like to convert it to '01/01/2020'

Re: How to convert 8w. format to mmddyyw. format?

PaigeMiller — Mon, 27 Jul 2020 18:35:21 GMT

Do you mean you have a character variable DOB which appears as 01JAN2020?

num_date=input(dob,date9.);
format num_date ddmmyys10.;

Or do you mean you have a numeric variable that displays as 01JAN2020?

format dob ddmmyys10.;

Re: How to convert 8w. format to mmddyyw. format?

Kurt_Bremser — Mon, 27 Jul 2020 18:32:16 GMT

It seems that your DOB is already a SAS date variable, with a DATE9. format. If that is the case, just change the format to MMDDYY10. or DDMMYY10. (depending on which order you want displayed).

Re: How to convert 8w. format to mmddyyw. format?

Tom — Mon, 27 Jul 2020 18:34:55 GMT

@takpdpb7 wrote:

For example: I have the original DOB as '01JAN2020'. I would like to convert it to '01/01/2020'

Do you have a character variable or a numeric variable? (SAS only has two types.)

If you have a numeric variable change the format attached to have it displayed in the different way.

format dob mmddyy10.;

If you have a character variable then convert it to a date value first.

dob = put( input(dob,date9.) , mmddyy10.);

Note: I assumed that the first 01 is the MONTH. Others might assume it is DAY. That is why you should use either DATE9. or YYMMDD10. format instead of MMDDYY10. or DDMMYY10. to avoid that confusion.

Re: How to convert datew. format to mmddyyw. format?

mklangley — Mon, 27 Jul 2020 18:35:20 GMT

data have;
    sas_date = '01JAN2020'd;
    dob = sas_date;
    dob2 = sas_date;
    format dob date9.
           dob2 mmddyys10.;
run;