topic Re: How to extract Month and Year from the date? in SAS Programming

How to extract Month and Year from the date?

ybz12003 — Mon, 13 Feb 2023 20:11:51 GMT

Hello,

How to extract a Month and Year from the format, 11/12/2018? Thank you.

ballardw — Mon, 13 Feb 2023 20:17:08 GMT

The format has nothing to do with it. If it the value is a SAS date value then you use the Month and Year (or Day or Qtr) functions.

data example;

month=month(today());

year =year(today());

run;

Use your SAS date-valued variable inplace of the Today() function.

If you have a character value that looks like 11/12/2018 that's another story.

maguiremq — Mon, 13 Feb 2023 20:19:06 GMT

You can use the `MONTH()` and `YEAR()` functions.