topic Re: How to combine results into a single document in EG6.1 in SAS Enterprise Guide

How to combine results into a single document in EG6.1

ntp — Tue, 01 Apr 2014 08:11:20 GMT

Hi teams,

Is there a similar function in Enterprise6.1 as the document builder in 3.0 ?

Thanks in advance.

Re: How to combine results into a single document in EG6.1

jakarman — Tue, 01 Apr 2014 09:50:09 GMT

What do you want to achieve? I assume you are referencing the SAP tool document builder?

The used names are somehow equal but the intended usage are completely different. The first thing is to adjust the vocubalary what is used at SAS.
Please tell what you want to achieve in logical steps without referencing old tools.

With Eguide you have:

- a prompting framework as part of EGP project or even better as part of the metadata

- can process and analyze data with a lot of transformations and steps (composing queries)

- do some basic reporting

- compose results in a new lays-out.

- use the ODS parts of SAS (output delivery systems using documents)

It is far more than just put up a simple report

I you are SAS metadata connected there are options to implement on that side e.g . developing stored processed to be used at AMO (Addin Microsoft Office) Word Excel PowerPoint Outlook plugins. You endusers will see MS-office while using SAS.

Re: How to combine results into a single document in EG6.1

nrose — Tue, 01 Apr 2014 11:39:32 GMT

Try this link http://www.pharmasug.org/proceedings/2012/DG/PharmaSUG-2012-DG03.pdf. Its for EG 4.2, but the functions are pretty much the same in 6.1

Re: How to combine results into a single document in EG6.1

ntp — Tue, 01 Apr 2014 19:35:48 GMT

Thanks! The file-new-report can generate what i need in 6.1.

Re: How to combine results into a single document in EG6.1

ntp — Tue, 01 Apr 2014 19:38:01 GMT

Thanks Jaap, i didn't go that far, I just want to create a combined html file for several results in Eguide but thanks for your reply.

Re: How to combine results into a single document in EG6.1

jakarman — Wed, 02 Apr 2014 06:13:31 GMT

Ntp, that is a better question to answer you have several options.

1/ Isolate the SAS-code that does the reporting and run that as one job.

You could use %include statements for calling the SAS sources like being modules/objects.

Disadvantages:

- more work on the SAS-code design

- no archived cache of every results

Advantages:

- When the original data refresh-rate is high (several changes within a day) this approach is able to follow that.

- can be run also outside Eguide. (portal Amo batch or whatever)

2/ Use the ODS document features. Base SAS: ODS, PROC TEMPLATE, and ODS DOCUMENT from Scratch, use proc document replay to compe your desired result

Disadvantages:

- more work on the SAS-code design

- planning on generating the cached docs needed

Advantages:

- cached results available.

- storing displaying data/result as supported by ODS

- can be run also outside Eguide. (portal Amo batch or whatever)

3/ Use the EGuide conbine results option. The link nrose has given.

Disadvantages:

- Only available to run with Eguide. It will be kept as a manual process

Advantages:

- Very quick to be build. Showing the first results.

- results can be transformed later in a ODS approach as mentioned with /2