topic Date Format in SAS Programming

Date Format

Ela_84 — Thu, 23 Mar 2023 10:35:11 GMT

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

Re: Date Format

PaigeMiller — Thu, 23 Mar 2023 11:26:54 GMT

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;

Re: Date Format

AMSAS — Thu, 23 Mar 2023 11:29:39 GMT

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 ;