topic Date Conversion in SAS Programming

Date Conversion

JillChen0131 — Mon, 07 Mar 2022 20:33:24 GMT

I have some dates in character format:

UN/UNK/2020

14/JUN/2021

UN/APR/2019

I would need to convert them to the format yyyy-mm-dd. If day and month missing, output will be yyyy only, if day missing, output will be yyyy-mm.

Thanks

Re: Date Conversion

ballardw — Mon, 07 Mar 2022 21:02:07 GMT

By "output" do you mean that you want an actual SAS date that displays that way?

Or another character variable that can't use any of the date functions?

Or a numeric value that is not in any way a date except possibly in the readers mind?

SAS date values must have month and day of month component. And a variable can only have one format in effect at any given time. What you request for "g, output will be yyyy only, if day missing, output will be yyyy-mm" is not possible with actual SAS dates.

If you want to use any of the functions such as Intck or Intnx for returning date intervals or adjusting dates, then you will have to provide a day of month and month when missing.

The informats that read yyyymm type generally assume the day of the month to be 1.

You would have to decide what makes sense for your purpose what date of the year just the year value would mean.

Re: Date Conversion

PaigeMiller — Mon, 07 Mar 2022 22:49:34 GMT

Question about these type of "dates" where either the day or the month (or both) has been asked and answered many times:

https://communities.sas.com/t5/SAS-Programming/convert-to-iso8601-format/m-p/613845

https://communities.sas.com/t5/SAS-Programming/How-to-convert-below-dates-to-as-required-format/m-p/609587

https://communities.sas.com/t5/SAS-Programming/Re-Partial-date-conversion/m-p/575008

and many other times. Lots of ideas, lots of answers.