topic Re: Month/Year to Date Conversion and Display in SAS Programming

Month/Year to Date Conversion and Display

kamlesh_suthar — Wed, 13 Jun 2018 12:16:33 GMT

Hi there,

I am trying to convert character formatted date which look like OCT2017_Default to date formatted OCT2017.

Thanks in advance.

Re: Month/Year to Date Conversion and Display

Kurt_Bremser — Wed, 13 Jun 2018 12:16:10 GMT

Use the monyy informat/format:

data _null_;
date_str = "OCT2017_Default";
date_num = input(date_str,monyy7.);
format date_num monyy7.;
put date_num=;
run;

And use a more descriptive subject next time. "Base SAS" in the "Base SAS Programming" community is not showing off a lot of creativity, to be very polite.

Re: Month/Year to Date Conversion and Display

PaigeMiller — Wed, 13 Jun 2018 12:35:49 GMT

I did not know that the MONYY7. format would exclude the part of the text string that is '_Default', I thought this would cause the conversion to fail.

Learn something new every day!

Re: Month/Year to Date Conversion and Display

Kurt_Bremser — Wed, 13 Jun 2018 12:38:35 GMT

This seems to be a feature of numeric informats, they only use the number of characters specified:

data _null_;
num_str = "1234567some_garbage";
num_num = input(num_str,7.);
put num_num=;
run;

Re: Month/Year to Date Conversion and Display

PaigeMiller — Wed, 13 Jun 2018 12:43:51 GMT

So this fails, as I would have expected

num_num = input(num_str,8.);