topic Re: .XML file created with file statement and dataset, has unexpected line breaks in SAS Programming

.XML file created with file statement and dataset, has unexpected line breaks

akash1088 — Thu, 13 Sep 2018 12:11:43 GMT

I am creating a .XML using file options and when opened file in notepad it has line breaks for longer rows. When line breaks are removed it gives a correct XML file.

Re: .XML file created with file statement and dataset, has unexpected line breaks

RW9 — Thu, 13 Sep 2018 12:20:09 GMT

I am struggling to find a question here?

Re: .XML file created with file statement and dataset, has unexpected line breaks

akash1088 — Thu, 13 Sep 2018 12:33:19 GMT

So basically my requirement is to create a xblr file.
So I am creating xblr file with the help of put statement and giving file extension is .XML and some of the line in that file is very long due to that it is truncate in next line and we are getting some error to solve this issue we are manually making changes in that truncate line.
so is there any options or method to resolve this issue.

Previously I also face this issue(while creating.txt file) but with the help of termstr=crlf and that issue got solved.

Re: .XML file created with file statement and dataset, has unexpected line breaks

Tom — Thu, 13 Sep 2018 12:54:57 GMT

I am not sure why it should matter if there are extra line breaks. Those should be irrelevant to the XML format.

Most likely you just did not set a long enough line length. The PUT statement will insert a line break if the current text you are trying to write will make the current line longer than the record length you told it to create.

What value did you use for the LRECL= option on your FILE statement? Set it to something larger, like 10000000.

If that is not long enough then just tell SAS not to write any line breaks by setting RECFM=N. You could always put out some actual CR+LF characters yourself if you want to make the XML more readable for humans.

Re: .XML file created with file statement and dataset, has unexpected line breaks

andreas_lds — Thu, 13 Sep 2018 12:42:57 GMT

If "very long" is greater than 32000, avoiding breaks is afaik not possible.

else: check linesize-option of the infile-statement.