topic importing csv file in SAS Programming

importing csv file

ajulio4 — Thu, 02 Dec 2021 14:59:29 GMT

i want to import data from a csv file with data step and infile instruction. i have in the file a colon comment in whitch i can have caracters such as ->. and it seems like sas inteprete ligne containing this caracter like end of the file. So, in the file if i have 500 lines and the 10th line have this caractere, SAS import just 10 lines and end the execution without errors or warning.

someone can help me?

Thks

Re: importing csv file

CarmineVerrell — Thu, 02 Dec 2021 15:06:16 GMT

You need to provide us a sample csv or code to work with please. You can take a look at some examples here..

SAS Help Center: Reading Raw Data: Examples

Re: importing csv file

Kurt_Bremser — Thu, 02 Dec 2021 15:16:35 GMT

A colon does not cause any issues:

data _null_;
file "~/test.csv";
input line $80.;
put line;
datalines;
xxx
yyy
:
x:
 :
:x
;

data check;
infile "~/test.csv" truncover;
input line $80.;
run;

You will see that all 6 lines are read.

Please post the complete log of your step into a box opened with this button:

Re: importing csv file

Tom — Thu, 02 Dec 2021 15:18:52 GMT

It is a little unclear what your issue is (an actual SAS log would help).

But it looks like your data step is stopping reading the file in the middle?

If so the most likely cause is the "DOS end of file" character. There is an INFILE option to treat that character as a normal character instead of an end of file indicator.

IGNOREDOSEOF

is used in the context of I/O operations on variable record format files. When this option is specified, any occurrence of ^Z is interpreted as character data and not as an end-of-file marker.

Re: importing csv file

ajulio4 — Thu, 02 Dec 2021 15:44:53 GMT

thks so much it works this option. i can now import all of my file lines