topic Re: Convert date character $CHAR6. to date DATE9. in SAS Programming

Convert date character $CHAR6. to date DATE9.

Angel_Saenz — Fri, 03 Feb 2017 17:56:09 GMT

I need to convert date character $CHAR6. to date DATE9.

for example EDATE is a var I have, FDATE is a var I want:

$CHAR6. DATE9.

EDATE FDATE

201001 01JAN2010

201612 01DEC2016

201306 01JUN2013

Re: Convert date character $CHAR6. to date DATE9.

Shmuel — Fri, 03 Feb 2017 18:03:50 GMT

Use code:

Fdate = put(input(Edate||'01',yymmdd8.),date9.);

Re: Convert date character $CHAR6. to date DATE9.

Kurt_Bremser — Fri, 03 Feb 2017 18:17:17 GMT

fdate = input(trim(edate)!!'01,yymmdd8.);
format fdate date9.;

Re: Convert date character $CHAR6. to date DATE9.

Peter_C — Fri, 03 Feb 2017 18:51:31 GMT

Have you tried the format hunter?

See the 2014 SAS Global Forum paper 1744-2014
VFORMAT Lets SAS® Do the Format Searching

It will hunt for informats too

Peter

Re: Convert date character $CHAR6. to date DATE9.

Angel_Saenz — Fri, 03 Feb 2017 19:57:18 GMT

thank you Shmuel that works, but var Fdate finished like type character6, I need not only format DATE9. too the var I need same type

Re: Convert date character $CHAR6. to date DATE9.

Shmuel — Fri, 03 Feb 2017 22:00:23 GMT

Your post didn't ask for numeric date.

Anyhow, see @Kurt_Bremser solution, it fits your request.