XQuery using SAS

[deleted_user]

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.

[RussAlbright]

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?

[deleted_user]

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?

[ren_s]

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!

[Rama_V]

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.