Hi Kevin, If you have 9.3 you could use a format based on a function. Regards Jeroen. proc fcmp outlib=work.functions.smd; function MonYear(date) $ 8; month = floor(date / 10000); year = date - (month * 10000); if month < 1 or month > 12 then do; month = 1; end; return (catx(' ', put(mdy(month, 1, year), monname3.), put(year, 4.))); endsub; run; /* Make the function available to SAS. */ options cmplib=(work.functions); /* Create a format using the function created by the FCMP procedure. */ proc format; value MonYear other=[MonYear()]; run; /* Use the format in a SAS program. */ data test; input testdate; datalines; 12011 022012 122013 ; run; proc print data=test; format testdate MonYear.; run;
... View more