I have a large csv file that export from another data source, I want to convert to SAS dataset. The file has over 100 columns and some columns has multiple line value (people paste email information here). I tried both proc import and data step, it could only import the first line, the second line overwrite the next column or wrap to next row. Here is an example of description field: first row: There are 5 Black Belt in Italy. second row: They are using Excel my code is: data test; infile "c:\test" missover dsd lrecl=32767 firstobs=2; informat description $1000.; format description $1000.; input description $; run; Any ideas how to fix the code? Thank you very much!
... View more