BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
ybz12003
Rhodochrosite | Level 12

Hello,

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

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

View solution in original post

4 REPLIES 4
SASKiwi
PROC Star

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

ballardw
Super User

@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;
ybz12003
Rhodochrosite | Level 12

Not just display, need to use calculation.

ballardw
Super User

@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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1428 views
  • 1 like
  • 3 in conversation