topic Re: i have date value like 15may2012 i want convert this date to 15may2012:00:00:00 how it will come? in SAS Programming

i have date value like 15may2012 i want convert this date to 15may2012:00:00:00 how it will come?

rahul — Wed, 06 Jun 2012 09:50:57 GMT

i have date value like 15may2012 i want convert this date to 15may2012:00:00:00 how it will come?

Re: i have date value like 15may2012 i want convert this date to 15may2012:00:00:00 how it will come?

shivas — Wed, 06 Jun 2012 09:56:17 GMT

Hi,

Try this..

data one;

yy=dhms('31MAy2012'd,00,00,00);

format yy datetime.;

run;

Thanks,

Shiva

Re: i have date value like 15may2012 i want convert this date to 15may2012:00:00:00 how it will come?

rahul — Wed, 06 Jun 2012 10:02:21 GMT

Thank u for u r answer

But you used 15may2012'00'00'00 .but my doubt is only use 15may2012 in input value(informat).and get the value like 15may2012:00:00:00 as format

please be help..

Re: i have date value like 15may2012 i want convert this date to 15may2012:00:00:00 how it will come?

shivas — Wed, 06 Jun 2012 10:30:58 GMT

Hi Rahul,

you can also try this...but I will use DHMS function like above to get the datetime format.

data one;

xx='31MAy2012'd;

yy=xx*86400;

format yy datetime.;

run;

If you directly apply format on xx as datetime. then you will different values like 01JAN60:05:19:04

Thanks,

Shiva

Re: i have date value like 15may2012 i want convert this date to 15may2012:00:00:00 how it will come?

Tom — Wed, 06 Jun 2012 11:44:35 GMT

If you are reading the value from a text file then use the ANYDTDTM informat.

data _null_;

input @1 date date9. @1 dt anydtdtm. ;

format date date9. dt datetime.;

put (_all_) (=);

cards;

15MAY2012

run;

date=15MAY2012 dt=15MAY12:00:00:00

Re: i have date value like 15may2012 i want convert this date to 15may2012:00:00:00 how it will come?

Alpay — Wed, 06 Jun 2012 12:06:55 GMT

İf you already have a date value, 15May2012, stored in a data set but you want to display datetime,15May2012:00:00:00, without changing the value of underlyıng variable you may try picture directives in proc format.

Zafer

proc format;

pıcture dtfmt low-high = '%d%b%Y:00:00:00' (datatype=date);

run;

data _null_;

x = '15May2012'd;

put x dtfmt18.;

run;

15MAY2012:00:00:00