As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.


From sasCommunity
Revision as of 10:32, 4 October 2017 by Paulkaefer (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Microsoft Excel is a spreadsheet software used by analysts in many fields to view, maintain, and perform analysis on data. It has many business, statistical, and visualization capabilities. For more information, see Wikipedia and/or the Excel website.

Excel to SAS

Proc Import

SAS Libname Engine


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


SAS Libname Engine


Proc Export

SAS Add-in for Microsoft Office [1]

VB Script An example of a SAS macro that writes and runs VB script to accomplish an export to Excel can be found here.

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]

Excel VBA macros

Excel has macro capabilities, not to be confused with SAS macros. They use the Visual Basic for Applications (VBA) language.

Here are some useful links to learn more:

  • This site is great for other tips & tricks


See also

External links