Desktop productivity for business analysts and programmers

Reports in EG

Reply
Contributor
Posts: 22

Reports in EG

Hi -

I have created several queries using a data application made in EG 6.1.  Now I would like to create reports using the results of the queries in EG.  I am new to EG though, can this be done?

Thanks,

John

Trusted Advisor
Posts: 1,061

Re: Reports in EG

Hi, John

Yes, reporting is one of the strengths of Enterprise Guide.

I suggest you work through the Enterprise Guide tutorial. In terms of reporting, take a look at the tasks under "Describe". Also, the tasks under "Graph" will let you create a number of different chart types.

Tom

Contributor
Posts: 22

Re: Reports in EG

Thanks for the suggestions, Tom.

I will go through the tutorial today.......I have looked at the options in "Describe" and "Graph" but felt they were somewhat limited......Is it possible to create reports that are not limited in anyway, so that you can choose the parameters to base your report on?

Thanks again!

John

Trusted Advisor
Posts: 1,061

Re: Reports in EG

In my opinion (and I'm sure several of my compatriots will chime in with their own!) there are two ways to produce reports using SAS and Enterprise Guide. The first is using the "procedures", which underlie the tasks in EG. Their names are PRINT, REPORT, TABULATE, MEANS, and FREQ, which sort-of gives an indication of what they're good at. They are canned programs, which offer a lot of options for customization. In my opinion, they are very similar to what you get in a lot of software packages.

The other option is to produce your report using DATA step programming. Doing this is completely flexible, but requires (possibly advanced) programming skills.

If humanly possible, stick with the procedures.

1. Do you have a rough idea of what your report should look like (perhaps mocked up in Excel or Word)? If so, post it, and the contributors can comment.

2. Are there any particular constraints, i.e. are there any reason that elements of your report MUST be in a particular font, colour, location, etc? That could make it difficult to use the procedures. But not necessarily impossible. Believe me, there are people who monitor these posts who are ABSOLUTE GENIUSes at using these procedures.

Tom

Contributor
Posts: 22

Re: Reports in EG

Thank you, Tom.  This is really outstanding advice.  I do have the reports mocked up in excel (well, my boss does!) and I will post them as soon as I can.....

Thanks again,

John

Contributor
Posts: 22

Re: Reports in EG

Hi Tom -

I am trying to upload the mock up but the system will not accept it, it is in .xlsx format which I believe is supported.  Do you have any suggestions?

Thanks!

John

Trusted Advisor
Posts: 1,061

Re: Reports in EG

Maybe take a screen scrape and post them as JPEG?

Respected Advisor
Posts: 3,840

Re: Reports in EG

To add to what wrote:

The EG Wizards under describe are creating SAS code which then gets executed (eg. SAS code for Proc Report). Procedures like Proc Report are very powerful and flexible and the wizards can't take advantage of all the possibilities.

So if the wizards aren't good enough then you need to code. First try and use procedures like Proc Report and only if this is still not sufficient use data step coding. You have quite a bit of learning ahead of you if you want to go for coding and will need some sort of training.

If coding then I'd probably would start with Proc Report: Base SAS(R) 9.4 Procedures Guide, Second Edition

You can use the EG Wizards to generate the initial report and then use the generated code for your amendments.

Contributor
Posts: 22

Re: Reports in EG

Thanks Patrick.  I really appreciate the advice.  I am in the process of developing the reports now......I have mock ups of the reports I am working on and will post them soon.

Thanks again,

John

Ask a Question
Discussion stats
  • 8 replies
  • 454 views
  • 3 likes
  • 3 in conversation