SAS Tip: Convert CYYMMDD to a SAS date in PROC SQL

[mtgkooks]

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.