topic How to obtain Year from MMDDYY10. format? in SAS Programming

How to obtain Year from MMDDYY10. format?

ybz12003 — Wed, 31 May 2023 22:36:05 GMT

Hello,

If I have a date variable name, screendate, and it's format is MMDDYY10. How to obtain the year from it? Thanks.

Re: How to obtain Year from MMDDYY10. format?

SASKiwi — Wed, 31 May 2023 22:43:22 GMT

To read the year of a SAS date into a new variable try the YEAR function.

Re: How to obtain Year from MMDDYY10. format?

ballardw — Wed, 31 May 2023 22:49:43 GMT

@ybz12003 wrote:

Hello,

If I have a date variable name, screendate, and it's format is MMDDYY10. How to obtain the year from it? Thanks.

OR just use a YEAR4. format for display.

Dummy code obviously as you haven't provided even a data set name:

Proc print data=have;
   var screendate;
   format screendate year4. ;
run;

Re: How to obtain Year from MMDDYY10. format?

ybz12003 — Wed, 31 May 2023 23:06:00 GMT

Not just display, need to use calculation.

Re: How to obtain Year from MMDDYY10. format?

ballardw — Thu, 01 Jun 2023 00:01:37 GMT

@ybz12003 wrote:

Not just display, need to use calculation.

Might be interesting to show the calculation involving a year value. Many such might be better done with the Intck or Intnx functions if the calculation involves intervals around dates in any way.