Database Reference
In-Depth Information
that the next time you process the same file, the formatting will be exactly the same, with no more effort or
programming on your part to make it happen that way.
13.3.6 Build a Control Macro for Each Excel Report
The result of running the SAS code in Figure 13.3.5 is shown here. We are going to build a macro to
produce a bar chart showing all five variables listed in this data.
Figure 13.3.7b: The SASHELP.CLASS Dataset Sorted by SEX and HEIGHT, Displayed in
Excel.
We will start here by recording a macro and saving it into any of the available workbooks. We can save it
anywhere because we are going to export the macro to the disk file C:\My_VBA_macros\ with the name
Class_Graph.
 
Search WWH ::




Custom Search