Hi! I used to import data from Excel-sheets some years ago. The data were characters (text) and characters(numbers, to be interpreted as numbers in SAS) and numbers (with period or comma as decimal sign). My solution: Read a data line into a long character variable CV (32000 bytes). Then read CV from the left and decide what is alphabetic text, what is numbers, etc. - and all the details. In my problems I had a column structure from Excel, like: CustomerId (number) CustomerName (text) NumericValue (period or comma, perhaps E-format) next NumericValue, etc Basically you have to use this structure to program the reading of the parts of the string. We used this in production. 5000-10000 lines in Excel sheets, very mixed style. Send me an email to anders.skollermo@one.se plus more info. I will solve it. / Br Anders Sköllermo
... View more
