topic Convert Character YYYYMM date to datetime format in New SAS User

Convert Character YYYYMM date to datetime format

david27 — Thu, 19 Sep 2019 18:35:26 GMT

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;

Re: Convert Character YYYYMM date to datetime format

ballardw — Thu, 19 Sep 2019 19:20:00 GMT

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.