Did you miss the Ask the Expert session titled Deeper Dive into SAS Enterprise Guide Reporting? Not to worry, you can catch it on-demand at your leisure.
This session assumes that you already have some proficiency with SAS Enterprise Guide, but want to learn more about the tasks that conduct both simple and complex reporting.
During this demonstration, you will learn how to:
Here are some highlighted questions from the Q&A segment held at the end of the session for ease of reference.
The yellow triangle indicates a warning.
The Output type of SAS Report is the only type of report that is valid for the Report Builder.
Yes – it will involve more coding and ODS techniques.
This is not new data and is intended to be entirely fictitious.
File -> Open -> Data Exploration.
It's the pre-requisite for using the report builder. It is one of the output options in Tools -> Options -> Results General.
Right mouse click on the data exploration’s outputs to see your options to copying and saving. Because data exploration is more of an ad hoc task, characterize data and/or distribution analysis tasks are better suited to providing more repeatable operations.
Yes – you may need to use ODS. Video: Scheduling in SAS Enterprise Guide
Once you’re in Excel, you can tap into all its capabilities.
Right mouse click on your output(s) to email them, publish to a channel, or export into another format on a shared location.
Yes – this question was answered verbally at the end of the meeting.
Q: Can you click and drag on the categoricals? Or do you have to use the move arrows?
A: It depends on the wizard – many allow drag and drop.
Q: Hypothetically, if there are blank or null values, how do those get displayed for selection?
A: Enterprise Guide displays nulls as .
Q: I do not have Excel or PPT as an option for results. Is that an add-on to SAS that the organization needs to pay extra for?
A: No, Enterprise Guide version 7.1 automatically creates PDF, Excel, PowerPoint, and other output formats.
Q: The custom reports, can they be saved as PDF and Excel?
A: Yes, Enterprise Guide version 7.1 automatically creates PDF, Excel, PowerPoint, and other output formats.
Q: I work with very large datasets. Do you have any tips for using Data Exploration with larger datasets?
A: Choosing which variable you want to explore is critical.
Q: Is there a way to easily create a report between two datasets?
A; Yes, you’ll want to combine their data together first either via the query builder, append data, DATA step, SQL, or other techniques.
Q: Also, is there a way to copy over reports with new datasets?
A: You can copy tasks and alter the input data’s specifications, use macros – there are several options.
Q: Can we schedule multiple projects to run each month?
Q: Is there a limit of number of projects that you can schedule to run each month? Can we change the schedule time after we schedule those projects?
A: There are no scheduling limits imposed by SAS Enterprise Guide. You can alter any of their execution conditions any time.
Q: Can we compare two sets of code (saved separately) in order to see where there are differences in coding?
A: Version control technologies or other editors are well suited to this operation.
Q: Can you remove all prompts from a project all at once (instead of going one by one to each prompt and delete one at a time)?
A: Yes, use shift-delete or ctrl-delete keys to delete multiple prompts at once.
Q: Hi I try to send output to Excel but encounter this issue: Error message: Unable to send HTML-List data (3)" to Excel. A compatible version of the SAS Add In for MS Office is either not installed or not enable for Excel. How to resolve it?
A: Please contact SAS technical support email@example.com
Want more tips? Be sure to subscribe to the Ask the Expert Community Library to receive follow up Q/A, slides and recordings from other SAS Ask the Expert webinars. From the Ask the Expert Library, just click Subscribe from the orange bar underneath the list of the recent articles.
NOTE: For best results when opening the attached slides, click on the “download” icon.