Architecting, installing and maintaining your SAS environment

Problems with XML Mapper between 9.3 and 9.4?

Reply
Contributor
Posts: 47

Problems with XML Mapper between 9.3 and 9.4?

I've already encountered compatibility problems with moving data sets between SAS 9.4 64 bit and SAS 9.2 32 bit (solution PROC MIGRATE) but am now also experiencing problems with XML mapper between 9.3 and 9.4.  Has anyone else experienced the same?  And/or found a solution?  I output 3 different file structures to XML each month to be posted on a government website.  The larger files are working fine - it is just the very small file that cannot be used if created in SAS 9.4.  Thanks in advance for any advice.

Louise

Super User
Posts: 11,343

Re: Problems with XML Mapper between 9.3 and 9.4?

Posted in reply to louisehadden

I think you'll have to provide some details on what isn't appearing or whatnot in that "small file".

Contributor
Posts: 47

Re: Problems with XML Mapper between 9.3 and 9.4?

It's almost as if SAS is trying to be smart and collapse nodes that have the same information.

SAS 9.3 version (uses same map and program as 9.4 version below)

<?xml version="1.0" encoding="windows-1252" ?>

<!--

SAS XML Libname Engine (SAS92XML)

SAS XMLMap Generated Output

Version 9.03.01M1P11022011

Created 2014-05-15T15:59:17

-->

<MeasureDateDetails xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<HeaderInformation>

<DataSource>Abt - Nursing Home Compare - Measure Dates</DataSource>

<DateCreated>05/01/2014</DateCreated>

<MeasureDatesCount>21</MeasureDatesCount>

</HeaderInformation>

<MeasureDate>

<MeasureCD>424</MeasureCD>

<StartQuarter>Q12013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>01/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>425</MeasureCD>

<StartQuarter>Q12013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>01/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>426</MeasureCD>

<StartQuarter>Q12013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>01/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>430</MeasureCD>

<StartQuarter>Q12013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>01/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>434</MeasureCD>

<StartQuarter>Q12013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>01/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>410</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>407</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>402</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>403</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>405</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>406</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>409</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>401</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>404</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>408</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>411</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>415</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>419</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>04/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>C_CMPL</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<EndQuarter>Q22014</EndQuarter>

<StartDate>05/01/2013</StartDate>

<EndDate>04/30/2014</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>P1_CMPL</MeasureCD>

<StartQuarter>Q22012</StartQuarter>

<EndQuarter>Q22013</EndQuarter>

<StartDate>05/01/2012</StartDate>

<EndDate>04/30/2013</EndDate>

</MeasureDate>

<MeasureDate>

<MeasureCD>P2_CMPL</MeasureCD>

<StartQuarter>Q22011</StartQuarter>

<EndQuarter>Q22012</EndQuarter>

<StartDate>05/01/2011</StartDate>

<EndDate>04/30/2012</EndDate>

</MeasureDate>

</MeasureDateDetails>

SAS 9.4 version (uses same map and program as 9.3 version)

<?xml version="1.0" encoding="windows-1252" ?>

<!--

SAS XML Libname Engine (SAS92XML)

SAS XMLMap Generated Output

Version 9.04.01M1P12042013

Created 2014-06-03T14:49:57

-->

<MeasureDateDetails xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<HeaderInformation>

<DataSource>Abt - Nursing Home Compare - Measure Dates</DataSource>

<DateCreated>06/01/2014</DateCreated>

<MeasureDatesCount>21</MeasureDatesCount>

</HeaderInformation>

<MeasureDate>

<MeasureCD>424</MeasureCD>

<StartQuarter>Q12013</StartQuarter>

<EndQuarter>Q42013</EndQuarter>

<StartDate>01/01/2013</StartDate>

<EndDate>12/31/2013</EndDate>

<MeasureCD>425</MeasureCD>

<MeasureCD>426</MeasureCD>

<MeasureCD>430</MeasureCD>

<MeasureCD>434</MeasureCD>

<MeasureCD>410</MeasureCD>

<StartQuarter>Q22013</StartQuarter>

<StartDate>04/01/2013</StartDate>

<MeasureCD>407</MeasureCD>

<MeasureCD>402</MeasureCD>

<MeasureCD>403</MeasureCD>

<MeasureCD>405</MeasureCD>

<MeasureCD>406</MeasureCD>

<MeasureCD>409</MeasureCD>

<MeasureCD>401</MeasureCD>

<MeasureCD>404</MeasureCD>

<MeasureCD>408</MeasureCD>

<MeasureCD>411</MeasureCD>

<MeasureCD>415</MeasureCD>

<MeasureCD>419</MeasureCD>

<MeasureCD>C_CMPL</MeasureCD>

<EndQuarter>Q22014</EndQuarter>

<StartDate>06/01/2013</StartDate>

<EndDate>05/31/2014</EndDate>

<MeasureCD>P1_CMPL</MeasureCD>

<StartQuarter>Q22012</StartQuarter>

<EndQuarter>Q22013</EndQuarter>

<StartDate>06/01/2012</StartDate>

<EndDate>05/31/2013</EndDate>

<MeasureCD>P2_CMPL</MeasureCD>

<StartQuarter>Q22011</StartQuarter>

<EndQuarter>Q22012</EndQuarter>

<StartDate>06/01/2011</StartDate>

<EndDate>05/31/2012</EndDate>

</MeasureDate>

</MeasureDateDetails>

SAS Employee
Posts: 35

Re: Problems with XML Mapper between 9.3 and 9.4?

Posted in reply to louisehadden

Can you supply the original files and SAS statements so I can try and reproduce the problem?

Contributor
Posts: 47

Re: Problems with XML Mapper between 9.3 and 9.4?

Posted in reply to BillM_SAS

I submitted this to tech support and there is a problem - it actually started in SAS 9.3M2 (we migrated from SAS 9.3M1 to SAS 9.4).  Tech support is working on it.  Meanwhile I'm running this program in SAS 9.3M1.  Thanks for your offer of help!

Ask a Question
Discussion stats
  • 4 replies
  • 592 views
  • 0 likes
  • 3 in conversation