How to date values from a character variable

knveraraju91 — Wed, 05 Apr 2017 05:33:43 GMT

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;

Re: How to date values from a character variable

Reeza — Wed, 05 Apr 2017 06:03:26 GMT

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

topic Re: How to date values from a character variable in SAS Programming

How to date values from a character variable

Re: How to date values from a character variable