topic Re: XQuery using SAS in SAS Data Science

XQuery using SAS

deleted_user — Wed, 06 Jan 2010 07:47:57 GMT

Is there a way to use SAS to run XQuery to query data collections of XML data? I know this can be done using SQL Server, against an xml data field. I'm looking to do the same using SAS. Does anyone know, or can anyone point me to some resource where I can find out more about this? I've tried googling but haven't found anything useful. Thanks in advance for the help.

Re: XQuery using SAS

RussAlbright — Wed, 06 Jan 2010 18:04:52 GMT

I don't think SAS provides direct XQuery support to XML, but SAS does have XML support for data sets. Have you looked into the XML Libname Engine together with the SAS XML Mapper? Maybe you can map the xml fields to SAS variables with these tools, and then convert your XQuery to PROC SQL and query the table that you create?

Re: XQuery using SAS

deleted_user — Wed, 13 Jan 2010 10:05:40 GMT

Thanks RussA@sas. I want to avoid the step of mapping xml fields to SAS variables, for various operational reasons.

So you're saying SAS cannot directly XQuery xml fields in a SQL Server database. How about using XPath?

Re: XQuery using SAS

ren_s — Wed, 05 Sep 2018 11:43:09 GMT

Hi deleted_user,

Many years later, I am facing the same issue with SAS9.3.

Did you manage to query with xquery (without mapping) after all?

If so, how?

Best regards!

Re: XQuery using SAS

Rama_V — Sun, 13 Oct 2019 19:58:35 GMT

This may or may not help now, I have seen XML input node in SAS DataFlux Management Studio tool which runs Xquery to read XML files.