Another common source of trouble when reading data from Excel files (or CSV files generated from them) is the presence of embedded end-of-line characters in the values inside of cells with the sheet. One solution to try is to use the TERMSTR=CRLF option on the INFILE statement that reads the CSV file. You will still need to watch out where the embedded CR or LF has gotten into the value of your character variable in your SAS dataset, but you can normally clean that by using the COMPRESS() or TRANSLATE() function.
... View more
