Below code doesn't provide a valid solution. Please refer to Linlin's post as per why.
Based on your posted data the variable 'holidays' must be a character variable containing strings which stand for a date.
What you want to do is convert such strings into a numeric value which stands for a SAS date and then apply a SAS date format on this numeric variable so that when printing this numeric value it shows up as a date string.
Use a SAS INFORMAT to read a string and convert it to a numeric value (=a SAS date informat). Use a SAS FORMAT to convert a numeric value to a string (eg. a SAS date to a date string).
data have;
infile datalines truncover dsd;
input event:$20. Char_Holidays :$10.;
format Holidays mmddyy10.;
datalines;
New Year,01/01/2012
New Year,01012012
New Year,112012
;
run;
data want;
set have;
format Holidays mmddyy10.;
Holidays=input(Char_holidays,mmddyy10.);
Standardized_Char_Holidays=put(input(Char_holidays,mmddyy10.),mmddyy10.);
run;
proc print data=want;
run;
N.B: A SAS date value are the number of days since 1/1/1960.
data _null_;
date='01jan1960'd;
do while(date<='01jan2010'd);
put date= @20 date= date9.;
date=intnx('year10',date,1,'s');
end;
run;
