Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

XQuery using SAS

Reply
N/A
Posts: 0

XQuery using SAS

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.
SAS Employee
Posts: 30

Re: XQuery using SAS

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?
N/A
Posts: 0

Re: XQuery using SAS

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?
Ask a Question
Discussion stats
  • 2 replies
  • 421 views
  • 0 likes
  • 2 in conversation