The 10 Most Frequently Asked Questions Of Exporting to Excel

THE 10 MOST FREQUENTLY ASKED QUESTIONS OF EXPORTING TO EXCEL?

CHEVELL PARKER TECHNICAL SUPPORT ANALYST, SAS INSTITUTE INC.

Copyright ? 2012, SAS Institute Inc. All rights reserved.

Overview

? Methods used to Export to Excel ? Highlights of Exporting Features ? Top 10 FAQ's

Copyright ? 2012, SAS Institute Inc. All rights reserved.

Exporting to Excel

E.G

Access

Add-in

ODS

Excel

DDE

Copyright ? 2012, SAS Institute Inc. All rights reserved.

Selecting an Export Method

? ODS destinations: ExcelXP MSOffice2K CSV Other custom tagsets: support.rnd/base/ods/odsmarkup/index.html o Tagsets.MSoffice2K_X o Tagsets.TableEditor

? Dynamic data exchange (DDE): Very flexible ? EXPORT procedure: Use this procedure to read from and write to

Excel files.

Copyright ? 2012, SAS Institute Inc. All rights reserved.

Copyright ? 2012, SAS Institute Inc. All rights reserved.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download