The EXPORT Procedure

Example 2: Exporting to an Excel Spreadsheet

Procedure features:

PROC EXPORT statement arguments:

	DATA=
	OUTFILE=

This example exports the SAS data set named SASUSER.ACCOUNTS, the first five observations of which follow, and creates an Excel 5 spreadsheet:

Product                        Quantity              Price

Dharamsala Tea                 10 boxes x 20 bags    16.00
Tibetan Barley Beer            24 - 12 oz bottles    19.00
Licorice Syrup                 12 - 550 ml bottles   10.00
Chef Anson's Cajun Seasoning   48 - 6 oz jars        22.00
Chef Anson's Gumbo Mix         36 boxes              21.35

Program

proc export data=sasuser.accounts

outfile="C:\myfiles\Prices.xls"; run;

Chapter Contents
Previous
Next
Top of Page