Excel

From sasCommunity

[edit] Excel to SAS

Proc Import

SAS Libname Engine

 ODBC
 OleDb

[edit] SAS to Excel

There are many ways to get SAS data into Excel. There are also a number of pros and cons with each approach. Below are a number of approaches, each with its pro and con and also examples for how to accomplish a specific task.

ODS ExcelXP Tagset

DDE

SAS Libname Engine

 HTML
 ODBC
 OleDb
 XML

Proc Export

3rd Party Tools

This methodology encompasses a number of approaches using 3rd party tools under any of a number of frameworks (.NET/Java/Perl/Etc.). This approach is arguably the fastest and most flexible approach possible[[1]].

[edit] Reference

Create 10,000 Excel Spreadsheets in 10 Minutes (or less)