Reading CSV file, Please Help. Thanks

[Question]

Hi ,

Hi Please find attached the SAS Code

Many Thanks

Alice

[DBailey]

Can you post your data step code?

[Tom · Accepted solution]

Usually an indication that your text file has end of line characters embedded in the value of one of the variables.  Your particular example looks like someone put a linefeed or carriage return into the value of an address variable.

You could try using the TERMSTR=CRLF option.  If the file was created on PC such that each line ends with carriage return and line feed characters ('0D'x and '0A'x) then any single CR or LF characters in the middle of the line will not cause SAS to treat it as a new line.

Also make sure you are using TRUNCOVER option.

[Question]

Thank You...I will try TERMSTR=CRLF option

[Question]

Many Thanks Tom..It works perfectly