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