SAS.GRAPH 9.1 Reference, Volumes I and II

Embedding ActiveX Graphs in Word Files

The following example demonstrates how the ODS RTF statement can be combined with the ACTIVEX device driver to generate interactive graphics inside Microsoft Word files. The example also shows how user -defined formats can be used to enhance the appearance of graph labels and the headings of PROC PRINT tabular output.

The following example is available in the SAS Sample library under the name GWBAXRTF.

ods rtf file=c:\Public\graph.1\gwbaxrtf.rtf style=torn; goptions dev=activex; PROC FORMAT; value agefmt 0-10=0 to 10 11-12=Pre-Teen 13-15=Mid-Teen 16=late-Teen; value $sexfmt m=Male f=Female; value weightfmt 0-99.9=0-99 lbs 100-119=100-119 lbs 120-149=120-149 lbs 150-999=150 lbs or more; run; data class; set sashelp.class; format age agefmt. sex $sexfmt. weight weightfmt.; label sex=Gender; label height=Average Height (inches); input name sex age height weight; datalines; Alfred m 14 69 112.5 Barbara f 13 65.3 98 Henry m 14 63.5 102.5 Jane f 12 59.8 84.5 John m 12 59 99.5 Joyce f 11 51.3 50.5 Mary f 15 66.5 112 Philip m 16 72 150 Robert m 12 64.8 128 Susan f 11 57.5 85 William m 15 66.5 112 ; run; Title "RTF Output with ActiveX Control"; Title2 "Physical Statistics"; proc gchart data=class; hbar weight / sumvar=height type=mean group=sex discrete; run; quit; Title2 "Formatted Classroom Data"; Proc print data=class; id name; run; ods rtf close;

Generating an Interactive Contour Plot in ActiveX

The following example displays a contour plot of water depth on a small island known as an atoll . The ActiveX Control lets you manipulate many of the aspects of the plot using the menu that is displayed with the right mouse button.

Of note in this example is the way that PROC G3GRID is used to generate a rectangular grid of points.

This example, including the full data set, is available in the SAS Sample Library under the name GWBAXCON.

ods html file="your_web_path/your_HTML_file.htm"; goptions device=activex xpixels=500 ypixels=350 border cback=white gunit=pct htext=3; data atoll; input vdist hdist depth; datalines; 10 0.25 2.77 20 0.25 2.77 30 0.25 2.77 40 0.25 2.77 50 0.25 2.77 60 0.25 2.77 70 0.25 2.77 80 0.25 2.77 90 0.25 2.77 100 0.25 2.77 /* for the full data set, see GWBAXCON */ 62 133.75 5.00 64 135 5.00 64 136.25 5.00 60 138.75 5.08 62 138.75 5.08 ; run; /* Prepare the data to be a rectangular grid */ /* of points. */ proc g3grid data=atoll out=atollgrid; grid vdist*hdist=depth / naxis1=50 naxis2=50; run; title 'Pacific Atoll'; axis1 order=(0 to 150 by 25) c=cx002288 width=3 minor=(n=4) label=('Meters'); axis2 order=(0to 100 by 25) c=cx002288 width=3 minor=(n=4) label=('Meters'); legend1 frame label=(position=top j=c 'Depth (in meters)') shape=line(7); proc gcontour data=atollgrid; plot vdist*hdist=depth / levels = 1 2 2.5 3 3.5 4 4.5 5 7 9 clevels = CXFF0000 CXF07275 CXEC9592 CXE9A2B2 CXE5BFC6 CXBFA0CF CX9981D8 CX7362E1 CX4D43EA CX0000FF legend=legend1 haxis=axis1 vaxis=axis2 des='Atoll'; run; quit;