filename rssmap temp; data _null_; infile datalines; file rssmap; input; put _infile_; datalines; <?xml version="1.0" encoding="windows-1252"?> <SXLEMAP name="RSSMAP" version="2.1"> <NAMESPACES count="0"/> <!-- ############################################################ --> <TABLE name="item"> <TABLE-PATH syntax="XPath">/rss/channel/item</TABLE-PATH> <COLUMN name="title"> <PATH syntax="XPath">/rss/channel/item/title</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>250</LENGTH> </COLUMN> <COLUMN name="link"> <PATH syntax="XPath">/rss/channel/item/link</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>200</LENGTH> </COLUMN> <COLUMN name="pubDate"> <PATH syntax="XPath">/rss/channel/item/pubDate</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>40</LENGTH> </COLUMN> </TABLE> </SXLEMAP> ; run; filename feed temp; proc http method="get" url="https://nps.magicbricks.com/npsScript/nps.js?1.337" out=feed; run; libname result XMLv2 xmlfileref=feed xmlmap=rssmap; data bulletins; set result.item; length date 8; format date datetime20.; date = input( substr(pubDate,4),anydtdtm.); drop pubDate; run; Error in xml
... View more