Help using Base SAS procedures

SAS changing my datetime format

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

SAS changing my datetime format

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:MMSmiley FrustratedS, while SAS returns DDMMMYY HH:MMSmiley FrustratedS

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:


Accepted Solutions
Solution
‎07-07-2011 10:15 AM
PROC Star
Posts: 7,492

Re: SAS changing my datetime format

Have you tried preceding your proc import with:

options datestyle DMY;

Art

View solution in original post


All Replies
Solution
‎07-07-2011 10:15 AM
PROC Star
Posts: 7,492

Re: SAS changing my datetime format

Have you tried preceding your proc import with:

options datestyle DMY;

Art

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 144 views
  • 1 like
  • 2 in conversation