Using DDE to Read and Write to Excel Workbooks - Exchanging Data Between SAS and Microsoft Excel - page 185

Figure 11.6.11: The Excel Template for the Example 11.5 Report.

Figure 11.6.13 includes SAS code to execute PROC MEANS, a list of the SAS_2_EXCEL macro default
values, and the coded parameters to execute the example.

Figure 11.6.12: Parameters Descriptions for the SAS_2_EXCEL Macro.

Parameter Name / Default Description

SAS_input_file SAS input data to send to Excel

Excel_template_path Directory path to the input Excel file

Excel_template_name File name of the Input (template) Excel file

Excel_template_sheet =Sheet1 Sheet name of the Excel input (Template) worksheet

Excel_output_path Directory path to the output Excel file

Excel_output_name File name of the Output (final) Excel file

Execl_starting_row Top left row of the output field

Excel_starting_column Top left column of the output field

NOTAB = NOTAB NOTAB suppresses the output of tabs until requested

Figure 11.6.13: The SAS Macro Call and Parameters for the DDE Macro SAS_2_EXCEL.
************************************************************************;
* Example 5 - Writing a full SAS file using a template and DDE macros *;
************************************************************************;
proc means data =sashelp.shoes(keep=region sales inventory returns)
noprint sum nway ;
by region;
output sum =sales inventory returns out =means_output;
run ;

************************************************************************;
************************************************************************;
* Sample macro call with notes about parameters *;
************************************************************************;