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
fdate = input(trim(edate)!!'01,yymmdd8.);
format fdate date9.;
Use code:
Fdate = put(input(Edate||'01',yymmdd8.),date9.);
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
Your post didn't ask for numeric date.
Anyhow, see @Kurt_Bremser solution, it fits your request.
fdate = input(trim(edate)!!'01,yymmdd8.);
format fdate date9.;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.