How to print special characters like %$&&<> in xml file and display in the browser.

[Shantaram]

i am trying below code but special characters are not display in browser.

data transformed_data;
input DC_01 $6. DC_02 $13. DC_03 $9.;
cards;
116312 tosst p%o&ic
118323 tosst Police Mobile
113244 tosst Police Mobile
115333 tosst Police Mobile
118333 tosst Police Mobile
;
run;

data _null_;
set transformed_data;
file "$FSAGQS/QIS_DIBIS/transfers2/TEST_Shan1.xml";
if _n_=1 then do;
put '<?xml version="1.0" encoding="iso-8859-1"?>';
put '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:type="http://www.quinity.com/qis/soap/qisxmlpolicyrequestservice/type">';
Put '<Data>';
put '<answer>';
put '<value>' DC_01 '</value>';
put '</answer>';
put '<answer>';
put '<value>' DC_02 '</value>';
put '</answer>';
Put '</Data>';
end;
run;

Thank You.

[yabwon · Accepted solution]

Hi, maybe try encode the characters:

data transformed_data;
input DC_01 $6. DC_02 $13. DC_03 $9.;
cards;
116312 tosst p%o&ic
118323 tosst Police Mobile
113244 tosst Police Mobile
115333 tosst Police Mobile
118333 tosst Police Mobile
;
run;

data _null_;
set transformed_data;
file "C:\Users\bart\Desktop/TEST_Shan1.xml";
if _n_=1 then do;
put '<?xml version="1.0" encoding="iso-8859-1"?>';
put '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:type="http://www.quinity.com/qis/soap/qisxmlpolicyrequestservice/type">';
end;
Put '<Data>';
put '<answer>';
put '<value>' DC_01 '</value>';
put '</answer>';
put '<answer>';

DC_02x = HTMLENCODE(DC_02);

put '<value>' DC_02x '</value>';
put '</answer>';
Put '</Data>';
run;

Bart

[Shantaram]

Thanks yabwon,

Its not working.

[Shantaram]

Thank you so much Yabwon,
Its working.

[s_lassen]

One possibility is to use the CDATA section marker:

data _null_;
set transformed_data;
file "$FSAGQS/QIS_DIBIS/transfers2/TEST_Shan1.xml";
if _n_=1 then do;
put '<?xml version="1.0" encoding="iso-8859-1"?>';
put '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:type="http://www.quinity.com/qis/soap/qisxmlpolicyrequestservice/type">';
Put '<Data>';
put '<answer>';
put '<value><![CDATA[' DC_01 ']]></value>';
put '</answer>';
put '<answer>';
put '<value><![CDATA[' DC_02' ]]></value>';
put '</answer>';
Put '</Data>';
end;
run;

This way, unless your columns contain the string "]]>", they will be shown faithfully.

[Shantaram]

Thanks s_lassen,

Its working but it will add extra line in the output
like <![CDATA
]]
I don't want to add extra line in to the output.

[Shantaram]

Please help me to solve this issue.

without using CDATA how we can display special characters like %$& etc. in any browser.

Thanks.