DATA Step, Macro, Functions and more

How to date values from a character variable

Reply
Super Contributor
Posts: 272

How to date values from a character variable

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;
Super User
Posts: 17,837

Re: How to date values from a character variable

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

Ask a Question
Discussion stats
  • 1 reply
  • 111 views
  • 1 like
  • 2 in conversation