SAS^® Enterprise Guide^®

Features

SAS^® graphical user interface

• Intuitive wizards provide access to SAS capabilities from basic reporting to complex analyses.
• Each wizard has a wide range of flexible options that are easily adjusted.
• Results can be delivered in HTML, RTF, PDF, SAS Report and text formats. Most results also can be output as SAS data sets for further analysis with other tasks. SAS Report formats can be shared with SAS Web Report Studio and SAS Add-In for Microsoft Office.
• Graphs can be created as ActiveX (dynamic or image), Java Applets (dynamic or image), GIFs or JPEGs. ActiveX and Java Applets permit direct interaction with the graph objects without resubmitting requests to the server.
• An intuitive process flow diagram facility allows users to organize, view and maintain their projects visually.
• Easily extend the range of business problems that can be quickly solved with the development and deployment of custom tasks that appear alongside the core product functionality.

Reporting, graphical and analytical tasks

• Descriptive reports and analysis: basic listings, summary statistics tables, one-way frequencies tables, correlations tables and graphs, and tabular or graphical distribution analysis.
• Graphs: area chart, bar chart, box plot, bubble plot, donut chart, line plot, map graph, pie chart, radar chart, scatter plot, surface plot and contour plot.
• Analysis of variance (ANOVA) predictive models: t-test, one-way ANOVA, nonparametric one-way ANOVA, linear models and mixed linear models.
• Regression models: linear, logistic, nonlinear and generalized linear models.
• Multivariate relationship models: cluster analysis, factor analysis, principal components, canonical correlation and discriminant function analysis.
• Survival analysis: life table and proportional hazards.
• Capability analysis: CDF plots, histograms, P-P plots, probability plots and Q-Q plots.
• Control charts: mean and range, mean and standard deviation, individual measurements, box, p, np, u and c charts.
• Pareto: Pareto charts.
• Forecasting: data transformation, basic forecasting, ARIMA modeling and forecasting, regression analysis with autoregressive errors and regression analysis of panel data.
• Operations research: numerical optimization, algebraic modeling language, project and resource scheduling, generic algorithms and constraint programming.
• Table analysis.
• Integration with SAS Rapid Predictive Modeler enables business analysts and subject-matter experts to quickly and efficiently create models and perform data preparation tasks.

Data management

• Visually access any data type supported by SAS and native Windows data types via ODBC, OLE DB, OLE DB for OLAP Server (specifically SAS OLAP Server Microsoft Analysis Services and SAP BW), and from MS Exchange mail servers. Accessible local file types include: Microsoft Word documents (embeddable in project files to help document your project work), Excel, HTML, Access, Lotus 123, Paradox, TXT files (fixed width), ASC files (ASCII), TAB delimited files and CSV files (comma delimited).
• Allows easy access of data (local or remote) for use in other SAS products or JMP®.
• Provides access to information maps created in SAS Information Map Studio.
• Powerful, graphical query builder allows users to visually access and manipulate their data without SQL expertise:
  • Join up to 256 tables simultaneously.
  • Graphically or programmatically subset data to reduce the results to manageable sizes and to identify the data you require.
  • Parameterize data to interactively filter the information needed for intelligent decision making.
  • Organize information for easy viewing with a Select and Sort interface. Users can format existing variables and create new calculated variables.
  • Visually build calculated variables from a comprehensive list of SAS functions.
  • Change column order.
  • Preview generated query code, check the query syntax validity or copy the code for reuse in other applications.
• Improved productivity using the program editor with autocomplete and integrated syntax for faster programming.
• Transpose data from long, narrow data to wide, short data, etc.
• Rank your data in multiple ways: absolute, percentile, decile, quartiles, fractional, normal and Savage.
• Perform data subsets using a variety of basic and statistical methods.

OLAP access, visualization and manipulation

• Supports drilling, dynamic slicing and pivoting as needed to explore the information, as well as the ability to drill through to the underlying detailed data.
• Calculation support includes: simple calculations, count analysis, relative contribution analysis and custom calculations (e.g., time series analysis).
• Specific views on multidimensional information can be saved as bookmarks for easy reuse.
• Allows for slices from multidimensional information to be surfaced to other analytical SAS procedures for advanced analysis, including use in data mining procedures.
• Provides an MDX Viewer/Editor for the more advanced users.
• Able to surface OLAP data sources from SAS OLAP Server or other third-party vendors supporting OLE DB for OLAP (e.g., SAP BW and Microsoft Analysis Services).
• Enhanced OLAP analyzer for active/dynamic slicing with SAS Stored Processes.
• Integration with JMP for seamless access to 2-D and 3-D visual analysis.
• Automatic chart options for more meaningful analysis.

Result distribution and sharing

• Distribute results by publishing to multiple channels, including the SAS BI report/content repository, the SAS Stored Process Server, printers, Microsoft Office documents and email.
• Share results in the form of SAS Stored Processes for use in other applications such as SAS Add-In for Microsoft Office, SAS Web Report Studio or other third-party clients.
• Open SAS Web Report Studio reports in a seamless and integrated fashion.
• Export results to other applications such as Adobe Acrobat, Microsoft Access, Excel, Outlook, Word and SharePoint.
• Update analyses and results on a periodic basis using the native Windows scheduler.

Administration and security

• SAS Enterprise Guide can be deployed with SAS Grid Manager to provide automated management of the computing grid with dynamic load balancing, resource assignment and job prioritization.
• SAS Enterprise Guide can be deployed and updated automatically via Microsoft SMS services.

High-performance computing, grid-enablement

• Auto-detect grid environment to automatically use the more efficient grid rather than standard servers.
• Configure GUI Process Flow branches to run in parallel on different grid nodes.
• Analyze SAS programs to optimize performance of code in the grid environment.