%PDF-1.6
%
1412 0 obj
<>/Metadata 1441 0 R/Outlines 153 0 R/Pages 1405 0 R/StructTreeRoot 224 0 R/Type/Catalog>>
endobj
1441 0 obj
<>stream
A new Output Delivery System (ODS) destination for creating Microsoft Excel workbooks is available with SAS® 9.4M3. This destination is an extremely easy and handy tool for producing ad hoc as well as production Excel reports. The ODS EXCEL destination has several advantages over the ODS ExcelXP tagset. With the ODS EXCEL destination, you can bring all those powerful features available with the REPORT procedure, such as predefined styles, trafficlighting, custom formatting, and compute block flexibility, straight into your Excel reports. Once you start using the ODS EXCEL destination, you will quickly realize that the PRINT procedure is not sufficient to meet all the formatting demands for your Excel reports. This paper covers various techniques that you can use with PROC REPORT and the ODS EXCEL destination, to make your Excel reports pretty and publication-ready! <br/><br/>Devi Sekar, RTI International
Session 2479
en
jeff.foxx@sas.com
A new Output Delivery System (ODS) destination for creating Microsoft Excel workbooks is available with SAS® 9.4M3. This destination is an extremely easy and handy tool for producing ad hoc as well as production Excel reports. The ODS EXCEL destination has several advantages over the ODS ExcelXP tagset. With the ODS EXCEL destination, you can bring all those powerful features available with the REPORT procedure, such as predefined styles, trafficlighting, custom formatting, and compute block flexibility, straight into your Excel reports. Once you start using the ODS EXCEL destination, you will quickly realize that the PRINT procedure is not sufficient to meet all the formatting demands for your Excel reports. This paper covers various techniques that you can use with PROC REPORT and the ODS EXCEL destination, to make your Excel reports pretty and publication-ready! <br/><br/>Devi Sekar, RTI International
Acrobat PDFMaker 15 for Word
2018-03-28T13:28:05.000-04:00
2018-03-28T13:28:05.000-04:00
2018-03-28T13:28:01.000-04:00
2018-04-03T15:46:28.085-04:00
d989523ec5bec9f1217181f485ff27f09a9577e7
344914
application/pdf
2018-04-03T15:46:28.223-04:00
Unleash the Power of the REPORT Procedure with the ODS EXCEL Destination
uuid:408b51b6-3564-420d-98e1-e1f0a4101767
uuid:aaa529b9-9342-48fe-875f-193ef2c01b81
1
thirdparty
Adobe PDF Library 15.0
D:20180226132622
support:sgf-papers
year:2018
software:BASE
support:sgf-papers/session-type/breakout
support:sgf-papers/topic/programming/data-presentation
support:customer-roles/programmer
endstream
endobj
153 0 obj
<>
endobj
1405 0 obj
<>
endobj
224 0 obj
<>
endobj
225 0 obj
<>
endobj
226 0 obj
<>
endobj
227 0 obj
<>
endobj
228 0 obj
<>]/P 1277 0 R/Pg 42 0 R/S/Link>>
endobj
229 0 obj
<>]/P 1276 0 R/Pg 42 0 R/S/Link>>
endobj
230 0 obj
<>]/P 1275 0 R/Pg 42 0 R/S/Link>>
endobj
231 0 obj
<><>]/P 1273 0 R/Pg 42 0 R/S/Link>>
endobj
232 0 obj
<>]/P 1270 0 R/Pg 42 0 R/S/Link>>
endobj
233 0 obj
<>]/P 1268 0 R/Pg 42 0 R/S/Link>>
endobj
234 0 obj
<>]/P 1267 0 R/Pg 42 0 R/S/Link>>
endobj
235 0 obj
<>]/P 1266 0 R/Pg 42 0 R/S/Link>>
endobj
236 0 obj
<>]/P 1265 0 R/Pg 42 0 R/S/Link>>
endobj
237 0 obj
<><>]/P 1264 0 R/Pg 42 0 R/S/Link>>
endobj
238 0 obj
<>]/P 744 0 R/Pg 45 0 R/S/Link>>
endobj
239 0 obj
<>
endobj
240 0 obj
<>
endobj
241 0 obj
<>
endobj
242 0 obj
<>
endobj
243 0 obj
<>
endobj
244 0 obj
<>
endobj
245 0 obj
<>
endobj
246 0 obj
<>
endobj
247 0 obj
<>
endobj
248 0 obj
<>
endobj
249 0 obj
<>
endobj
250 0 obj
<>
endobj
251 0 obj
<>
endobj
252 0 obj
<>
endobj
253 0 obj
<>
endobj
254 0 obj
<>
endobj
255 0 obj
<>
endobj
256 0 obj
<>
endobj
257 0 obj
<>
endobj
258 0 obj
<>
endobj
259 0 obj
<>
endobj
260 0 obj
<>
endobj
66 0 obj
<>/Font<>>>/Rotate 0/StructParents 37/Tabs/S/Type/Page>>
endobj
67 0 obj
<>stream
HW]o@}WL|b3"imx&M-oi*v̹8ssϽ\./[&
k7OqnG0ɜiCp!|1)x"٢VYRrÜECcw&ܲ)gj?Zy#e'ѫnJ.Z/Herex1J1GԖritI?Cmgιj'0Lm([?E.zXF
GU8b 6X.=<>~҆g!