Creating Graphs Interactively

If you have Enterprise Guide 2.0 with HotFix 11 or higher installed, you can interactively create graphs within any Windows OLE application, such as Word or Excel, without installing SAS and the SAS/GRAPH procedures. You can drag-and-drop SAS data sets or import data from Microsoft Excel or Access. You can even create your own original data in a table format and pick a standard chart type to view that data.

Creating Graphs

Follow these steps to create graphs interactively.

1. Install Enterprise Guide 2.0 with HotFix 11 or higher.

2. Insert the control for this functionality into your Windows application or embed it in a Web page.

3. Assign the data and select a chart type. You can use SAS, Excel, or Access data.

4. Use any of the available default styles or customize them. If this is a Windows application, you can then either save or print the document from the application.

Inserting the ActiveX Control into Microsoft Word Documents

You can easily incorporate this functionality into a Microsoft Word document. Follow these steps to insert it into the document in the same way that you would insert any other object.

1. In Microsoft Word or Excel, position your cursor where you want your graph, then select

   

2. Select SAS/GRAPH V9 in the Object window. The control for this functionality is inserted into your Word document. Although you see a graph, the control does not yet contain any real data.

3. You can add data to the control in any of the following ways.

   • Drag a SAS, Excel, or Access data file from Windows Explorer and drop it into the control.

   • Open a data file by selecting Data Options from the pop-up menu for the control. In the Data Options window, select Open Data and use the Open window to navigate to your data.

   • Create new data by selecting Data Options from the pop-up menu for the control. Select Open Data in the Data Options window. The control contains default data that enables it to display a graph. To change one of the default variable names , select the column title and enter a new name . To change one of the default variable values, select the cell and enter a new value.

4. Change the orientation of the bar by selecting

   

   from the pop-up menu.

5. Change the graph style by selecting Style Editor from the pop-up menu. In the Style Editor window you can change the style or color scheme that applies to the graph, or both. You can also isolate changes to chart elements, lines, text, or any combination of these. Experiment with the Style Editor. For example, change the style that is assigned in the Style name field.

6. To save the current graph as an image, select Save As from the pop-up menu.

7. To print the current graph, select Print from the pop-up menu.