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;