Convert Character YYYYMM date to datetime format

[david27]

Hello,

I have the below dataset.

I want another variable which has

• format of datetime20.
• with last day of the respective month.(eg: for 201701 the date should be last date of the month --31JAN2017:00:00:00)

data have;
input character_date $6.;
datalines;
201701
201702
201703
201801
201802
201803
201901
201902
201903
;
run;

[ballardw · Accepted solution]

Looks like this does what you request:

data have;
input character_date $6.;
datetime = dhms(intnx('month',input(character_date,yymmn6.),0,'e'),0,0,0);

format datetime datetime18.;
datalines;
201701
201702
201703
201801
201802
201803
201901
201902
201903
;
run;

Input with the correct informat will get you the first day of the month, the INTNX function with the 'e' alignment gets the last day of the month and the DHMS function turns a date and hour=0,minute=0 and second=0 into the desired datetime.