a) Excel - this is not a good data transfer format. Use CSV, XML or any of the other proper structured data transfer formats

b) Proc import/export - these are guessing procedures. They guess what data you want to import. Use a proper data transfer format and write and explicit datastep import to import the data as you know it to be.