reply to mmazumder (I have uploaded excel data)

[art297]

Your subject line is so long that the forum won't let one reply to it.

When you imported the file did you set the usedate=yes statement?

[art297]

Of course, you could always just modify the data you already have. e.g.:

data have;

  format want mmddyyN8.;

  date=801014;

  want=mdy(substr(put(date,6.),3,2),

           substr(put(date,6.),5,2),

           substr(put(date,6.),1,2));

run;

[ballardw]

Or

eventdat=input(put (eventdat1,z6.),YYMMDD6.);