Easy Data Movement between SAS and Microsoft Excel - Exchanging Data Between SAS and Microsoft Excel - page 14

1 filename _temp_ "C:\Users\owner\AppData\Local\Temp\SAS Temporary
Files\_TD3228\#LN00008.xls";
2 ods noresults;
3 ods listing close;
4 ods html file=_temp_ rs=none style=minimal;
NOTE: Writing HTML Body file: _TEMP_
5 proc print data=Sashelp.'Shoes'N label noobs;
6 run;
NOTE: There were 395 observations read from the data set SASHELP.SHOES.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.23 seconds
cpu time 0.12 seconds
7 ods html close;
8 ods results;
9 ods listing;
10 filename _temp_;
NOTE: Fileref _TEMP_ has been deassigned.
11 dm "winexecfile ""C:\Users\owner\AppData\Local\Temp\SAS Temporary
Files\_TD3228\#LN00008.xls"" ";
On computers with Excel 2007 or newer versions installed, the pop-up screen appears to allow you to
verify that you still want to open the file even though the file is not formatted as an Excel file. When you
click on “Yes” to view the data using Microsoft Excel, the output HTML file is opened by Excel. The SAS
option “style=minimal” is applied to the HTML formatted output. It has simple formatting with a header
“The SAS System” in row one and the SAS variable labels in row three. When no labels exist, the variable
names are placed into row three. This output method is handy for getting SAS data directly into Excel
workbooks. But remember that big SAS files may exceed the limits of Excel worksheets, as noted in Table
1.2.1, Microsoft Excel Workbook File Limitations.
Figure 1.4.5: View of the HTML File Opened by Excel.