%PDF-1.5
%
1 0 obj
<>/Metadata 216 0 R/Pages 2 0 R/StructTreeRoot 42 0 R/Type/Catalog>>
endobj
216 0 obj
<>stream
<p>One of the challenges facing statistical agencies is leveraging large volumes of transactional data. A common means of transmitting this type of information is in zipped batches of XML files. This poster describes how the SAS® FILENAME ZIP access method can be used to first read in the XML files from a zipped folder, and then read in and parse the XML data using the FILENAME XML option. This poster also describes the use of the XML Mapper program to generate a schema to parse the data according to the programmers specification. Finally, SAS macro language techniques are applied to further automate the process across all XML files in all zipped folders in a given directory.<br>
<br>
Maura Bardos, Energy Information Administration<br>
<br>
Andrew Thomson, Energy Information Administration<br>
<br>
Andrew Thomson, Energy Information Administration</p>
Session 2800
en
jeff.foxx@sas.com
<p>One of the challenges facing statistical agencies is leveraging large volumes of transactional data. A common means of transmitting this type of information is in zipped batches of XML files. This poster describes how the SAS® FILENAME ZIP access method can be used to first read in the XML files from a zipped folder, and then read in and parse the XML data using the FILENAME XML option. This poster also describes the use of the XML Mapper program to generate a schema to parse the data according to the programmers specification. Finally, SAS macro language techniques are applied to further automate the process across all XML files in all zipped folders in a given directory.<br>
<br>
Maura Bardos, Energy Information Administration<br>
<br>
Andrew Thomson, Energy Information Administration<br>
</p>
2018-04-03T15:47:13.778-04:00
6e2247a471570aba4f90a38fc392092353ab60cd
574936
application/pdf
2018-04-03T15:47:13.967-04:00
Extracting Data from Zipped XML Files with the ZIP and XML FILENAME Options in SAS®
thirdparty
support:sgf-papers
year:2018
industry:2950
software:BASE
support:sgf-papers/session-type/e-poster
support:sgf-papers/skill-level/intermediate
support:sgf-papers/topic/data-management/data-quality
support:customer-roles/statistician
endstream
endobj
2 0 obj
<>
endobj
42 0 obj
<>
endobj
44 0 obj
<>
endobj
43 0 obj
<>
endobj
47 0 obj
[46 0 R 50 0 R 52 0 R 53 0 R 55 0 R]
endobj
58 0 obj
[57 0 R 59 0 R 60 0 R 62 0 R 64 0 R 66 0 R 68 0 R 69 0 R 70 0 R 72 0 R 76 0 R 78 0 R 81 0 R 83 0 R 84 0 R 86 0 R 88 0 R 89 0 R 91 0 R 95 0 R 97 0 R 99 0 R 101 0 R 103 0 R 104 0 R 105 0 R 106 0 R 107 0 R 108 0 R]
endobj
111 0 obj
[110 0 R 112 0 R 113 0 R 115 0 R 117 0 R 119 0 R 120 0 R 122 0 R 126 0 R 128 0 R 131 0 R 133 0 R 135 0 R 137 0 R 138 0 R 140 0 R 141 0 R 143 0 R 145 0 R 148 0 R 150 0 R 153 0 R 155 0 R 160 0 R 163 0 R 164 0 R 165 0 R 166 0 R 167 0 R 168 0 R 169 0 R 170 0 R 171 0 R 172 0 R 173 0 R 174 0 R 175 0 R 176 0 R 177 0 R 178 0 R 179 0 R 180 0 R 181 0 R 182 0 R 183 0 R 184 0 R 186 0 R 188 0 R 190 0 R 192 0 R 194 0 R 196 0 R 198 0 R 199 0 R 200 0 R 201 0 R 202 0 R]
endobj
161 0 obj
<>
endobj
205 0 obj
[204 0 R 207 0 R]
endobj
204 0 obj
<>
endobj
207 0 obj
<>
endobj
206 0 obj
<>
endobj
37 0 obj
<>/MediaBox[0 0 2952 1656]/Parent 2 0 R/Resources<>/Font<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]/XObject<>>>/StructParents 4/Tabs/S/Type/Page>>
endobj
38 0 obj
<>stream
xTMo@#[x F"5vjRFvCZؙ]nF3f̼0b
gSϗRa @DBe4XLZCp
V0k.v
p@*RLat:`WX0@z^H$ UcXUtF|ia-ysfGR2
XR' ~s)`Ұ=4-tb[_>\i
kԚbVb#I=)D+/lENJ3d{ľ|Go_a1nP;oMTA=#~ic/Gfi
ͮ(wJ:._|Dv'uA.+{ChѻD~QeC%#9ac]
Q7dݨQ2ื dmm|wVћɨTb"כ>XmsRרG|k(
endstream
endobj
39 0 obj
<>stream
JFIF ` ` ZExif MM * J Q Q Q C
$.' ",#(7),01444'9=82<.342 C
2!!22222222222222222222222222222222222222222222222222 ` "
} !1AQa"q2#BR$3br
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz
w !1AQaq"2B #3Rbr
$4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ? (O
(
(
(
(
(
(
(Z~qݭ,ǢS@İԮ71GFҴ}&ʄnsB9s/Km|X˟ڮ$ZV
(AEPEPEPEPEPEPEPE.JTvH
RWl'D09sUI9'$I$J1wV~t\Owt
(
(
(
(
(
(
(
(
d/4Ω
p YcgXA &4DCC!
ʖZEn ?ONY=z:
(2
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(
(:((((((*曦jbuw=z&\jbyz 5foZ ]W>MmA}M[HQE2(((((((*\#OMԨ쑾
WURO8`rI'$I$rM%|aԻ+eu?MY}.X' (P( ( ( ( ( ( ( ):
p YcgXA &4DCC!
ʖZEn ?ONY=