topic Re: How to print special characters like %$&<> in xml file and display in the browser. in SAS Programming

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

Shantaram — Tue, 01 Jun 2021 11:13:36 GMT

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.

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

yabwon — Tue, 01 Jun 2021 11:37:51 GMT

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

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

s_lassen — Tue, 01 Jun 2021 19:13:30 GMT

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.

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

Shantaram — Wed, 02 Jun 2021 04:36:00 GMT

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.

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

Shantaram — Wed, 02 Jun 2021 04:36:50 GMT

Thanks yabwon,

Its not working.

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

Shantaram — Fri, 04 Jun 2021 09:50:41 GMT

Please help me to solve this issue.

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

Thanks.

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

Shantaram — Mon, 07 Jun 2021 04:59:38 GMT

Thank you so much Yabwon,
Its working.