Converting character date to numeric date

[lerdem]

I need to compare 2 date :

One of them is in character value 20$ and looks "2016-04-01 14:30:29"

Other one is numeric datettime20. and looks "05AUG2002:09:15:55"

i will compare them, how can i convert it?

[ballardw]

See if this approach works for you:

data junk;
   x="2016-04-01 14:30:29";
   y= dhms(input(scan(x,1,' '),yymmdd10.), 0,0,input(scan(x,2,' '),time.));
   format y datetime20.;
run;

Compare a variable make like Y to your other value.