topic Re: From SAS/EIS to MS Office in Microsoft Integration with SAS

From SAS/EIS to MS Office

deleted_user — Thu, 21 Feb 2008 05:52:18 GMT

How it is possible to export the diagram from SAS/EIS 3D Business Graphs in Excel or Word?

Re: From SAS/EIS to MS Office

Cynthia_sas — Thu, 21 Feb 2008 15:58:18 GMT

Hi:
I no longer have SAS/EIS available for testing. If you right click on the graph, is there a choice to save or export???

I believe your best bet for help with this question is to contact Tech Support. If anyone still has EIS available, they will. I have some vague memory that EIS used Java Beans (?) and I can't remember much more about the features available to you.

cynthia

Re: From SAS/EIS to MS Office

deleted_user — Fri, 22 Feb 2008 04:32:46 GMT

There is a choice only snapshot and print.

Re: From SAS/EIS to MS Office

deleted_user — Fri, 22 Feb 2008 04:33:23 GMT

Я послал вопрос в Tech Support. Буду ждать ответа. Может у кого - нибудь был опыт создания отчета в MS Office? Помогите пожалуйста!

Re: From SAS/EIS to MS Office

Cynthia_sas — Fri, 22 Feb 2008 06:04:17 GMT

Hi:
According to Google Translate, your last post says:
"I sent a question to Tech Support. I would wait for a response. Maybe one - something was reportable experience in MS Office? Help please!"

I'm not sure what you're asking for more help on. I still believe that Tech Support is the place where you can get help. Even if it turns out that you can't go directly to Microsoft Office from SAS/EIS, they could help you write code to duplicate the Graph using SAS/Graph syntax and/or ODS Graphics and/or SAS Component Language (SCL).

cynthia

Re: From SAS/EIS to MS Office

deleted_user — Fri, 22 Feb 2008 10:42:50 GMT

I last used EIS graphics for initial tests and proof of concept in V6.12. They had changed a lot by the time I next saw it in SAS8, but by that time I Had a lot of code in catalogs where I generated customised and less clunky graphics from SAS/Graph and replayed them to the EIS desktop.

I think that if I was starting something new and interesting, I would probably look to Rob Allison's site first for guidance. I'm afraid though that I don't like 3d graphics, believing that almost always they distort the message.

For someone with no exposure to SAS/Graph, I agree that the first point of call should be Tech Support.

Kind regards

David

Re: From SAS/EIS to MS Office

deleted_user — Tue, 04 Mar 2008 04:36:50 GMT

When I create the diagram in SAS/GRAPH, it displays Russian font in SAS/Graph Window normally. But when I trying to export it in MS Word through ODS:
options nodate nonumber;
ods rtf file='&file_name' ;
... other statments ....
quit;
ods rtf close;
ods listing;)
the font turns to unintelligible symbols, for example: "Средняя концентрация " turns to "± ≠ ÷ ≥ ÷". Suggest to me please ODS settings for correct export. Thanks in advance for any help. Message was edited by: Ron

Re: From SAS/EIS to MS Office

Cynthia_sas — Tue, 04 Mar 2008 06:00:48 GMT

Hi:
This document has the best font discussion that I've found in regard to SAS/Graph and MS-Office:
http://support.sas.com/techsup/technote/ts674/ts674.html

Tech Support may be the best place for you to find help, as your WHOLE program, your GOPTIONS statement and the device drivers all have to be taken into consideration in order to come up with a solution.

cynthia

Re: From SAS/EIS to MS Office

deleted_user — Tue, 04 Mar 2008 07:46:19 GMT

Thank you Cythnia! It has helped.