importing csv file

[ajulio4]

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

[CarmineVerrell]

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

[Kurt_Bremser]

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:

[Tom · Accepted solution]

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.

[ajulio4]

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