topic Re: writing xml using data step cannot write more than 200 character in SAS Programming

writing xml using data step cannot write more than 200 character

Amahareek — Wed, 01 Nov 2017 11:42:03 GMT

while trying to export SAS dataset to xml file in specific schema

i used the below code which works fine in case the whole line length less than 200 character

<tag>+<field_name>+</tag> <=200

else only 200 character from Left hand side are written into the output file

please help as this field can be 4000 character and i cannot write it to the xml this way

or if there is a better way to write xml file using dataset which contain two columns

filename outxml '<file-path>';
data _null_;
set work.<dataset_name> NOBS=lst;
put '<tag>';
if (condition) then put <field_name> '</tag>' ; 
end;
run;

RW9 — Wed, 01 Nov 2017 12:00:12 GMT

Try: data _null_; file "c:\temp.xml" linesize=32767; ... run;

Or filename outxml 'c:\temp.xml' lrecl=32767;

AlanC — Wed, 01 Nov 2017 13:24:02 GMT

Consider using PROC STREAM.

Amahareek — Thu, 02 Nov 2017 06:57:44 GMT

thanks i see it's a good option in case no condition to output if there is any way to put condition before output it would be better

Amahareek — Thu, 02 Nov 2017 07:09:35 GMT

thanks a lot it works with me