Hi Tom, Declared length FIELD_SPECIAL $32767 ; in datastep and it is working as expected Thank you ... View more

Hello, Thanks for the response Value from Dataset: 8822: yhrtahdjdidodjdhsgs 'Gebeew: Harash 2 & 3'Met outgrguytf rocket 'Gebeew: Harash 8 & 9' ward tyehtdhctsf or luhuh edf oea doo Rankedd DOublueh OH abëpogf tyfjjfb.Ir ravel doubl ufhjfnbf kj uhtdgc poyhgdb or do siyufjdkhvnfbg khhff onto ereikendheid Value in XML: 8822: yhrtahdjdidodjdhsgs 'Gebeew: Harash 2 &amp; 3'Met outgrguytf rocket 'Gebeew: Harash 8 &amp; 9' ward tyehtdhctsf or luhuh edf oea doo Rankedd DOublueh OH abëpogf tyfjjfb.Ir ravel doubl ufhjfnbf Truncated portion: kj uhtdgc poyhgdb or do siyufjdkhvnfbg khhff onto ereikendheid XML map used: %macro file_loop(Field_ID); if &Field_ID. not in('.',' ') then Do; if indexc(&Field_ID.,'&%<>') = 0 then do; put '<question>'; put '<answer>' &Field_ID. +(-1) '</answer>'; put '</question>'; End; else Do; put '<question>'; Field_Special = HTMLENCODE(&Field_ID.); put '<answer>' Field_Special +(-1) '</answer>'; put '</question>'; end; End; else Do; put '<question>'; put '<answer/>'; put '</question>'; end; %mend file_loop; Another query is, in data set there is an "&" symbol which is printed as "&amp;" in XML, please help with the same, Thanks in advance ... View more

Hello Ballard,    Thanks for your response. No repetition of account numbers and countries   Account number may have multiple counties ... View more

Thanks Tom, It's working!!!! ... View more

Hi Tom,   Thanks for your response. Am using data set and I have already used the same in my code as below:    data com; file "C:/temp/file1.xml"; put '<?xml version="1.0" encoding="UTF-8"?>';   Thanks ... View more