topic Re: What use is the delimiter option in the INFILE statement? in SAS Programming

What use is the delimiter option in the INFILE statement?

tomcmacdonald — Fri, 26 Jan 2018 19:07:57 GMT

Does it do anything? It seems to ignore it and treat my delimited file as a flat file.

Re: What use is the delimiter option in the INFILE statement?

Reeza — Fri, 26 Jan 2018 19:19:34 GMT

@tomcmacdonald wrote:

Does it do anything?

Yes.

@tomcmacdonald wrote:

It seems to ignore it and treat my delimited file as a flat file.

You're using it incorrectly then.

Re: What use is the delimiter option in the INFILE statement?

tomcmacdonald — Fri, 26 Jan 2018 19:21:57 GMT

Why does it bleed over into the other column? Doesn't SAS know to stop when it hits the delimiter?

Re: What use is the delimiter option in the INFILE statement?

Reeza — Fri, 26 Jan 2018 19:25:57 GMT

@tomcmacdonald wrote:

Doesn't SAS know to stop when it hits the delimiter?

That's what it does. Like I said, you're likely doing something wrong. You need to show your code, log and ideally sample data that reflects your situation

Re: What use is the delimiter option in the INFILE statement?

tomcmacdonald — Fri, 26 Jan 2018 19:39:25 GMT

I just find the fact that it's bleeding over to be pretty bizarre. You figure SAS would throw an error at least.

Re: What use is the delimiter option in the INFILE statement?

ballardw — Fri, 26 Jan 2018 20:18:08 GMT

@tomcmacdonald wrote:

Why does it bleed over into the other column? Doesn't SAS know to stop when it hits the delimiter?

Show your log where you run the code Preferably in a code box opened with the forum's {I} icon. Also best would be to provide some example of the data file. Do not paste your data example into the main window but use a code box. The main message windows reformat pasted text.

there are potentially lots of interactions but the one I see here most frequently that sounds like what you describe is placing a format as part of the INPUT.

If you have

input var $10. it will read 10 characters pretty much.

informat var $10. ;

input var;

will read var as charcter up to the first delimiter if the infile is declared with the correct delimiter.

Other options such as DSD also have an impact.

Re: What use is the delimiter option in the INFILE statement?

Kurt_Bremser — Fri, 26 Jan 2018 20:24:06 GMT

If SAS can do what you tell it to do, there's no reason to throw an error. And there are valid reasons for mixing list and formatted input (I guess that is the reason for your problem) at certain times.

Re: What use is the delimiter option in the INFILE statement?

ballardw — Fri, 26 Jan 2018 20:34:22 GMT

@tomcmacdonald wrote:

Why does it bleed over into the other column? Doesn't SAS know to stop when it hits the delimiter?

Please look at these code examples. Does your code look at all like the first one?

Note that the values of x and y vary between the two sets because the second is one preferred way to specify informats that respect delimiters;

data example;
   infile datalines dlm=',';
   length x $ 5;
   informat y z $5.;
   /* a format on an input statement ignores the 
    delimiter because you are forcing a read of 5 columns
   */
   input x $5.  y z;
datalines;
123,abcd,fghijk
;
run;
data example2;
   infile datalines dlm=',';
   length x y z $5.;
   input x  y z;
datalines;
123,abcd,fghijk
;
run;