topic Re: How to convert character date yyyy mm to SAS date in SAS Programming

How to convert character date yyyy mm to SAS date

rmlailer — Wed, 27 Oct 2021 19:59:36 GMT

I have a character date column that I am trying to convert to a SAS date in the format monyy7.

How would I do that?

Reeza — Wed, 27 Oct 2021 20:41:41 GMT

input(compress(date), yymon7.)

Then apply a format to display it as a date.

Ksharp — Thu, 28 Oct 2021 11:48:18 GMT

data have;
input have $20.;
want=input(catx(' ',have,'01'),anydtdte32.);
format want yymon7.;
cards;
2020 APR
2020 AUG
;