topic Help with date formats in SAS Programming

Help with date formats

timmy94 — Sun, 18 Aug 2024 11:28:50 GMT

I am trying to convert a date currently in character form to correct format, but my code is changing the date. Could anyone please point out what I am doing wrong?

mthyr_birth (existing data)

Jun2001

Feb1954

Feb1984

My code:

data want;

set have;

mthyr_birth2 = input(mthyr_birth, MONYY.);

format mthyr_birth2 MONYY.;

run;

mthyr_birth2 (output)

JUN20

FEB19

Many thanks

Re: Help with date formats

Astounding — Sun, 18 Aug 2024 12:15:23 GMT

By default, the MONYY uses a width of 5. So the INPUT function is reading only 5 characters. Your data has 7 characters in it, so change MONYY to MONYY7 and you should see better results.

Re: Help with date formats

timmy94 — Mon, 19 Aug 2024 14:10:32 GMT

Thanks so much! 🙂