Date: Tue, 16 Nov 1999 14:38:09 +0100
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Peter Crawford <peter.crawford@DB.COM>
Subject: Re: export sas graph (win 6.12) to Word 97
Content-type: text/plain; charset=us-ascii
If you search the archives on this topic you'll find a
revised converter/filter has been created for the ms- side
which overcame most of these problems
- but-- this is only heresay, because I haven't tested it
Datum: 16.11.99 13:06
Antwort an: firstname.lastname@example.org
Betreff: Re: export sas graph (win 6.12) to Word 97
Hi Richard :
I had noticed the problem with Word 2.0 - Word 6.0 and SAS 6.10 - 6.12
w.r.t. many SAS-drivers.
The problem could not be solved then, but traced to the fact that the
MS-Word import filters, your graph goes through from SAS to Word, are
mediocre products to say it nicely. They do only support certain subsets of
the graph-type just those that MS-EXCEL uses when generating graphs. Hence
importing EXCEL-graphs to Word works, but not importing SAS-graphs.
SPSS , Systat and the like do only use such features that are supported by
the Word import filters (they do recognize the power of MS and
sympathize with their customers. SI does not and continues to use such
features it knows of that they are not supported by MS-Word.)
The point here is that by the SAS-driver the axis text is sent in normal
orientation preceded or followed by a command to rotate it. That command is
not in the subset of commands that the Word-import filter obeys. Hence what
Recently I did not follow the (possible) improvements on both sides
(MS+SI). But almost daily I notice that graphs look much better in SAS than
they do in Word, where SPSS-graphs or Systat-graphs are nearly identical in
the native product and in Word.
My suggestion : Either you have good luck and get a tip that I missed or
you should look for another Graph-file format that works better with Word,
For a book project I had to produce many SAS-graphs and deliver them to the
I did send them in 7 different graph-types (*.wmf, *.eps, *.gif, etc).
It turned out that they used a typesetting program on a MAC that could read
practically all types correctly especially those that I could not read
correctly on my own PC into my MS-Word.
SI is clearly aware of such problems, but believes that MS is at fault here
and that the problems that SAS-users incur are not heavy enough to change
the SAS-drivers into the direction chosen by SPSS or Systat or many others
(because there are many other ways to produce rotated text through a driver).
Werner E. HELM .
At 14:01 15.11.99 -0000, you wrote:
>I am using the CMOF97P driver as specified in the document TS252X 2nd
>edition to export my graph into word 97. My problem lies with the vertical
>axis, the text should rotated to be perpendicular to the axis. When viewed
>in SAS the text is rotated correctly, however when imported into Word 97 the
>text not rotated to be perpendicular to the axis line. Does anyone no a way
>to fix this ? any help appreciated.