Hello again Tom. Okay so that's good news, however this code looks like it only removes line feeds. I actually need a code that will remove line feeds AND carriage returns (plus the combination). It appears people are inputting ALT-ENTER into their excel files, which the csv will read as (I believe) CR+LF. Actually below is the copy of the Word Document version of the csv I need fixed. Basically Var2 in row 1 (key variable 1) are the words hey How, however there is an Alt Enter between them. I need sas to put those onto one line (or ast least one variable) but still created a second row after var3. So my final output should look like the dataset below it. ORIGINAL key,var1,var2,var3 1,a,"hey how",a 2,a,a,a 3,a,a,a NEED key,var1,var2,var3 1,a,"hey how",a 2,a,a,a 3,a,a,a Sorry if my explanation is or was not correct. I am by no means a SAS expert and this was the first computer language I taught myself about a year ago, so still have a lot left to learn. Please let me know if you need any more information from me! Thanks!
... View more