Hello,
If I have a date variable name, screendate, and it's format is MMDDYY10. How to obtain the year from it? Thanks.
To read the year of a SAS date into a new variable try the YEAR function.
To read the year of a SAS date into a new variable try the YEAR function.
@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;
Not just display, need to use calculation.
@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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.