SAS expertise delivered to your desktop -- on-demand and free!

Join Now

Deeper Dive into SAS Enterprise Guide Reporting

by SAS Employee megak8 ‎05-15-2017 10:44 AM - edited ‎10-12-2017 02:17 PM (1,321 Views)

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.


Watch the webinar


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:

  • Create a simple row and column report.
  • Create a graph or chart and add a prompt.
  • Combine reports in the report builder.


Here are some highlighted questions from the Q&A segment held at the end of the session for ease of reference.


Why is there a yellow triangle over the List?­

The yellow triangle indicates a warning. 


When I take a look at my report builder, I don't have Excel neither do I have PowerPoint. How can I get these options?­

The Output type of SAS Report is the only type of report that is valid for the Report Builder.­


Can the report builder you demonstrated with SAS report be similarly used to create a pdf or other file type?­

Yes – it will involve more coding and ODS techniques.


How recent is this car data?  Hurricane caused many new car sales this year.

This is not new data and is intended to be entirely fictitious.­


How do you get to Data Exploration again please?­

File -> Open -> Data Exploration­.


I am new to SAS. What's the output type of SAS report?­

It's the pre-requisite for using the report builder. It is one of the output options in Tools -> Options -> Results General­.


Once we get the results in Data Exploration, are we able to save the results to Excel or something else?­

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.


Can SAS auto export charts/report periodically (weekly/monthly)? If yes, can it export reports in Excel with customized formats(fonts, color, heading, etc.)?

Yes – you may need to use ODS. Video: Scheduling in SAS Enterprise Guide


Is it possible to freeze columns in an Excel spread sheet?

Once you’re in Excel, you can tap into all its capabilities.


After I get all the tables and graphs produced and create a report from them, how do I get that report into something I can send to non-SAS users?

Right mouse click on your output(s) to email them, publish to a channel, or export into another format on a shared location.


Can we see the code generated by your prompt pie chart?­

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?­

A: Yes.


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


Recommended Resources

Course: SAS Enterprise Guide 1: Querying and Reporting
Course: Creating Reports and Graphs with SAS Enterprise Guide
Book: The Little SAS® Enterprise Guide® Book



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.