Apologies - should have done this initially.
So, my original data has the structure of the example below.
-
-
MHHDR0304
123456789012345
260000001200001
IC MH
0000001
2010-02-08
13:07:00
0
-
-
1
XY
ABC
1970-01-01
1970-01-01
ABCDEF
DEF
2
P
1970-01-01
ABCDEF
GHI
ABCDEF
B
1970
-
10001
01
1970-01-01
092
0
0
0
0
0
0
0
0
-
000
000
000
000
000
000
000
003
000
000
000
000
000
AB99 1XY
000
000
000
000
000
E
-
2
XY
ABC
1970-01-01
1970-01-01
99AABCD
GHI
1
D
1970-01-01
ABCDEF
GHI
ABCDEF
A
2006
-
10002
01
1970-01-01
092
0
0
0
0
0
0
0
0
-
000
000
000
000
000
000
000
003
000
000
000
000
000
AB99 1XY
000
000
000
000
000
E
-
MHHDR0000
123456789012345
260000001200001
IC MH
0000001
55
I've used an XML library linked to this file and see that I can register the Header, Body and Trailer tables but cannot see the Table_1, _2 and _3 within the Body.
I've amended the XML as below to get rid of Header, Body and Trailer and successfully register Table_1, _2 and _3.
-
-
1
XY
ABC
1970-01-01
1970-01-01
ABCDEF
DEF
2
P
1970-01-01
ABCDEF
GHI
ABCDEF
B
1970
-
10001
01
1970-01-01
092
0
0
0
0
0
0
0
0
-
000
000
000
000
000
000
000
003
000
000
000
000
000
AB99 1XY
000
000
000
000
000
E
-
2
XY
ABC
1970-01-01
1970-01-01
99AABCD
GHI
1
D
1970-01-01
ABCDEF
GHI
ABCDEF
A
2006
-
10002
01
1970-01-01
092
0
0
0
0
0
0
0
0
-
000
000
000
000
000
000
000
003
000
000
000
000
000
AB99 1XY
000
000
000
000
000
E
My question is (and apologies if this is down to my lack of understanding of XML) - can I use a SAS XML library to register Tables_1, _2 and _3 without having to edit the XML? Or, is there some other way of using SAS to achieve this?
I'm using SAS DI studio 4.21 on Windows.
Thanks again.
Matt
... View more