topic Re: reply to mmazumder (I have uploaded excel data) in SAS Programming

reply to mmazumder (I have uploaded excel data)

art297 — Fri, 28 Nov 2014 23:21:05 GMT

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 — Sat, 29 Nov 2014 01:14:13 GMT

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 — Mon, 01 Dec 2014 21:05:02 GMT

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