01-14-2014 10:00 AM
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?
01-14-2014 06:24 PM
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.
01-15-2014 08:54 AM
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?
01-15-2014 06:03 PM
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.
01-16-2014 09:40 AM
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.....
01-15-2014 08:05 PM
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.
01-16-2014 09:48 AM
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.