DATA Step, Macro, Functions and more

Input file with delimeter ;

Accepted Solution Solved
Reply
Contributor
Posts: 22
Accepted Solution

Input file with delimeter ;

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?


Accepted Solutions
Solution
‎04-18-2012 04:27 AM
Super Contributor
Posts: 349

Re: Input file with delimeter ;

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

View solution in original post


All Replies
Solution
‎04-18-2012 04:27 AM
Super Contributor
Posts: 349

Re: Input file with delimeter ;

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

Contributor
Posts: 22

Re: Input file with delimeter ;

Hi Shiva!!

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

Thanks

Rajesh.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 198 views
  • 0 likes
  • 2 in conversation