DATA Step, Macro, Functions and more

two digit year to four digit

Reply
Occasional Contributor
Posts: 7

two digit year to four digit

Hi,

if i have a variable A as

       A

20-Aug-1989

87

12-Feb-2018

 

etc.,

how can i get the year 87 to 1987.

 

Please help

Super Contributor
Posts: 340

Re: two digit year to four digit

Hi,

 

If A is a SAS variable, then what type is it and what format does it have, if any?

 

 

Regards,

Amir.

Super User
Super User
Posts: 9,617

Re: two digit year to four digit

Post test data in the form of a datastep!!

Now we have to go through the stages of asking you questions about what your data looks like.

Is it a date?

Is it character?

Is 87 really 1987?  What if you have 18, is that 1918 or 2018?

 

If its text which I suspect, then:

a=ifc(lengthn(a)=2,cats("19",a),a);

But I would go back to the source and get them to fix it to be safe.

Occasional Contributor
Posts: 7

Re: two digit year to four digit

Okay

Thank you so muchSmiley Happy

Ask a Question
Discussion stats
  • 3 replies
  • 80 views
  • 1 like
  • 3 in conversation