Hi, I am trying to import an excel file into SAS EG, every time I do this however the numbers appear different to what they are in the spread sheet. I am also struggling with date formats here is an exmaple of the excel file I am changing, the first column is a DOB, middle column is a Idenfier number and the last column is date registered; 3091991 1400000000033 15012018 17031977 1400000000044 15012018 3101982 1400000000055 16012018 After importing to SAS the columns and rows appear as below, the date columns do not register as a dates and the identifier number becomes what can be seen below. 3091991 1.4E+12 15012018 17031977 1.4E+12 15012018 3101982 1.4E+12 16012018 What I basically want to do is import the excel file with the correct formats for each column. dates as dates and the indentifier number as full number. Can you help this please? S
... View more