topic Re: sas 9.1.3 & office97&pdf exports graph in Microsoft Integration with SAS

sas 9.1.3 & office97&pdf exports graph

deleted_user — Wed, 16 Aug 2006 10:58:16 GMT

Hi,

I would like to properly export graphs and tables under word or pdf.
But when I export to word, I have to manually export the graphs (because of the .gif that is just linked to the file) and when I use pdf I have a graph per page.

May you explain or send me an example of the easest way to combine exports of graphs and tables?

Many thanks,

Ana

Re: sas 9.1.3 & office97&pdf exports graph

deleted_user — Wed, 16 Aug 2006 13:33:54 GMT

I forget to mention that I use a

'By variable'

statement to create the different graphs.

Here is an example:

ods listing close;
goptions dev=sasprtc /*vsize=*/;
/*ods layout x=1 in y=1 in height= in width= in;*/
ods pdf file='C:\hihi.pdf' startpage=no style=analysis;
title;
title1 "Nb by make for the #byval(sector_G) sector" ;
proc gchart data=hehe
/* startpage=never */ /*where=(var1=))*/;
pie var2 / noheader/*sumvar=*/
other=0
/*midpoints=*/
value=none
percent=arrow
slice=arrow
cfill=cyan
;
by &var3;

run;
quit;
/*ods layout end;*/
ods pdf close;
goptions reset=all;
ods listing;

Thank you very much for your help,
Ana

Re: sas 9.1.3 & office97&pdf exports graph

Cynthia_sas — Wed, 16 Aug 2006 17:31:51 GMT

Hi:
The two best documents that I have found, cover PDF and RTF separately. They are Tech Support documents and can be found here:

http://support.sas.com/techsup/technote/ts659/ts659.pdf (PDF)
and
http://support.sas.com/techsup/technote/ts674/ts674.html (Office)

If you have specific problems with your code, and these documents don't help, then Tech Support is your best bet, as they have a lot of expertise in this area.

You can contact Tech Support by referring to this site:
http://support.sas.com/techsup/contact/submit_emits2.html

cynthia

Re: sas 9.1.3 & office97&pdf exports graph

deleted_user — Fri, 18 Aug 2006 11:17:02 GMT

Cynthia,

Thank you very much for your help,

Ana