How to date values from a character variable

[knveraraju91]

Dear,

In my data the variable 'orres' is chracter variable with different values. I need to make the program work only obs containing dates.

The program below gave me the output I need. I am using length function to select dates.  

But If a ORRES value with length equal to 10 and not date .How to skip the values that are not dates. Thank you very much

data one;
length orres $200;
input orres ;
datalines;
06:00
21:00
2016-02-29
2017-02-13
;
data two;
set one;
if length(orres)=10 then adt=input(orres,yymmdd10.);
format adt date9.;
if adt > '10feb2017'd then delete;
run;

[Reeza]

It partly depends on the data but not dates would be missing so delete all records where ADT is missing.