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

*macro SAS_2_Excel /* SAS Macro Name */
(SAS_input_file =, /* SAS input data to send to Excel */
Excel_template_path =, /* Excel file path */
Excel_template_name =, /* Excel file name */
Excel_template_sheet =Sheet1, /* Excel file sheet name */
Excel_output_path =, /* Output Excel file Path */
Excel_output_name =, /* Name of the output Excel file */
Execl_starting_row =, /* Top left cell of Excel output range */
Excel_starting_column=, /* Bottom right cell of Excel output */
notab=notab /* turn off the tab output option */
);
************************************************************************;
** Actual macro call with parameters **;
************************************************************************;
% SAS_2_Excel /* SAS_input_File - may include dataset options*/
(SAS_input_file = means_output(drop=_TYPE_ _FREQ_),
Excel_template_path = C:\Excel_Files\,
Excel_template_name = Shoe_Summary_Template.xlsx,
Excel_template_sheet = Summary,
Excel_output_path = C:\Excel_Files\,
Excel_output_name = Current_Shoe_Summary.xlsx,
Execl_starting_row = 6 ,
Excel_starting_column= 1 ,
notab=notab
);
run;
Figure 11.6.14 is the output from executing the SAS_2_EXCEL macro. When I wrote the macro, I was
using a computer based on Windows XP and using SAS 9.2 writing to Microsoft Excel 2007. When
working on my final draft of this chapter I was using Microsoft Windows 8.1, SAS 9.4, and Microsoft
Excel 2013. The only change I needed to make to the macro was to point the macro to the new directory
path for Microsoft Excel 2013.
Figure 11.6.14: Output of DDE Processing.