Format a date in sas data step

[xliu1]

I need to format a date from yyyymmdd to mm/dd/yyyy in sas data step. I have the following sas codes:

DATA work;
SET work1;
BY ID;

Birth_Date=input(Date_of_Birth,yyyymmdd.);
format Birth_Date $date10.;
run;

the original date is character type, format $8. informat $8.

i keep getting sas error message: The informat YYYYMMDD was not found or could not be loaded

can anyone help with this? thanks

[ed_sas_member · Accepted solution]

Hi @xliu1 

Please try this:

DATA work;
	SET work1;
	BY ID;
	Birth_Date=input(Date_of_Birth, yymmdd10.);
	format Birth_Date mmddyy10.;
run;

Best,

[xliu1]

 It works out. Thank you!