Reading/Writing XML files from web to SAS

[sowmya01]

Hi ,

I am new to SAS XML, and trying to read xml file from web url. I am not sure whether i am following the correct process.Could you please help me to understand the step by step process.

Thanks in advance!

[JosvanderVelden]

You could read some documentation about sas and xml.
Ex.: http://support.sas.com/rnd/base/xmlengine/, https://blogs.sas.com/content/sasdummy/2019/04/11/read-rss-feeds/,
https://www.lexjansen.com/nesug/nesug10/ff/ff14.pdf, https://support.sas.com/resources/papers/proceedings15/SAS1871-2015.pdf & https://www.lexjansen.com/mwsug/2011/sas101/MWSUG-2011-S107.pdf
You can download the latest version of the SAS XML Mapper here: https://support.sas.com/downloads/package.htm?pid=2288

[Reeza]

Have you tried this approach?

http://support.sas.com/kb/38/053.html

filename test url 'http://support.sas.com/rnd/base/ods/templateFAQ/temp.xml';
libname test xml;

proc copy in=test out=work; 
run;

proc print;
run;

---

@sowmya01 wrote:

Hi ,

I am new to SAS XML, and trying to read xml file from web url. I am not sure whether i am following the correct process.Could you please help me to understand the step by step process.

Thanks in advance!

---

[sowmya01]

Hi Reeza,

I tried running the sample code and I have got the below error

ERROR: The connection has timed out..

ERROR: Encountered during XMLMap parsing at or near line 1, column 1.

ERROR: XML describe error: Internal processing error.

The XML file will be placed in SFTP location with encrypted format hence it is not recommended to use  FTP(it may corrupt ).When I tried using the below code, SSLPARMS is appearing as red it is not supported for M2 I believe.

proc http
  in= "*************testing prochttp****************"
  method="POST"
  url="***";
  sslparms
    sslcertiss="Glenn's CA"
    sslcertserial="0a1dcfa3000000000015"
  ;
run;

Please let me  know something that capable for M2 version.

[Tom]

I don't think the XML engine can work with streaming data. You will probably need to introduce a step to first copy the XML to a physical file.

[Reeza]

PROC HTTP will copy the data, then you read it. If for whatever reason you cannot use PROC HTTP you can try using X commands. If that's enabled just use your OS to grab the file and then process with SAS.