DATA Step, Macro, Functions and more

Convert text dates and see if two dates are the same

Reply
Contributor
Posts: 21

Convert text dates and see if two dates are the same

Good Evening,

im reading in an input file that has dates in text format.

 

IDAT $ EDAT $ TRDAT $

 

Idat and TRDat

 

Both look similar to

Idatetrdate
2017042620170426

 

my goal is to compare if the date are identical or not.(1 or 0)

Super User
Posts: 19,878

Re: Convert text dates and see if two dates are the same

Posted in reply to Bellefeuille

You don't have to convert the to dates to check if they're equal if they look the same. You can check directly. 

 

I would suggest using an INFORMAT to specify the format type - yymmdd8 and then format the date with a date9 format.

 

Here's some skeleton code:

data have;
informat idat edat trtdat yymmdd8.;
format idat edat trtdat date9.;
input idat edit trtdat;

if idat = trtdat then do;

****whateever you want to do here*****;

end;


run;
Super User
Super User
Posts: 7,997

Re: Convert text dates and see if two dates are the same

Posted in reply to Bellefeuille

You have two text strings therefore:

identical=ifc(strip(edat)=strip(trtdat),1,0);
Ask a Question
Discussion stats
  • 2 replies
  • 104 views
  • 0 likes
  • 3 in conversation