topic Re: how to convert character date (displaying as mmddyy10 format) into numeric date (format datetime20. ) in SAS Programming

how to convert character date (displaying as mmddyy10 format) into numeric date (format datetime20. )

nbonda — Mon, 11 May 2015 01:13:44 GMT

I have data set dtset1.

sn. stdt;

1 10/10/2010

2 10/19/2011

stdt is a character variable with length 10.

I need to convert this into numeric date like datetime20.

I tried this;

data new-dtset;

set dtset1 (rename=(stdt=stdt_n));

stdt=input(stdt_n, date9.);

format stdt datetime20.;

drop stdt_n;

run;

but It didn't work, It's converting to numberic but showing as missing value.

I need help to solve this problem.

Thank you

MichaelLarsen — Mon, 11 May 2015 11:56:23 GMT

First you need to change the informat reading the date and secondly you must convert that date value into a datetime value using the dhms function.

data newdtset;

set dtset1 (rename=(stdt=stdt_n));

stdt=dhms(input(stdt_n, mmddyy10.),0,0,0);

format stdt datetime20.;

drop stdt_n;

run;

Regards,

Michael

Kurt_Bremser — Mon, 11 May 2015 12:08:32 GMT

Replace

stdt=input(stdt_n, date9.);

with

stdt = input(stdt_n,mmddyy10.) * 86400;

Since you want it to display as a datetime value, it needs to count the seconds from 01jan1960 instead of just the days.

Ksharp — Mon, 11 May 2015 15:11:14 GMT

Directly use informat .

option datestyle=mdy;
data have;
input sn  stdt : $20.;
d=input(stdt,anydtdtm20.);
format d datetime.;
cards;
1  10/10/2010
2  10/19/2011
;
run;

Xia Keshan

nbonda — Wed, 13 May 2015 12:19:53 GMT

Thank you Michael