Convert date character $CHAR6. to date DATE9.

[Angel_Saenz]

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

[Shmuel]

Use code:

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

[Angel_Saenz]

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

[Shmuel]

Your post didn't ask for numeric date.

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

[Kurt_Bremser · Accepted solution]

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

[Peter_C]

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