One way to prevent these issues with month first or day first date formats is to always use year, month, day format when transferring date values. Then there is no confusing between differnet regions of the world using different conventions. They also have the advantage that when you sort the text version of the date the result is proper chronological order.
data want ;
input RollNo Name :$10. Date :yymmdd10. Marks Remarks :$20. ;
format date yymmdd10. ;
cards;
1 Jai 1990/10/24 74 Good
2 Ram 2001/11/06 84 Better
3 Rose 2013/02/09 54 Bad
4 Pop 2001/07/21 96 Best
;;;;
... View more
