BookmarkSubscribeRSS Feed
louisehadden
Quartz | Level 8

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

4 REPLIES 4
ballardw
Super User

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

louisehadden
Quartz | Level 8

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>

BillM_SAS
SAS Employee

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

louisehadden
Quartz | Level 8

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!

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1470 views
  • 0 likes
  • 3 in conversation