topic two digit year to four digit in SAS Programming

two digit year to four digit

mahen — Wed, 20 Jun 2018 08:52:05 GMT

Hi,

if i have a variable A as

20-Aug-1989

12-Feb-2018

etc.,

how can i get the year 87 to 1987.

Please help

Amir — Wed, 20 Jun 2018 09:20:36 GMT

Hi,

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

Regards,

Amir.

RW9 — Wed, 20 Jun 2018 09:33:22 GMT

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 — Thu, 21 Jun 2018 17:46:30 GMT

Okay

Thank you so much:)