Thanks for the information. I still need to investigate what you suggested.   I have captured the “owssvr.iqy” file ( when you click the ‘export to Excel’) and copy the URL in it. Then  ran:   FILENAME sp_tprm  "C:\Users\u407770\prod\data\sp_tprm.XML"; PROC HTTP         URL= 'http://xxxxxx.xxxxx.xxxxx.net/sites/corprisk-opsrisk-038/_vti_bin/owssvr.dll?XMLDATA=1&List={ABF6A9AF-BDE0-4FB9-8741-098CF5C65EBE}&View={254D807D-74C7-44F9-8C33-341527143136}&RowLimit=0&RootFolder=%2fsites%2fcorprisk%2dopsrisk%2d038%2fLists%2fAlternative%20Practice%20Request'      OUT=sp_tprm      AUTH_NTLM      METHOD="GET"; RUN;   “sp_tprm.XML” looks good. Stokke, Delayne H.<Delayne.Stokke@wellsfargo.com> helped me with reading the xml file using the SAS XML mapper to come up with xml map and xml tables. However, he found transcode errors, and was able to read the whole file using SAS 9.4 (Unicode Support). Everything seems working except two fields still contains HTML/XML tags.   Any suggestions?   ... View more