https://communities.sas.com/t5/SAS-Programming/remove-ascii-character-when-using-Proc-import-or-infile-for-csv/m-p/650982#M195252 <P>This symbol is shown in word processors (when showing special characters is activated) to make end-of-lines visible. The line endings are necessary for the RECFM=V in SAS (used when reading CSV files) to work. You do not need to remove them, as the termination strings are automatically used to identify the text lines.</P> <P>&nbsp;</P> <P><STRONG>BIG HINT</STRONG>:</P> <P>do NOT use word processors or spreadsheet calculators to view CSV files you want to import into SAS. Always use a proper text editor suited for programming, like Notepad++.</P> Wed, 27 May 2020 06:25:23 GMT Kurt_Bremser 2020-05-27T06:25:23Z https://communities.sas.com/t5/SAS-Programming/remove-ascii-character-when-using-Proc-import-or-infile-for-csv/m-p/650976#M195249 <P>&nbsp;</P> <P>Hi is there any way we can read a field using infile or proc import for csv file removing the below ascii character&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dennis_oz_0-1590556721708.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/40023iD31F4002F77D054F/image-size/medium?v=v2&amp;px=400" role="button" title="dennis_oz_0-1590556721708.png" alt="dennis_oz_0-1590556721708.png" /></span></P> <P>&nbsp;</P> Wed, 27 May 2020 05:19:48 GMT https://communities.sas.com/t5/SAS-Programming/remove-ascii-character-when-using-Proc-import-or-infile-for-csv/m-p/650976#M195249 dennis_oz 2020-05-27T05:19:48Z https://communities.sas.com/t5/SAS-Programming/remove-ascii-character-when-using-Proc-import-or-infile-for-csv/m-p/650982#M195252 <P>This symbol is shown in word processors (when showing special characters is activated) to make end-of-lines visible. The line endings are necessary for the RECFM=V in SAS (used when reading CSV files) to work. You do not need to remove them, as the termination strings are automatically used to identify the text lines.</P> <P>&nbsp;</P> <P><STRONG>BIG HINT</STRONG>:</P> <P>do NOT use word processors or spreadsheet calculators to view CSV files you want to import into SAS. Always use a proper text editor suited for programming, like Notepad++.</P> Wed, 27 May 2020 06:25:23 GMT https://communities.sas.com/t5/SAS-Programming/remove-ascii-character-when-using-Proc-import-or-infile-for-csv/m-p/650982#M195252 Kurt_Bremser 2020-05-27T06:25:23Z