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.;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.