Extracting date, month, year and time from a datetime variable

France — Sun, 17 Feb 2019 15:52:36 GMT

Dear all,

how to extract the last four word from the variable, and recorded as a year?

data date;
	input date $50.;
	datalines;JAN2009;
run;

could you please give me some suggestions?

thanks in advance

Re: Extracting date, month, year and time from a datetime variable

stat_sas — Sun, 17 Feb 2019 16:15:43 GMT

Hi,

Something like this?

data want;
set date;
year = substr(date,length(date)-3);
run;