topic Re: Reading/Writing XML files from web to SAS in New SAS User

Reading/Writing XML files from web to SAS

sowmya01 — Wed, 28 Aug 2019 14:39:37 GMT

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!

Re: Reading/Writing XML files from web to SAS

JosvanderVelden — Wed, 28 Aug 2019 15:24:45 GMT

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

Re: Reading/Writing XML files from web to SAS

Reeza — Wed, 28 Aug 2019 15:28:16 GMT

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!

Re: Reading/Writing XML files from web to SAS

sowmya01 — Thu, 05 Sep 2019 12:26:57 GMT

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.

Re: Reading/Writing XML files from web to SAS

Tom — Thu, 05 Sep 2019 16:23:32 GMT

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.

Re: Reading/Writing XML files from web to SAS

Reeza — Thu, 05 Sep 2019 16:55:47 GMT

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.