Hello everybody. This is my first post. I have a a2.csv file in which some fields contain linefeeds. I want to make a data set from this with linefeeds removed. The first column has the variables v1 v2 v3 v4, the first numeric and 3 observations. I have tried the following: Two approaches: data trial; infile 'C:\HRH-C\pet\a2.csv' dsd delimiter=';' firstobs=2; input v1 v2 $ v3 $ v4 $; v1= TRANWRD(v1,'0A'x,""); v2= TRANWRD(v2,'0A'x,""); v3= TRANWRD(v3,'0A'x,""); v4= TRANWRD(v4,'0A'x,""); run; data trial; infile 'C:\HRH-C\pet\a2.csv' dsd delimiter=';' firstobs=2; input v1 v2 $ v3 $ v4 $; v1=compress(v1,,"kw"); v2=compress(v2,,"kw"); v3=compress(v3,,"kw"); v4=compress(v4,,"kw"); run; but neither of them seems to work. If instead of a linefeed I put another character in the csv file and use the corresponding first version, it works. Any ideas? (I would like to try the ascii code 10 for the linefeed too but I don't know the syntax for the ascii code..) Thank you in advance Message was edited by: Anastasios Kotronis
... View more