Hi SAS community, I encountered a data change issue when I use proc import to call in XLSX into sas. There is 1 column, let us call it date1. And the column is text in excel file, contains date information in different formats, please see screenshot1. When it is imported into SAS, the value of date1 changed as screenshot2. You can see highlighted part in screenshot2 becomes 4xxxx. If I tried to use put function to convert it to charater, the value changed to other dates as shown in screenshot3. Is ithere any solution to avoid this data change issue? Thanks!
... View more