While I still don't know what you are trying to accomplish, I hadn't payed enough attention to the notes you indicated were in the SAS log.
Since your dates have an odd mixture of formats, again only if I correctly understand the problem, you might try something like:
data now_char;
input date $11.;
cards;
27JAN2008
26/01/08
31/01Jan/08
;
options datestyle=dmy;
data combine;
set now_char;
if anyalpha(scan(date,2))*anydigit(scan(date,2)) then
date=compress(date,,"a");
format date2 date9.;
date2=input(date,anydtdte11.);
week=intck(cats('week.',
weekday(mdy(1,1,year(input(date,anydtdte11.))))),
mdy(1,1,year(input(date,anydtdte11.))),
input(date,anydtdte11.))+1;
run;
HTH,
Art
... View more