Learning SAS? Welcome to the exclusive online community for all SAS learners.

Having trouble importing CSV into SAS

Reply
Occasional Learner
Posts: 1

Having trouble importing CSV into SAS

Hi all,

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:

Screen Shot 2015-05-24 at 11.20.44 PM.png

But when I open the file on SAS this is what I get, with all the line breaks gone:

Screen Shot 2015-05-24 at 11.22.01 PM.png

Please let me know what I'm doing wrong. Thank you all for your help in advance!

SAS Super FREQ
Posts: 8,866

Re: Having trouble importing CSV into SAS

Posted in reply to damemanjar

Hi:

  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.

cynthia

Ask a Question
Discussion stats
  • 1 reply
  • 236 views
  • 0 likes
  • 2 in conversation