two digit year to four digit

[mahen]

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

[Amir]

Hi,

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

Regards,

Amir.

[RW9]

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.

[mahen]

Okay

Thank you so much:)