05-24-2015 10:26 AM
I'm new to SAS and going through the free tutorials, but I'm having some trouble importing a CSV file into SAS.
Basically I'm trying to open a CSV in SAS, but somehow all the line breaks in the original file disappear.
I don't really speak the SAS language yet, so I'll attach the screenshots for reference:
So the original file looks like this:
But when I open the file on SAS this is what I get, with all the line breaks gone:
Please let me know what I'm doing wrong. Thank you all for your help in advance!
05-26-2015 10:23 AM
Have you tried any code to just READ the file? The issue that you are seeing is that sometimes carriage returns/line feeds don't translate in the editor. You should be able to read the file OK -- there are PROC IMPORT examples in the Snippets section for reading the file.