<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Reading in XML data in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/Reading-in-XML-data/m-p/19695#M3049</link>
    <description>I have been reading around in the doc and experimenting, but I'm not getting anywhere useful.&lt;BR /&gt;
&lt;BR /&gt;
Sample data =&lt;BR /&gt;
[pre]&lt;BR /&gt;
&lt;BR /&gt;
&lt;PDML version="0" creator="wireshark/0.99.6a"&gt;&lt;BR /&gt;
&lt;PACKET&gt;&lt;BR /&gt;
  &lt;PROTO name="geninfo" pos="0" showname="General information" size="1518"&gt;&lt;BR /&gt;
    &lt;FIELD name="num" pos="0" show="1" showname="Number" value="1" size="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="len" pos="0" show="1518" showname="Packet Length" value="5ee" size="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="caplen" pos="0" show="1518" showname="Captured Length" value="5ee" size="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="timestamp" pos="0" show="May 19, 2008 13:57:00.462153741" showname="Captured Time" value="1211219820.462153741" size="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
  &lt;/PROTO&gt;&lt;BR /&gt;
  &lt;PROTO name="frame" showname="Frame 1 (1518 bytes on wire, 1518 bytes captured)" size="1518" pos="0"&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.time" showname="Arrival Time: May 19, 2008 13:57:00.462153741" size="0" pos="0" show="May 19, 2008 13:57:00.462153741"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.time_delta" showname="Time delta from previous captured frame: 0.000000000 seconds" size="0" pos="0" show="0.000000000"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.time_delta_displayed" showname="Time delta from previous displayed frame: 0.000000000 seconds" size="0" pos="0" show="0.000000000"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.time_relative" showname="Time since reference or first frame: 0.000000000 seconds" size="0" pos="0" show="0.000000000"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.number" showname="Frame Number: 1" size="0" pos="0" show="1"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.pkt_len" showname="Packet Length: 1518 bytes" hide="yes" size="0" pos="0" show="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.len" showname="Frame Length: 1518 bytes" size="0" pos="0" show="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.cap_len" showname="Capture Length: 1518 bytes" size="0" pos="0" show="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.marked" showname="Frame is marked: False" size="0" pos="0" show="0"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.protocols" showname="Protocols in frame: eth:vlan:ip:tcp" size="0" pos="0" show="eth:vlan:ip:tcp"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
  &lt;/PROTO&gt;&lt;BR /&gt;
[/pre]&lt;BR /&gt;
&lt;BR /&gt;
The documentation says to use a libname statement followed by a data step.&lt;BR /&gt;
mine is&lt;BR /&gt;
[pre]&lt;BR /&gt;
LIBNAME xml_in xml "&amp;amp;BaseRP/User/Chuck/Projects/Server/app_1021215380_157_20080519.pdml";&lt;BR /&gt;
 &lt;BR /&gt;
data egtask.indata;&lt;BR /&gt;
  xml_in.proto;&lt;BR /&gt;
run;&lt;BR /&gt;
quit;&lt;BR /&gt;
[/pre]&lt;BR /&gt;
but I keep getting  an error &lt;BR /&gt;
[pre]&lt;BR /&gt;
ERROR: DATA STEP Component Object failure.  Aborted during the COMPILATION phase.&lt;BR /&gt;
NOTE: The SAS System stopped processing this step because of errors.&lt;BR /&gt;
16         data egtask.indata;&lt;BR /&gt;
17           xml_in.proto;&lt;BR /&gt;
             ____________&lt;BR /&gt;
             557&lt;BR /&gt;
ERROR 557-185: Variable xml_in is not an object.&lt;BR /&gt;
[/pre]&lt;BR /&gt;
So, before I try tech support, anyone out there with experience with this?&lt;BR /&gt;
I doing this with a Code task in EG 4.1&lt;/PACKET&gt;&lt;/PDML&gt;</description>
    <pubDate>Wed, 21 May 2008 16:54:22 GMT</pubDate>
    <dc:creator>deleted_user</dc:creator>
    <dc:date>2008-05-21T16:54:22Z</dc:date>
    <item>
      <title>Reading in XML data</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Reading-in-XML-data/m-p/19695#M3049</link>
      <description>I have been reading around in the doc and experimenting, but I'm not getting anywhere useful.&lt;BR /&gt;
&lt;BR /&gt;
Sample data =&lt;BR /&gt;
[pre]&lt;BR /&gt;
&lt;BR /&gt;
&lt;PDML version="0" creator="wireshark/0.99.6a"&gt;&lt;BR /&gt;
&lt;PACKET&gt;&lt;BR /&gt;
  &lt;PROTO name="geninfo" pos="0" showname="General information" size="1518"&gt;&lt;BR /&gt;
    &lt;FIELD name="num" pos="0" show="1" showname="Number" value="1" size="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="len" pos="0" show="1518" showname="Packet Length" value="5ee" size="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="caplen" pos="0" show="1518" showname="Captured Length" value="5ee" size="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="timestamp" pos="0" show="May 19, 2008 13:57:00.462153741" showname="Captured Time" value="1211219820.462153741" size="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
  &lt;/PROTO&gt;&lt;BR /&gt;
  &lt;PROTO name="frame" showname="Frame 1 (1518 bytes on wire, 1518 bytes captured)" size="1518" pos="0"&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.time" showname="Arrival Time: May 19, 2008 13:57:00.462153741" size="0" pos="0" show="May 19, 2008 13:57:00.462153741"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.time_delta" showname="Time delta from previous captured frame: 0.000000000 seconds" size="0" pos="0" show="0.000000000"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.time_delta_displayed" showname="Time delta from previous displayed frame: 0.000000000 seconds" size="0" pos="0" show="0.000000000"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.time_relative" showname="Time since reference or first frame: 0.000000000 seconds" size="0" pos="0" show="0.000000000"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.number" showname="Frame Number: 1" size="0" pos="0" show="1"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.pkt_len" showname="Packet Length: 1518 bytes" hide="yes" size="0" pos="0" show="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.len" showname="Frame Length: 1518 bytes" size="0" pos="0" show="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.cap_len" showname="Capture Length: 1518 bytes" size="0" pos="0" show="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.marked" showname="Frame is marked: False" size="0" pos="0" show="0"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
    &lt;FIELD name="frame.protocols" showname="Protocols in frame: eth:vlan:ip:tcp" size="0" pos="0" show="eth:vlan:ip:tcp"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
  &lt;/PROTO&gt;&lt;BR /&gt;
[/pre]&lt;BR /&gt;
&lt;BR /&gt;
The documentation says to use a libname statement followed by a data step.&lt;BR /&gt;
mine is&lt;BR /&gt;
[pre]&lt;BR /&gt;
LIBNAME xml_in xml "&amp;amp;BaseRP/User/Chuck/Projects/Server/app_1021215380_157_20080519.pdml";&lt;BR /&gt;
 &lt;BR /&gt;
data egtask.indata;&lt;BR /&gt;
  xml_in.proto;&lt;BR /&gt;
run;&lt;BR /&gt;
quit;&lt;BR /&gt;
[/pre]&lt;BR /&gt;
but I keep getting  an error &lt;BR /&gt;
[pre]&lt;BR /&gt;
ERROR: DATA STEP Component Object failure.  Aborted during the COMPILATION phase.&lt;BR /&gt;
NOTE: The SAS System stopped processing this step because of errors.&lt;BR /&gt;
16         data egtask.indata;&lt;BR /&gt;
17           xml_in.proto;&lt;BR /&gt;
             ____________&lt;BR /&gt;
             557&lt;BR /&gt;
ERROR 557-185: Variable xml_in is not an object.&lt;BR /&gt;
[/pre]&lt;BR /&gt;
So, before I try tech support, anyone out there with experience with this?&lt;BR /&gt;
I doing this with a Code task in EG 4.1&lt;/PACKET&gt;&lt;/PDML&gt;</description>
      <pubDate>Wed, 21 May 2008 16:54:22 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Reading-in-XML-data/m-p/19695#M3049</guid>
      <dc:creator>deleted_user</dc:creator>
      <dc:date>2008-05-21T16:54:22Z</dc:date>
    </item>
    <item>
      <title>Re: Reading in XML data</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Reading-in-XML-data/m-p/19696#M3050</link>
      <description>&amp;gt; I have been reading around in the doc and&lt;BR /&gt;
&amp;gt; experimenting, but I'm not getting anywhere useful.&lt;BR /&gt;
&amp;gt; &lt;BR /&gt;
&amp;gt; Sample data =&lt;BR /&gt;
&amp;gt; [pre]&lt;BR /&gt;
&amp;gt; &lt;BR /&gt;
&amp;gt; &lt;PDML version="0" creator="wireshark/0.99.6a"&gt;&lt;BR /&gt;
&amp;gt; &lt;PACKET&gt;&lt;BR /&gt;
&amp;gt; &lt;PROTO name="geninfo" pos="0" showname="General&amp;lt;br&amp;gt;
&amp;gt;  information" size="1518"&gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="num" pos="0" show="1"&gt;&lt;BR /&gt;
&amp;gt;  showname="Number" value="1" size="1518"/&amp;gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="len" pos="0" show="1518"&gt;&lt;BR /&gt;
&amp;gt;  showname="Packet Length" value="5ee" size="1518"/&amp;gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="caplen" pos="0" show="1518"&gt;&lt;BR /&gt;
&amp;gt; showname="Captured Length" value="5ee"&lt;BR /&gt;
&amp;gt;  size="1518"/&amp;gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="timestamp" pos="0" show="May 19, 2008&amp;lt;br&amp;gt;
&amp;gt; 13:57:00.462153741" showname="Captured Time"&gt;&lt;BR /&gt;
&amp;gt;  value="1211219820.462153741" size="1518"/&amp;gt;&lt;BR /&gt;
&amp;gt;  &lt;/FIELD&gt;&lt;BR /&gt;
&amp;gt; &lt;PROTO name="frame" showname="Frame 1 (1518 bytes on&amp;lt;br&amp;gt;
&amp;gt;  wire, 1518 bytes captured)" size="1518" pos="0"&gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="frame.time" showname="Arrival Time:&amp;lt;br&amp;gt;
&amp;gt; May 19, 2008 13:57:00.462153741" size="0" pos="0"&gt;&lt;BR /&gt;
&amp;gt;  show="May 19, 2008 13:57:00.462153741"/&amp;gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="frame.time_delta" showname="Time&amp;lt;br&amp;gt;
&amp;gt; delta from previous captured frame: 0.000000000&amp;lt;br&amp;gt;
&amp;gt;  seconds" size="0" pos="0" show="0.000000000"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="frame.time_delta_displayed"&gt;&lt;BR /&gt;
&amp;gt; showname="Time delta from previous displayed frame:&lt;BR /&gt;
&amp;gt; 0.000000000 seconds" size="0" pos="0"&lt;BR /&gt;
&amp;gt;  show="0.000000000"/&amp;gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="frame.time_relative" showname="Time&amp;lt;br&amp;gt;
&amp;gt; since reference or first frame: 0.000000000 seconds"&gt;&lt;BR /&gt;
&amp;gt;  size="0" pos="0" show="0.000000000"/&amp;gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="frame.number" showname="Frame Number:&amp;lt;br&amp;gt;
&amp;gt;  1" size="0" pos="0" show="1"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="frame.pkt_len" showname="Packet&amp;lt;br&amp;gt;
&amp;gt; Length: 1518 bytes" hide="yes" size="0" pos="0"&gt;&lt;BR /&gt;
&amp;gt;  show="1518"/&amp;gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="frame.len" showname="Frame Length:&amp;lt;br&amp;gt;
&amp;gt;  1518 bytes" size="0" pos="0" show="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="frame.cap_len" showname="Capture&amp;lt;br&amp;gt;
&amp;gt;  Length: 1518 bytes" size="0" pos="0" show="1518"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="frame.marked" showname="Frame is&amp;lt;br&amp;gt;
&amp;gt; marked: False" size="0" pos="0" show="0"&gt;&lt;/FIELD&gt;&lt;BR /&gt;
&amp;gt; &lt;FIELD name="frame.protocols" showname="Protocols&amp;lt;br&amp;gt;
&amp;gt; in frame: eth:vlan:ip:tcp" size="0" pos="0"&gt;&lt;BR /&gt;
&amp;gt;  show="eth:vlan:ip:tcp"/&amp;gt;&lt;BR /&gt;
&amp;gt;  &lt;/FIELD&gt;&lt;BR /&gt;
&amp;gt; /pre]&lt;BR /&gt;
&amp;gt; &lt;BR /&gt;
&amp;gt; The documentation says to use a libname statement&lt;BR /&gt;
&amp;gt; followed by a data step.&lt;BR /&gt;
&amp;gt; mine is&lt;BR /&gt;
&amp;gt; [pre]&lt;BR /&gt;
&amp;gt; LIBNAME xml_in xml&lt;BR /&gt;
&amp;gt; "&amp;amp;BaseRP/User/Chuck/Projects/Server/app_1021215380_157&lt;BR /&gt;
&amp;gt; _20080519.pdml";&lt;BR /&gt;
&amp;gt;  &lt;BR /&gt;
&amp;gt; ata egtask.indata;&lt;BR /&gt;
&amp;gt;   xml_in.proto;&lt;BR /&gt;
&amp;gt; n;&lt;BR /&gt;
&amp;gt; quit;&lt;BR /&gt;
&amp;gt; [/pre]&lt;BR /&gt;
&amp;gt; but I keep getting  an error &lt;BR /&gt;
&amp;gt; [pre]&lt;BR /&gt;
&amp;gt; ERROR: DATA STEP Component Object failure.  Aborted&lt;BR /&gt;
&amp;gt; during the COMPILATION phase.&lt;BR /&gt;
&amp;gt; NOTE: The SAS System stopped processing this step&lt;BR /&gt;
&amp;gt; because of errors.&lt;BR /&gt;
&amp;gt; 16         data egtask.indata;&lt;BR /&gt;
&amp;gt; 17           xml_in.proto;&lt;BR /&gt;
&amp;gt;              ____________&lt;BR /&gt;
&amp;gt; 557&lt;BR /&gt;
&amp;gt; ERROR 557-185: Variable xml_in is not an object.&lt;BR /&gt;
&amp;gt; [/pre]&lt;BR /&gt;
&amp;gt; So, before I try tech support, anyone out there with&lt;BR /&gt;
&amp;gt; experience with this?&lt;BR /&gt;
&amp;gt; I doing this with a Code task in EG 4.1&lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;
Did you intentionally leave off the keyword set?&lt;BR /&gt;
&lt;BR /&gt;
  set xml_in.proto;&lt;/FIELD&gt;&lt;/FIELD&gt;&lt;/FIELD&gt;&lt;/FIELD&gt;&lt;/PROTO&gt;&lt;/FIELD&gt;&lt;/FIELD&gt;&lt;/FIELD&gt;&lt;/PROTO&gt;&lt;/PACKET&gt;&lt;/PDML&gt;</description>
      <pubDate>Wed, 21 May 2008 17:19:29 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Reading-in-XML-data/m-p/19696#M3050</guid>
      <dc:creator>LAP</dc:creator>
      <dc:date>2008-05-21T17:19:29Z</dc:date>
    </item>
    <item>
      <title>Re: Reading in XML data</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Reading-in-XML-data/m-p/19697#M3051</link>
      <description>Sometimes I am such a _________________________ .&lt;BR /&gt;
I can be so blind!&lt;BR /&gt;
&lt;BR /&gt;
ok, new error.  Apparently I need to read some more about XMLMAP</description>
      <pubDate>Wed, 21 May 2008 17:48:14 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Reading-in-XML-data/m-p/19697#M3051</guid>
      <dc:creator>deleted_user</dc:creator>
      <dc:date>2008-05-21T17:48:14Z</dc:date>
    </item>
  </channel>
</rss>

