Regarding import of a mixed data from excel

[atulsingh]

Hello everyone,

I am importing a csv file in sas and one of the observations include data like Datsun_715

when i am importing such mixed data in sas it is only reading Datsun_

and that 715  is not getting read.

what to do? please suggest?

[Kurt_Bremser]

Most probably the variable is defined with too short length.

If you used proc import, copy the data step from the log and adapt it.

[atulsingh]

what if i redefine the length of the corresponding variable?

[Reeza]

---

@atulsingh wrote:

what if i redefine the length of the corresponding variable?

---

If the variable has already been read incorrectly changing the length won't change the underlying value. 

Another fix for an 'incorrect' import from CSV Is to make the GUESSINGROWS option big - as large a the file. This means it scans the entire column before deciding on a length and format.