topic Re: Input file with delimeter ; in SAS Programming

Input file with delimeter ;

reone — Wed, 18 Apr 2012 07:46:49 GMT

Hi to all!!

I need to make an Infile of file txt with delimiter ; .

But when I make the Infile, the SAS programm saves in dataset only half of file dimension.

for examples, if the file has 1388 records, the sas programs reads 1388 records but it saves in dataset only 694 records, and it reads the first records, the third record, the fift record....

jumping the second record, fourth record...... and so on

the lrecl change in any records, and the max lrecl is 340.

Anybody know why it has this behavior?

Re: Input file with delimeter ;

shivas — Wed, 18 Apr 2012 08:27:20 GMT

Hi,

If you can post some sample data.it would help.

Try with this options DSD DLM=';' lrecl=32767

and also look at other infile options.

Thanks,

Shiva

Re: Input file with delimeter ;

reone — Wed, 18 Apr 2012 08:36:37 GMT

Hi Shiva!!

Thanks for your answers, with dsd option it works fine.

Thanks

Rajesh.