I have uploaded excel data to sas, But the date format is Best12. When I want to convert the date to MMYYDD10. then the date totally messed. Suppose my original uploaded date is 801014 but when I want to convert the date it becomes 02/07/4153. I have a

Reply
N/A
Posts: 1

I have uploaded excel data to sas, But the date format is Best12. When I want to convert the date to MMYYDD10. then the date totally messed. Suppose my original uploaded date is 801014 but when I want to convert the date it becomes 02/07/4153. I have a

I have uploaded excel data in sas, But the date format is Best12. When I want to convert the date to MMYYDD10. then the date totally messed. Suppose my original uploaded date is 801014 but when I want to convert the date  it becomes 02/07/4153. I have a huge data base. can you help me how I can convert my best 12. date to MMYYDD10. and my output will be 10141980.

I have tried the following code:

data permno;

SET permno;

eventdat=input(put (eventdat1,12.)best12.);

FORMAT eventdat MMDDYY10.;

run;

urgent help needed please.

Sharif.

Ask a Question
Discussion stats
  • 0 replies
  • 175 views
  • 0 likes
  • 1 in conversation