topic Re: mmdy format in New SAS User

mmdy format

Aayushi_17 — Thu, 05 May 2022 07:13:05 GMT

Hi ,

How to convert the date if it is month and day format for eg.

Date	Required output
19 APR	04-19

how to get the required output.

Thanks in advance

Re: mmdy format

andreas_lds — Thu, 05 May 2022 07:58:06 GMT

Afaik there is no format displaying month and day. Check the docs about picture formats, i am sure that such a format could be created.

Re: mmdy format

Kurt_Bremser — Thu, 05 May 2022 08:27:26 GMT

So you do have a string consisting of two parts, separated by a blank, the first part the numeric day of a month, the second the month name in capitals?

Since you do not have a date (because the year is missing), you first need to add a year (which is unimportant), so you can then use a custom picture format:

proc format;
picture mdd
  low-high = '%0m-%0d' (datatype=date)
;
run;

data test;
have = "19 APR";
want = put(input(compress(have)!!"2022",date9.),mdd.);
run;

proc print data=test noobs;
run;

Result:

have	want
19 APR	04-19

Re: mmdy format

Aayushi_17 — Thu, 05 May 2022 08:48:31 GMT

Thank you thats working