topic date conversion in New SAS User

date conversion

mahender1 — Tue, 09 Apr 2019 15:49:35 GMT

Hello all,

kindly help me in converting the date values to ISO8601 format.

i have date values as :

TRTSTDT and TRENDT are NUMERIC type as below:

TRSTDT TRENDT

06DEC2007 20DEC2007

16JUN2009 30JUN2009

I want to convert them to CHARACTER variables as

RFSTDTC and RFENDTC to ISO8601 format,

Kindly help me.

PeterClemmensen — Tue, 09 Apr 2019 16:02:26 GMT

Whn you say ISO 8601 Format, does that mean that 06DEC2007 becomes 20071206? 🙂

Tom — Tue, 09 Apr 2019 16:08:40 GMT

What did you try? SAS has a number of ISO formats.

RFSTDTC = put(TRTSTDT,B8601DA8.);

Of course you could also just use the YYMMDDN format.