reply to mmazumder (I have uploaded excel data)

Reply
PROC Star
Posts: 7,487

reply to mmazumder (I have uploaded excel data)

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?

PROC Star
Posts: 7,487

Re: reply to mmazumder (I have uploaded excel data)

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;

Super User
Posts: 11,343

Re: reply to mmazumder (I have uploaded excel data)


Or

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

Ask a Question
Discussion stats
  • 2 replies
  • 148 views
  • 0 likes
  • 2 in conversation