In AS400 systems, the IBM date format can be transmitted in the format CYYMMDD, where the C indicates Century and is either a "0" to indicate a date earlier than 2000 or a "1" for dates thereafter. For example: 960412 = 4/12/1996, 1180809 = 8/9/2018. To convert this date format to a SAS date, you can use the following line in your PROC SQL statements: mdy(mod(<datefield>,10000)/100,mod((<datefield>,100),(<datefield>/10000) + 1900) You can also add a "format=" statement to return the value you're looking for, eg: format = date9. would return 09AUG2018, format = mmddyys10. would return 08/09/2018.
... View more