How to extract Month and Year from the date?

[ybz12003]

Hello,

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

[ballardw · Accepted solution]

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.

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/... has a PDF with much information about dates.

[maguiremq]

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

YEAR Function 

MONTH Function