My .csv file has 50+ million records. The maximum widths of each field (Excel column) are known (to me). But the early records in the .csv file contain fewer characters in some fields than in later records (much later) -- and SAS is truncating data when importing those later records. Is there a way to specify all the field widths in the PROC IMPORT syntax and avoid GUESSINGROWS completely? Or, is there another way to input the .csv file in one pass and not lose data? I'm new to SAS, so my terms may be off. Thank you.
... View more