How do I separate the day, month, year and add hours from date 23MAR2023:09:23:46.000
The view I want to achieve is below :
Day | Month | Year | Hours |
23 | MAR | 2023 | 9 |
data want;
set have;
day=day(datepart(date));
month=month(datepart(date));
year= ; /* See if you can figure it out based on the above);
hours=hour(date);
run;
See Data/ and Time functions
data _null_ ;
datetime=datetime() ;
datepart=datepart(datetime) ;
day=day(datepart) ;
month=month(datepart) ;
year=year(datepart) ;
hour=hour(datetime) ;
put _all_ ;
run ;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.