Desktop productivity for business analysts and programmers

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

Reply
New Contributor ntp
New Contributor
Posts: 3

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

Hi teams,

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

Thanks in advance.

Valued Guide
Posts: 3,208

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

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.        

---->-- ja karman --<-----
New Contributor ntp
New Contributor
Posts: 3

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

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.

Frequent Contributor
Posts: 91

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

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

New Contributor ntp
New Contributor
Posts: 3

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

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

Valued Guide
Posts: 3,208

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

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

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 5 replies
  • 424 views
  • 4 likes
  • 3 in conversation