topic Re: How to convert xml to url in SAS Programming

How to convert xml to url

shlomiohana — Thu, 13 Jul 2023 09:29:22 GMT

Hi,
How can i convert XML to URL with sas?

Example:
Xml:
<?xml version="1.0" encoding="UTF-8"?>
<SMF_REQUEST_PARAMS>
<customerIdType>1</customerIdType>
<customerId>312755468</customerId>
</SMF_REQUEST_PARAMS>

URL CONVERT:
%3C%3Fxml%20version%3D%221.0%22%20encoding%3D%22UTF-8%22%3F%3E%0A%0A%3CSMF_REQUEST_PARAMS%3E%0A%0A%20%20%20%3CcustomerIdType%3E1%3C%2FcustomerIdType%3E%0A%0A%20%20%20%3CcustomerId%3E312755468%3C%2FcustomerId%3E%0A%0A%3C%2FSMF_REQUEST_PARAMS%3E

Thanks.

Re: How to convert xml to url

FreelanceReinh — Thu, 13 Jul 2023 12:00:39 GMT

Hi @shlomiohana,

You can use the URLENCODE function:

data have;
input xml $80.;
cards;
<?xml version="1.0" encoding="UTF-8"?>
<SMF_REQUEST_PARAMS>
<customerIdType>1</customerIdType>
<customerId>312755468</customerId>
</SMF_REQUEST_PARAMS>
;

data want;
set have end=last;
length url $1000;
url=catt(url,urlencode(trim(xml)));
if last;
retain url;
run;

If you really need the double linefeed characters (hex 0A) representing the line breaks, insert

if not last then url=catt(url,'%0A%0A');

before the subsetting IF statement if last.

Your sample output also shows some blanks (hex 20) after line 2 and 3. To reproduce this in this particular example, you could insert a second IF statement:

if _n_ in (2, 3) then url=catt(url,'%20%20%20');

but I don't think this is useful.

Re: How to convert xml to url

Ksharp — Thu, 13 Jul 2023 12:07:01 GMT

data have;
have='<?xml version="1.0" encoding="UTF-8"?>
<SMF_REQUEST_PARAMS>
<customerIdType>1</customerIdType>
<customerId>312755468</customerId>
</SMF_REQUEST_PARAMS>';
want=urlencode(have);
run;