BookmarkSubscribeRSS Feed
Ela_84
Fluorite | Level 6

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 : 

DayMonthYearHours
23MAR20239
2 REPLIES 2
PaigeMiller
Diamond | Level 26
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;
--
Paige Miller
AMSAS
SAS Super FREQ

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 ;
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
  • 2 replies
  • 1207 views
  • 2 likes
  • 3 in conversation