dateformat

[Smitha9]

Hi,

I have a dataset which has admissiondate: 11APR20:23:49:00 (numeric)

Another dateset which has admissiondate: 2020-04-11 23:49:00 ( character)

I want to merge these two datasets.

Can you help me in this? to change character to numeric and change the formats?

thank you in advance.

[ed_sas_member · Accepted solution]

Hi @Smitha9 

You should first convert the character date in dataset2 into a valid sas datetime (numeric).

To do that you can do this;

data dataset2_bis;
	set dataset2;
	date2 =  input ("2020-04-11 23:49:00",anydtdtm.);
	format date2 datetime20.;
run;

Best,

[Smitha9]

thank you for the quick reply. I appreciate it and It worked.

[Kurt_Bremser]

SAS provides an informat that can read this datetime value:

data test;
instring = "2020-04-11 23:49:00";
dt = input(instring,e8601dt19.);
format dt datetime19.;
run;