cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jotabe
‎07-02-2018
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How do I modify an existing XML file

by Calcite | Level 5 in SAS Programming
‎06-07-2018 03:53 AM
‎06-07-2018 03:53 AM
Thanks for your reply ChrisNZ.   However, this is the first time I work with XML in SAS and I am quite lost.   I do not know how to "Create a new map and add a new section for the new column" neither "use that map to write out the new table", Also not sure how I can once I have that new table, how I end up with a XML as the one in my example?   I would appreciate a code step by step if that's not too much on how to add the amount = 10 for both, it looks like it must be a couple of easy data steps but I don't know what I should do.   I am trying to see how to do this in the documentation but I cannot see anything similar to what I need, just how to read in XMLs and how to export easy XMLs (with less complexity than the one I have). So if someone could point me out what I should look for in the documentation. This is the first time I struggle with SAS documentation until the point of opening a question in this forum and netiher I find a similar question in the forum... ... View more

How do I modify an existing XML file

by Calcite | Level 5 in SAS Programming
‎06-06-2018 01:34 PM
‎06-06-2018 01:34 PM
Hi all   I have a XML file as follow:   <?xml version="1.0" encoding="Windows-1252"?> <new_examples>     <element_first>         <type>123</type>         <state>1</state>     </element_first>     <examples_list>         <example_element>             <name>a</name>             <status>1</status>         </example_element>         <example_element>             <name>b</name>             <status>3</status>         </example_element>     </examples_list> </new_examples>   Then I have a table Table1 like: Name Amount a         3 b         12   And I want to add the amount to the XML so I end up with: <?xml version="1.0" encoding="Windows-1252"?> <new_examples>     <element_first>         <type>123</type>         <state>1</state>     </element_first>     <examples_list>         <example_element>             <name>a</name>             <status>1</status>             <amount>3</amount>         </example_element>         <example_element>             <name>b</name>             <status>3</status>             <amount>12</amount>         </example_element>     </examples_list> </new_examples>   I read the XML as:   filename xx temp; libname xx xmlv2 '\\path\test_xml' automap=replace xmlmap=xx;     It lets me access the information of the XML in SAS, having the table example_element with the two example_element in the list.   But then I don't know how I can modify the XML as if I try to overwrite the table xx.example_element but it does not work.   I am trying first to do a dummy example adding a fixed amount = 10 in all the example_element like:   data xx.example_element; set xx.example_element; amount = 10; run; This is the log:   WARNING: Output column amount does not occur in XMLMap definition of table example_element. ERROR: XMLMap for output table example_element requested but that table did not exist in the XMLMap output section. ERROR: Invalid sequence of commands for file XX.example_element.DATA.       I am using SAS Enterprise Guide 7.1 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-02-2018 05:16 AM
Quick links