topic dateformat in New SAS User

dateformat

Smitha9 — Sun, 14 Jun 2020 14:46:05 GMT

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 — Sun, 14 Jun 2020 14:51:27 GMT

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,

Kurt_Bremser — Sun, 14 Jun 2020 14:56:30 GMT

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;

Smitha9 — Sun, 14 Jun 2020 14:59:39 GMT

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