topic Re: How to convert this date from string to date ? in SAS Programming

How to convert this date from string to date ?

shixin — Fri, 20 Jun 2014 19:28:00 GMT

A quick question.

How do I convert this $21 to DATETIME18.?

I have this: 2014-04-17 06:18:24

I want this: 17APR14:06:18:24

What's wrong with my code?

timestamp1=input(timestamp,datetime18.);

format timestamp1 datetime18.;

Thank you!

Re: How to convert this date from string to date ?

PGStats — Fri, 20 Jun 2014 19:35:12 GMT

Try

timestamp1=input(timestamp, anydtdte21.);

format timestamp1 datetime18.;

Re: How to convert this date from string to date ?

shixin — Fri, 20 Jun 2014 19:47:50 GMT

2014-04-09 06:24:28 became 01JAN60:05:30:22

The format is correct but it's the wrong date and time, hmm..

Re: How to convert this date from string to date ?

JasonAllen — Fri, 20 Jun 2014 19:57:16 GMT

Hello shixin,

Maybe try:

data _null_;

string='2014-04-17 06:18:24';

date=input(scan(string,1,' '),E8601DA10.);

put date= date.;

time=input(scan(string,2,' '),time.);

put time= time.;

dt=dhms(date,0,0,time);

put dt datetime.;

run;

Re: How to convert this date from string to date ?

PGStats — Fri, 20 Jun 2014 20:32:15 GMT

Sorry, it should have been informat ANYDTDTM21. - PG

Re: How to convert this date from string to date ?

shixin — Fri, 20 Jun 2014 20:53:00 GMT

why when I run a case when statement on my newly formatted datetime, it says:

case when dt=MIN(dt) then ....

ERROR: Result of WHEN clause 2 is not the same data type as the preceding

results.

ERROR: Expression using not equals (^=) has components that are of different

data types.

Qn: Shouldn't the format of MIN(dt) be the same as dt???

Re: How to convert this date from string to date ?

Haikuo — Fri, 20 Jun 2014 21:08:13 GMT

Strongly suspect 'dt' is Char.

Re: How to convert this date from string to date ?

PGStats — Fri, 20 Jun 2014 22:27:06 GMT

Please show the whole case ... end code block.