Reone,
I'm surprised at that. I would expect SAS to bring in the entire column as text rather than change the numbers into NULLs.
A thought for resolution: Export from Excel into .CSV and read from there. It's a bit more tedious, but you have more control.
Better yet, but it may take longer, upgrade to EG 4.3. Chris's team has really done a lot of work to make the Excel imports work better in 4.3.
A long shot on the cause: Your numbers are not really numbers. In Excel, if you type a leading blank in front of a number, it then treats it like a character field. If there are enough leading blanks, then the "number" is wider than the SAS text string was guessed to be and all you got were the leading blanks.
Doc Muhlbaier
Duke
... View more