BookmarkSubscribeRSS Feed
SAS83
Fluorite | Level 6
how to strip out year from this field.

It is in datetime format.

19JAN2006:17:14:33.072000

Thanks in advance..
3 REPLIES 3
yaswoman
Calcite | Level 5
You can use the DATEPART function.
YEAR=DATEPART(yourdate);

I think that is the right syntax.
SPR
Quartz | Level 8 SPR
Quartz | Level 8
Hello SAS83,

This is a possible solution:
[pre]
data i;
dt="19JAN2006:17:14:33.072000"dt;
year=YEAR(DATEPART(dt));
format dt datetime.;
run;
[/pre]
Sincerely,
SPR
SAS83
Fluorite | Level 6
Thank you !!

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

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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