Hi, I am trying read an external .xlsx file using PROC IMPORT. But the dates stored in the .xlsx file as CUSTOM in dd/mm/yyyy format are not read correctly. only the character variables are read fine. For e.g. In .xlsx file we have DATE= 01/21/2019 , but after importing the file, the value changes as DATE=43486. On checking the PROC CONTENTS for the same variable, DATE, it has TYPE= NUM,LEN=8, FORMAT = BEST. The DATE is needed in the format of YYYYMMDD. Please suggest some way out to fix the code. Thanks !!
... View more