BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Songchan
Calcite | Level 5

Hi guys,

 

I want exact only YEAR data from a date format like yymmddn8. How can I do it? I tried the following codes, but it didn't work. 

I would appreciate your helps very much!

 

data year01;set year 
year=substr(date,1,4);
yr=mdy(year);
format yr yyn4.;
run;

 

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20

year function?

 

 

year=year(date);

 

This assumes your date is a numeric sas date variable

View solution in original post

3 REPLIES 3
novinosrin
Tourmaline | Level 20

year function?

 

 

year=year(date);

 

This assumes your date is a numeric sas date variable

Songchan
Calcite | Level 5
Thank you so much!
ballardw
Super User

Or don't create an additional variable and just use the YEAR4. Format for your date variable in any procedure.

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
  • 3 replies
  • 5533 views
  • 0 likes
  • 3 in conversation