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

mtgkooks — Tue, 28 Aug 2018 18:37:15 GMT

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.

topic SAS Tip: Convert CYYMMDD to a SAS date in PROC SQL in SAS Tips from the Community

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