reply to mmazumder (I have uploaded excel data)

Reply
PROC Star
Posts: 7,358

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,358

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: 10,483

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


Or

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

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