DATA Step, Macro, Functions and more

I can not read the attached XML file

Reply
N/A
Posts: 0

I can not read the attached XML file

I have tried several methods and I am not having any luck reading the attached XML file. It contains some repeating(array) type record structures which may be the problem. Any ideas?? Thanks for the help.... Listed below are some sample records


-
-
9999999
RES
145454546
Test Name1
6559999999999999
RES
MASS
-1
Centerpoint Energy Houston Electric LLC
1586882
19800101
19800101
House
Mobile Home One or Two Bedroom
HARRIS
0
RES
1
RESIDENTIAL DEFAULT
72690009323867
20070926
20070926
20071015



STD-CP05
3539988
20070817
20080817
COMPMMRESREL137GREEN

12
CANCL
TERM
N
N
SIMPLY BETTER EARTH SAVER PLAN
FCP
Call Center
0
0
0
14
0
0
0
20080307
-14

0

0
0
394.36
100.36
394.36
NCO
20071226

N
N








0
20071211
394.36





1

0
0
N
-
-
KWH
0
0
KH
TOT
.132
All
M




-
8888888888
RES
78787878
Test Name2
655777777777
RES
MASS

Centerpoint Energy Houston Electric LLC
449748
20060728
20080904
House

HARRIS
769
RES
1
RESIDENTIAL DEFAULT
82530017771066
20080909
20080909
20080926
COMPMMRESREL137GREEN
20070907
0
RENEW-100% RENEWABLE-CP1
5119789
20070907
20080910
COMPMMRESREL137GREEN
RENEW-DEFAULT-CP1
12
COMPL
TERM
Y
N
SIMPLY BETTER EARTH SAVER PLAN
FCP
Call Center

0
0
0
0
0
0

0

0
Switch-Away

0
53.33
53.33



ACH
N
N








0









0
0
Y
-
-
KWH
0
0
KH
TOT
.132
All
M




-
1111111
RES
232323234
Tes Name3
655123456789000000
RES
MASS
521
Centerpoint Energy Houston Electric LLC
1782796
20080506
20080507
House
1 Story House Three Bedroom
HARRIS
1
RES
1
RESIDENTIAL DEFAULT
83200019422386
20081114
20081115
20081202
COMPMMRESREL137GREEN
20070904
0
WHITE-CP02
4066866
20070904
20080817
COMPMMRESREL137GREEN

12
CANCL
TERM
N
N
SIMPLY BETTER EARTH SAVER PLAN
WhiteFence
Third Party Website
0
0
0
0
0
0
0
20090221
-9.62

0
Force Move-Out
0
0
9.62
9.62




N
N








0
20081205
9.62







0
0
Y
-
-
KWH
0
0
KH
TOT
.132
All
M




-
0000000000121213
RES
13456789
Test Name4
6550987654321
RES
MASS
640
Centerpoint Energy Houston Electric LLC
1782826
20070829
20071211
Apartment
Apartment/Condo Two Bedroom
HARRIS
104
RES
1
RESIDENTIAL DEFAULT
73480010888877
20071214
20071214
20071231
COMPMMRESREL137GREEN
20070829
0
WHITE-CP02
4067477
20070829
20080817
COMPMMRESREL137GREEN

12
CANCL
TERM
N
N
SIMPLY BETTER EARTH SAVER PLAN
WhiteFence
Third Party Website

0
0
14.12
0
15
0
20080322
-240.69

0
Force Move-Out

0
240.69
52.77
240.69
CREDIT SYSTEMS INTERNATIONAL
20080117

N
N








0
20080102
240.69





2
1
0
2
Y
-
-
KWH
0
0
KH
TOT
.132
All
M




-
1012134567
RES
000000001
Test Name5
65598789054
RES
MASS
579
Centerpoint Energy Houston Electric LLC
1234567
20070830
20080424
Apartment
Apartment/Condo Two Bedroom
HARRIS
238
RES
1
RESIDENTIAL DEFAULT
81440014929542
20080523
20080523
20080611
COMPMMRESREL137GREEN
20070830
0
STD-CP05
4285525
20070830
20080817
COMPMMRESREL137GREEN

12
CANCL
TERM
N
N
SIMPLY BETTER EARTH SAVER PLAN
FCP
Call Center
0
0
25
63.62
0
0
0
20080831
-809.67

0
Collections Generated
0
0
809.67
8.78
809.85
CREDIT SYSTEMS INTERNATIONAL
20080627

N
N








0
20080612
809.67





4
1
1
4
Y
-
-
KWH
0
0
KH
TOT
.132
All
M




-
4444444498
RES
55555567
Test Name6
655555555555789
RES
MASS

Centerpoint Energy Houston Electric LLC
2967926
20071130
20080822
Apartment
Apartment/Condo Two Bedroom
HARRIS
266
RES
2
RESIDENTIAL DEFAULT
82390017437668
20080826
20080826
20080912
1R53
20071130
0
STD
9007542
20071130
20080827
1R53
RENEW-DEFAULT-CP1
12
COMPL
TERM
N
N

ADS
Standard-APR
0
0
0
75.08
0
30
0
20081220
-1200.12

0
Force Move-Out
-286.91
0
1200.12
321.67
1200.12

20081121

N
N








0
20081106
1200.12
2
1
0
1
0
6
2
0
2
Y
-
-
KWH
0
2000
KH
TOT
.136
All
M

-
KWH
2001
4000
KH
TOT
.128
All
M




Super Contributor
Super Contributor
Posts: 3,174

Re: I can not read the attached XML file

Share what code you have tried, for more focused response/reply to your post. Also, maybe you can be more specific about which record type(s) are giving you some difficulty -- important to share code and maybe even some SAS log output (pasted in your reply)?

Scott Barry
SBBWorks, Inc.
Super Contributor
Posts: 474

Re: I can not read the attached XML file

Have you provided a XML map for that data?

It seems you have a complex structure in there.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt
N/A
Posts: 0

Re: I can not read the attached XML file

Listed below is my libname statment. The data fields prior to the Energy Price section come in OK. All fields after the Energy Price section come in blank. Thanks..

libname newzz xml "P:\vertzz_fb_html_test.xml" XMLTYPE=ORACLE;
SAS Super FREQ
Posts: 8,743

Re: I can not read the attached XML file

Hi:
This would be a question for Tech Support. I know that SAS and the XML Libname engine can CREATE Oracle-compliant XML -- for OUTPUT. But, with complex XML, even Oracle XML, you may need to still have an XML Map for INPUT -- to read an XML file into a SAS dataset.

To open a track with Tech Support, go here:
http://support.sas.com/ctx/supportform/createForm

cynthia

You can refer to the XMLMap facility and the XMLMapper tool in the documentation and notes here:
http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002592242.htm
http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002592927.htm

And some other info:
http://support.sas.com/kb/33/584.html
http://support.sas.com/rnd/base/xmlengine/index.html
http://support.sas.com/rnd/base/xmlengine/sxle913/index.html
http://support.sas.com/rnd/base/xmlengine/sxle90/#xmlmap
Ask a Question
Discussion stats
  • 4 replies
  • 111 views
  • 0 likes
  • 4 in conversation