topic Re: Format a date in sas data step in SAS Procedures

Format a date in sas data step

xliu1 — Wed, 13 May 2020 13:55:17 GMT

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 — Wed, 13 May 2020 14:00:17 GMT

Please try this:

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

Best,

xliu1 — Wed, 13 May 2020 14:07:06 GMT

It works out. Thank you!