Phaani wrote: Hello Art and Fried, Just a question regarding options datestyle=mdy; do I need to use it for using anydtdte informat option or is that option for something else ?? thanks kumar The datestyle system option tells the anydt* formats what style date to use as a default when it cannot determine the proper order for the given date. For instance in this example we have: 11/01/2009 This could be November 1st 2009 or January 11th 2009, I want is to be Nov. 1 so I assign datestyle=mdy. With bad data always comes mistakes and assumptions so this should be assigned to the occurance you view as being most frequent. jerry898969 wrote: ERROR 48-59: The informat $ANYDTDTE was not found or could not be loaded. ERROR 48-59: The format $YYMMDD was not found or could not be loaded. I avoid this issue by using the special _infile_ variable, if you are changing the format from a dataset you will need to use input function for my method. Art's post would be my solution for this situation.
... View more