DATA Step, Macro, Functions and more

Convert text dates and see if two dates are the same

Reply
Occasional Contributor
Posts: 15

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: 17,831

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

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,401

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

You have two text strings therefore:

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