topic Re: Reading CSV file, Please Help. Thanks in SAS Programming https://communities.sas.com/t5/SAS-Programming/Reading-CSV-file-Please-Help-Thanks/m-p/81215#M17488 <HTML><HEAD></HEAD><BODY><P>Many Thanks Tom..It works perfectly <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Tue, 19 Mar 2013 15:38:41 GMT Question 2013-03-19T15:38:41Z Reading CSV file, Please Help. Thanks https://communities.sas.com/t5/SAS-Programming/Reading-CSV-file-Please-Help-Thanks/m-p/81211#M17484 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000080;"><STRONG>Hi ,</STRONG></SPAN></P><P></P><P><SPAN style="color: #000080;"><STRONG>Hi Please find attached the SAS Code</STRONG></SPAN></P><P> </P><P><SPAN style="color: #000080;"><STRONG>Many Thanks</STRONG></SPAN></P><P> </P><P><SPAN style="color: #000080;"><STRONG>Alice</STRONG></SPAN></P><P> </P><P> </P></BODY></HTML> Tue, 19 Mar 2013 15:09:44 GMT https://communities.sas.com/t5/SAS-Programming/Reading-CSV-file-Please-Help-Thanks/m-p/81211#M17484 Question 2013-03-19T15:09:44Z Re: Reading CSV file, Please Help. Thanks https://communities.sas.com/t5/SAS-Programming/Reading-CSV-file-Please-Help-Thanks/m-p/81212#M17485 <HTML><HEAD></HEAD><BODY><P>Can you post your data step code?</P></BODY></HTML> Tue, 19 Mar 2013 15:13:51 GMT https://communities.sas.com/t5/SAS-Programming/Reading-CSV-file-Please-Help-Thanks/m-p/81212#M17485 DBailey 2013-03-19T15:13:51Z Re: Reading CSV file, Please Help. Thanks https://communities.sas.com/t5/SAS-Programming/Reading-CSV-file-Please-Help-Thanks/m-p/81213#M17486 <HTML><HEAD></HEAD><BODY><P>Usually an indication that your text file has end of line characters embedded in the value of one of the variables.&nbsp; Your particular example looks like someone put a linefeed or carriage return into the value of an address variable.</P><P></P><P>You could try using the TERMSTR=CRLF option.&nbsp; 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.</P><P></P><P>Also make sure you are using TRUNCOVER option.</P></BODY></HTML> Tue, 19 Mar 2013 15:19:06 GMT https://communities.sas.com/t5/SAS-Programming/Reading-CSV-file-Please-Help-Thanks/m-p/81213#M17486 Tom 2013-03-19T15:19:06Z Re: Reading CSV file, Please Help. Thanks https://communities.sas.com/t5/SAS-Programming/Reading-CSV-file-Please-Help-Thanks/m-p/81214#M17487 <HTML><HEAD></HEAD><BODY><P>Thank You...I will try TERMSTR=CRLF option</P></BODY></HTML> Tue, 19 Mar 2013 15:36:10 GMT https://communities.sas.com/t5/SAS-Programming/Reading-CSV-file-Please-Help-Thanks/m-p/81214#M17487 Question 2013-03-19T15:36:10Z Re: Reading CSV file, Please Help. Thanks https://communities.sas.com/t5/SAS-Programming/Reading-CSV-file-Please-Help-Thanks/m-p/81215#M17488 <HTML><HEAD></HEAD><BODY><P>Many Thanks Tom..It works perfectly <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Tue, 19 Mar 2013 15:38:41 GMT https://communities.sas.com/t5/SAS-Programming/Reading-CSV-file-Please-Help-Thanks/m-p/81215#M17488 Question 2013-03-19T15:38:41Z