11-28-2014 06:05 PM
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:
FORMAT eventdat MMDDYY10.;
urgent help needed please.