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