%PDF-1.7
%
248 0 obj
<>/Metadata 288 0 R/Pages 245 0 R/StructTreeRoot 61 0 R/Type/Catalog/ViewerPreferences 263 0 R>>
endobj
262 0 obj
<>/Font<>>>/Fields[]>>
endobj
288 0 obj
<>stream
11.0
8.5
7
2019-04-24T14:00:22.361-04:00
Microsoft® Word for Office 365
Ed Summers, Brice Smith, Sean Mealin
4b4239973469c1514b6c9bfd0fdf4f60c60bccce
808078
"SAS data sets, SAS Graphics Accelerator, accessibility, extract tables"
Microsoft® Word for Office 365
<p>Have you ever found a table of data on a web page and wanted to scrape that data into a SAS® data set? This paper shows you how to do it in seconds using SAS® Graphics Accelerator for Google Chrome, which is a free extension for Google Chrome. First, you open the web page in Chrome. Then, you extract data from the table into your Laboratory within SAS Graphics Accelerator for Google Chrome. SAS Graphics Accelerator for Google Chrome automatically derives variable labels from column headings and variable lengths from observations. It also derives variable types if all observations in a column match patterns for a single type. If they dont, you can choose the type of a variable manually. Finally, you generate a SAS program that creates a data set in your WORK library with correct variable labels, lengths, and formats. With SAS Graphics Accelerator for Google Chrome, youll be the fastest data wrangler on the web!</p>
<p>Brice Smith, SAS<br>
Ed Summers, SAS<br>
Sean Mealin, SAS</p>
<p style="font-family: Arial,Helvetica,sans-serif; font-size: 90%; line-height: 300%; margin: -3em 0em 2em 0em;"><a href="https://github.com/sascommunities/sas-global-forum-2019">Access sample code</a></p>
Session 3183
en
jeff
<p>Have you ever found a table of data on a web page and wanted to scrape that data into a SAS® data set? This paper shows you how to do it in seconds using SAS® Graphics Accelerator for Google Chrome, which is a free extension for Google Chrome. First, you open the web page in Chrome. Then, you extract data from the table into your Laboratory within SAS Graphics Accelerator for Google Chrome. SAS Graphics Accelerator for Google Chrome automatically derives variable labels from column headings and variable lengths from observations. It also derives variable types if all observations in a column match patterns for a single type. If they dont, you can choose the type of a variable manually. Finally, you generate a SAS program that creates a data set in your WORK library with correct variable labels, lengths, and formats. With SAS Graphics Accelerator for Google Chrome, youll be the fastest data wrangler on the web!<br>
</p>
<p><a href="https://github.com/sascommunities/sas-global-forum-2019">Access sample code files now</a></p>
<p>Brice Smith, SAS<br>
Ed Summers, SAS<br>
Sean Mealin, SAS</p>
Microsoft® Word for Office 365
2019-04-09T16:05:39.000-04:00
2019-04-09T16:05:39.000-04:00
2019-03-25T11:33:40.000-04:00
application/pdf
SAS data sets, SAS Graphics Accelerator, accessibility, extract tables
2019-04-24T14:00:22.259-04:00
Ed Summers, Brice Smith, Sean Mealin
Have you ever found a table of data on a web page and wanted to scrape that data into a SAS® data set? This paper shows you how to do it in seconds using SAS® Graphics Accelerator for Google Chrome, which is a free extension for Google Chrome. First, you open the web page in Chrome. Then, you extract data from the table into your Laboratory within SAS Graphics Accelerator for Google Chrome. SAS Graphics Accelerator for Google Chrome automatically derives variable labels from column headings and variable lengths from observations. It also derives variable types if all observations in a column match patterns for a single type. If they dont, you can choose the type of a variable manually. Finally, you generate a SAS program that creates a data set in your WORK library with correct variable labels, lengths, and formats. With SAS Graphics Accelerator for Google Chrome, youll be the fastest data wrangler on the web!
Access sample code files now
Brice Smith, SAS
Ed Summers, SAS
Sean Mealin, SAS
World Wide Wrangler: How to Create SAS® Data Sets from HTML Files in Seconds
uuid:32007933-C1C7-4ADB-AF1A-13FECB7BAD32
uuid:33518cca-3bf9-4d65-aba1-3eb3dc6fa88b
sas
support:customer-roles/programmer
support:sgf-papers/topic/programming/general-programming
support:sgf-papers
software:BASE
year:2019
event-type:180/session-type/breakout
endstream
endobj
245 0 obj
<>
endobj
61 0 obj
<>
endobj
263 0 obj
<>
endobj
62 0 obj
<>
endobj
63 0 obj
<>
endobj
64 0 obj
[87 0 R 88 0 R 89 0 R 90 0 R 91 0 R 92 0 R 93 0 R 94 0 R 95 0 R 96 0 R 97 0 R 225 0 R 244 0 R 226 0 R 99 0 R]
endobj
65 0 obj
<>
endobj
66 0 obj
[100 0 R 101 0 R 102 0 R 223 0 R 242 0 R 224 0 R 221 0 R 104 0 R 106 0 R 107 0 R 217 0 R 216 0 R 215 0 R 214 0 R 213 0 R 212 0 R 211 0 R 109 0 R 239 0 R 202 0 R 111 0 R 105 0 R]
endobj
67 0 obj
<>
endobj
68 0 obj
<>
endobj
69 0 obj
[201 0 R 200 0 R 199 0 R 198 0 R 197 0 R 196 0 R 113 0 R 115 0 R 116 0 R 117 0 R 118 0 R 114 0 R]
endobj
70 0 obj
[188 0 R 187 0 R 186 0 R 185 0 R 120 0 R 121 0 R 122 0 R 124 0 R 125 0 R 179 0 R 178 0 R 177 0 R 176 0 R 127 0 R 128 0 R 123 0 R]
endobj
71 0 obj
[129 0 R 131 0 R 132 0 R 170 0 R 169 0 R 134 0 R 130 0 R]
endobj
72 0 obj
[135 0 R 137 0 R 138 0 R 139 0 R 140 0 R 141 0 R 237 0 R 165 0 R 235 0 R 163 0 R 233 0 R 161 0 R 143 0 R 144 0 R 145 0 R 146 0 R 231 0 R 155 0 R 148 0 R 149 0 R 229 0 R 154 0 R 151 0 R 152 0 R 136 0 R]
endobj
73 0 obj
<>
endobj
74 0 obj
<>
endobj
75 0 obj
<>
endobj
76 0 obj
<>
endobj
77 0 obj
<>
endobj
78 0 obj
<>
endobj
79 0 obj
[80 0 R 81 0 R 82 0 R 83 0 R 84 0 R 85 0 R]
endobj
80 0 obj
<>
endobj
81 0 obj
<>
endobj
82 0 obj
<>
endobj
83 0 obj
<>
endobj
84 0 obj
<>
endobj
85 0 obj
<>
endobj
86 0 obj
<>
endobj
22 0 obj
<>/MediaBox[0 0 612 792]/Parent 245 0 R/Resources<>/Font<>/ProcSet[/PDF/Text]>>/Rotate 0/StructParents 16/Tabs/S/Type/Page>>
endobj
23 0 obj
<>stream
HUIo@+DxŋE%KTW=98ŦxoqA\--kUԟ1VO~
4{l/ŷjvk// ~C4 +"6:8/4`5`d@ aIL(r?i*:>%f{C~vj"e?"e'CC4>OxS<&0k!
<7$^x`/Q<&j S!=5y(?ܚ9·7SgNfKwv`3cNB#K )ϺD4}ρ3I =W9Ly~X# M,lΆ$L06 )Jޜ*agIQj0Jb(;=Qu'_ nO
endstream
endobj
274 0 obj
<>
endobj
272 0 obj
<>
endobj
273 0 obj
[352 0 0 0 0 0 0 269 454 454 0 0 364 454 364 454 0 636 636 636 636 636 636 636 0 636 454 0 0 0 0 545 1000 684 686 698 771 632 575 775 751 421 455 693 557 843 748 787 603 0 695 684 616 732 684 989 0 615 0 0 0 0 0 636 0 601 623 521 623 596 352 623 633 272 344 592 272 973 633 607 623 623 427 521 394 633 592 818 592 592 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000]
endobj
265 0 obj
<>
endobj
57 0 obj
<>/BS<>/F 4/Rect[91.35 707.85 207.56 720]/StructParent 15/Subtype/Link>>
endobj
87 0 obj
<>
endobj
88 0 obj
<>
endobj
89 0 obj
<>
endobj
90 0 obj
<>
endobj
91 0 obj
<>
endobj
92 0 obj
<>
endobj
93 0 obj
<>
endobj
94 0 obj
<>
endobj
95 0 obj
<>
endobj
96 0 obj
<>
endobj
97 0 obj
<>
endobj
98 0 obj
<>
endobj
99 0 obj
<>
endobj
100 0 obj
<>
endobj
101 0 obj
<>
endobj
102 0 obj
<>
endobj
103 0 obj
<>
endobj
104 0 obj
<>
endobj
105 0 obj
<>
endobj
106 0 obj
<>
endobj
107 0 obj
<>
endobj
108 0 obj
<>
endobj
109 0 obj
<>
endobj
110 0 obj
<>
endobj
111 0 obj
<>
endobj
112 0 obj
<>
endobj
113 0 obj
<>
endobj
114 0 obj
<>
endobj
115 0 obj
<>
endobj
116 0 obj
<>
endobj
117 0 obj
<>
endobj
118 0 obj
<>
endobj
119 0 obj
<>
endobj
120 0 obj
<>
endobj
121 0 obj
<>
endobj
122 0 obj
<>
endobj
123 0 obj
<>
endobj
124 0 obj
<>
endobj
125 0 obj
<>
endobj
126 0 obj
<>
endobj
127 0 obj
<>
endobj
128 0 obj
<>
endobj
129 0 obj
<>
endobj
130 0 obj
<>
endobj
131 0 obj
<>
endobj
132 0 obj
<>
endobj
133 0 obj
<>
endobj
134 0 obj
<>
endobj
135 0 obj
<>
endobj
136 0 obj
<>
endobj
137 0 obj
<>
endobj
138 0 obj
<>
endobj
139 0 obj
<>
endobj
140 0 obj
<>
endobj
141 0 obj
<>
endobj
142 0 obj
<>
endobj
143 0 obj
<>
endobj
144 0 obj
<>
endobj
145 0 obj
<>
endobj
146 0 obj
<>
endobj
147 0 obj
<>
endobj
148 0 obj
<>
endobj
149 0 obj
<>
endobj
150 0 obj
<>
endobj
151 0 obj
<>
endobj
152 0 obj
<>
endobj
153 0 obj
<>
endobj
15 0 obj
<>/MediaBox[0 0 612 792]/Parent 245 0 R/Resources<>/Font<>/ProcSet[/PDF/Text/ImageC]/XObject<>>>/Rotate 0/StructParents 9/Tabs/S/Type/Page>>
endobj
16 0 obj
<>stream
HWioF+Q6c1"1&ۛ Xe+kD*V_UM1XdwWU.j6bPUZ-؟c./UUlH;-jZ~̅YlS/?%ۡ˞Jr䲌,p%,xl4anF1)s?E~5wWA^\Btca,Iޫ
xIh偟(
xl$0aSw儬pG<s#1O:sOm@s~onq"9b`tW\a)Ă\ey
k>MWx'"x2Dۥ7p<>^饴(D}ė"_Wfm+?d^ZOq#_$
lh7BmS*)ϟn
M.w#ĘE~$͖&&y
/5Óp:H{ mO4A>
*;$3.2~DX`% 7r
t30-=iKwSXyYÎIS@FӜ}e#V&iR-/$:E+W[.JxQ- =XS8'TZ+O@e<%w&:4S!j)
çRzT[<[(JLrISZ1^S=Q
Wu "jCSyYON!7
x(J41ŧZ[*g<@O-e,M|bힿS ֵ٨xo%tQfN!ȥTDcQs+1{,ER}[q^gZ3,_s<jq4{V6Ȣ:qH,|Q՝ǩL2Juc4RiF\
%Q6h"iSl^ZbBhYl1rӠ$jC$hB+Utro%k
@r|ngonG>|/p.05