I am currently writing a piece of code to extract specific elements of raw data into a new file. My raw data file imports from an Excel.XLSX file and has 36 columns which are titled as dates input as "dd/mm/yyyy".   When I bring this data into SAS using Proc Import it converts the format of the column titles with the following stated within the log:   e.g. Variable Name Change. 42370 -> _42370   What I now need is to change the column titles back to a date format as they are showing in my data extract in the above format, e.g. "_ddddd". I need a piece of code to identify where columns have a title such as the one above or similar (I have 36 columns each with a unique header according to which month it is) and then takes that and converts it to a date value.   Any help would be really appreciated. ... View more