Text field truncation

Now look at rows 21-24. Notice how ALKALINE PHOSPHATASE is truncated to ALKALINE PHOSP. This happens because the default behavior of the Import Wizard, PROC IMPORT, and the External File Interface (EFI) is that they scan only 20 rows deep into the file to determine variable attributes. Text field truncation is a common problem here. Another problem is that if a field appears to be numeric in the first 20 rows but later has character text beyond the scanning depth of PROC IMPORT, the procedure will terminate with an error message. There are two workarounds for this scanning depth problem. 

---