SAS changing my datetime format

[Osebeyo]

Hi,

Can anyone please help me with this query, i have tried as much as I could but just don't know what is wrong.

I used the Proc Import to import a text file, but the SAS date doesn't match up with the text file date.

The text file datetime is in this form: MMDDYY HH:MM:SS, while SAS returns DDMMMYY HH:MM:SS

e.g

05-02-2011-00:00:00 was changed to 05Feb2011:00:00:00 instead of 02May2011:00:00:00

Can you help please:smileyconfused:

[art297 · Accepted solution]

Have you tried preceding your proc import with:

options datestyle DMY;

Art