Default Roles and Capabilities for the SAS Add-In for Microsoft Office

As described in the SAS Intelligence Platform: Security Administration Guide, you can assign users to roles to provide access to selected capabilities in the SAS Add-In for Microsoft Office.
Using SAS Management Console, as described in Administering Roles and Capabilities, you can assign users to roles, change the capabilities that are enabled by each role, and create new roles with unique sets of capabilities.
The User Manager in SAS Management Console provides three default roles for the SAS Add-In for Microsoft Office: Advanced, OLAP, and Analysis. The following table describes the capabilities that are assigned by default to these roles.
Default Capabilities Assigned to Roles for the SAS Add-In for Microsoft Office
Role
Capability
Description
Advanced
OLAP
Analysis
Open or Import Category
Open Files from Local Computer
Open a file from the local file system. This is not a substitute for system security.
X
X
X
Open Cube from OLAP Server
Open an OLAP cube source into a document.
X
X
1Open BID Content
Open BID indicators and dashboards in Microsoft Outlook only (EXPERIMENTAL in 5.1).
1Open Time Series Data
Open OLAP cubes in Microsoft Outlook only (PREPRODUCTION in 5.1).
X
Save or Distribute Category
Modify Output Data Location in SAS Tasks
Change the output data location for the SAS tasks that allow the user to specify an output location.
X
X
Copy and Paste SAS Server Content
Copy and paste from a file on a SAS server or in a SAS library. This is not a substitute for system security.
X
X
Save to SAS Folder
Save content to a SAS folder.
X
X
X
1Email SAS Content
Send SAS content in a mail message, schedule a meeting, or assign a task from Microsoft Outlook only.
X
1Save SAS Content
Save SAS content to a file from Microsoft Outlook only.
X
1Print SAS Content
Print SAS content from Microsoft Outlook only.
X
1Send SAS Content to Microsoft Office.
Send SAS content to Microsoft Office applications.
X
Content Category
Add or Modify Custom Code to SAS Tasks
Add or modify the custom code that runs before or after a SAS task.
X
Comments
Add or modify comments.
X
Options Category
Modify SAS Server Reference in Project or Document
Change the SAS server for all SAS content in the document.
X
X
Modify Security Options
Modify the current security options for new and existing documents.
X
Modify E-mail Options
Modify the current e-mail options for new and existing documents.
X
X
X
Modify All Options
Modify the options in the SAS Add-In Options dialog box.
X
X
X
1Modify Metadata Authorizations
Modify the metadata authorization settings for folders.
X
1Reset Login
Remove the login from metadata associated with a server or library.
X
X
X
Tools and Help Category
Access Unregistered Custom Tasks
Use custom tasks that are not registered in the metadata. By default, these custom tasks will work unless the task is restricted by an administrator.
X
X
X
Modify Styles
Modify the style of the SAS output.
X
X
X
Create or Modify Schedules
Schedule when the SAS content in a document is refreshed. The user can also modify the scheduling options for a document.
X
X
Access SAS Technical Support
Schedule when the SAS content in a document is refreshed. The user can also modify the scheduling options for a document.
X
X
X
Data Category
1Quick Stats
Show Quick Stats.
X
Edit Data Sets
Change the values and column properties of a data set in Microsoft Excel.
X
Copy to SAS Server
Copy an active data source to SAS servers.
X
X
X
Compare Data
Create a report that compares two data sets or compares two variables within or across data sets.
X
X
X
Data Set Attributes
Create a report with the data set's creation date, location, and number of observations as well as the variable names, labels, types, and formats.
X
X
X
Random Sample
Create an output data set that contains a random sample of the rows in the input data set.
X
X
X
Rank
Compute ranks for one or more numeric variables across the observations of a SAS data set and sends the ranks as output to a new SAS data set.
X
X
X
Sort Data
Sort a data source by any of its columns.
X
X
X
Standardize Data
Standardize variables in a data source to a given mean and standard deviation. This task creates a new SAS data set that contains the standardized values.
X
X
X
Split Columns
Create an output data set by splitting the unique combination of values of the selected columns in the input data set into multiple columns.
X
X
X
Stack Columns
Create an output data set by restructuring selected columns in the input data set so that these columns are transposed into observations.
X
X
X
Transpose
Turn the selected columns of an input data source into the rows of an output data set.
X
X
X
Describe Category
List Report Wizard
Create detail or summary reports.
X
X
X
Distribution Analysis
Create a data summary. This task also provides information about the distribution of numeric variables and can be used to create a variety of plots.
X
X
X
Characterize Data
Create a summary report, graphs, and frequency and univariate SAS data sets that describe the main characteristics of the data.
X
X
X
List Data
Print the observations in a SAS data set, using all or some of the variables. The user can create a variety of reports.
X
X
X
One-Way Frequencies
Generate frequency tables from the data. The user can also use this task to perform binomial and chi-square tests.
X
X
X
Summary Statistics
Compute descriptive statistics for variables across all observations and within groups of observations. The user can also summarize data in a graphical display.
X
X
X
Summary Tables
Display descriptive statistics in tabular format, using some or all of the variables in a data set. The user can create a variety of tables.
X
X
X
Table Analysis
Generate crosstabulation tables, also known as contingency tables, from the data.
X
X
X
Graph Category
1Automatic Chart
Enables the Automatic Chart task.
X
Contour Plot
Create line, filled, pattern, or smooth plots that show the mathematical relationships between three numeric variables.
X
X
X
Bubble Plot
Create simple bubble plots. The bubbles are circles of varying proportions at data points that are plotted on the vertical and the horizontal axes.
X
X
X
Radar Chart
Create radar (or star) charts that show the relative frequency of data measures in quality control or market research problems.
X
X
X
Box Plot
Create box plots, hi-lo charts, or hi-lo-close charts that display multiple summary statistics for some numeric variable across different values of a chart variable.
X
X
X
Donut Chart
Create simple or group charts that show the relative contribution of the parts to the whole. The data appears as wedge-shaped slices of a circle.
X
X
X
Area Plot
Create area, spline, step, or overlay plots that show the mathematical relationship between two variables.
X
X
X
Pie Chart
Create simple, group, or stacked charts that represent the relative contribution of the parts to the whole. The data appears as wedge-shaped slices of a circle.
X
X
X
Line Plot
Create line, scatter, spline, needle, step, regression, smooth, STD, Lagrange interpolation, or overlay plots that show the mathematical relationships between variables.
X
X
X
Bar Chart
Create vertical, horizontal, or three-dimensional bar charts that compare numeric values or statistics between different values of a chart variable.
X
X
X
Surface Plot
Create three-dimensional wireframe plots, smooth plots, or gradient plots that show the mathematical relationships between three numeric variables.
X
X
X
Map Chart
Create a two-dimensional (choropleth) or three-dimensional (block and prism) color map that shows the variation in the value of a response variable for different geographical areas.
X
X
X
Bar-Line Chart
Create a vertical bar chart with a line plot overlay. The line plot represents the value of a statistic that is calculated for one of the variables in the input data set.
X
X
X
Scatter Plot
Create two-dimensional scatter plots, three-dimensional scatter plots, or three-dimensional needle plots that show the relationships between two or three variables.
X
X
X
Scatter Plot Matrix
Create a matrix of scatter plots.
X
X
X
Tile Chart
Create a tile chart. Each unique category combination is represented by a rectangular tile whose size and color are determined by the response variables.
X
X
X
1Show ODS Statistical Graph
Show ODS Statistical Graph from an SGD file.
X
X
X
ANOVA Category
Linear Models
Analyze data within the framework of general linear models. This task uses the method of least squares to fit general linear models.
X
X
X
Mixed Models
Fit a variety of mixed linear models to data and to use these fitted models to make statistical inferences about the data.
X
X
X
Nonparametric One-Way ANOVA
Run nonparametric tests for location. The task also scales differences across a one-way classification and provides a standard analysis of variance on the raw data.
X
X
X
One-Way ANOVA
Test for differences among the means of the levels and quantify the differences.
X
X
X
t Test
Perform t-tests for one sample, two samples, and paired observations.
X
X
X
Regression Category
Generalized Linear Models
Model data that is not normally distributed. This task can also model data for which the mean has been restricted to a range of values or data for which the variance is not constant.
X
X
X
Linear Regression
Perform linear regression analysis on multiple dependent and independent variables.
X
X
X
Logistic Regression
Investigate the relationship between discrete responses and a set of explanatory variables.
X
X
X
Nonlinear Regression
Produce least squares or weighted least squares estimates of the parameters of a nonlinear model.
X
X
X
Multivariate Category
Canonical Correlation
Examine the relationship between a linear combination of a set of X variables and a linear combination of a set of Y variables.
X
X
X
Cluster Analysis
Create hierarchical clusters of the observations in a SAS data set that contains either coordinate data or distance data.
X
X
X
Correlations
Determine the relationship between numeric variables. The relationship is described by calculating correlation coefficients for the variables.
X
X
X
Discriminant Analysis
Develop a discriminant criterion that can be used to classify the values of the quantitative variables into the groups defined by the classification variable.
X
X
X
Factor Analysis
Perform a variety of common factor and component analyses and rotations.
X
X
X
Principal Components
Examine relationships among several quantitative variables. This task can be used for summarizing data and detecting linear relationships.
X
X
X
Survival Analysis Category
Life Tables
Compute nonparametric estimates of the survival distribution of data that may be right-censored due either to withdrawals or to termination of the study.
X
X
X
Proportional Hazards
Perform regression analysis of survival data based on the Cox proportional hazards model.
X
X
X
Capability Category
CDF Plots
Plot the observed cumulative distribution function (CDF) of a variable.
X
Histograms
Compare the distribution of measurements from a process in statistical control to its specification limits.
X
Q-Q Plots
Compare ordered values of a variable to the quantiles of a specified theoretical distribution, such as the normal distribution.
X
Probability Plots
Compare ordered values of a variable to the percentiles of a specified theoretical distribution, such as the normal distribution.
X
P-P Plots
Compare the empirical cumulative distribution function (ECDF) of a variable to a specified theoretical cumulative distribution function, such as the normal distribution.
X
Control Charts Category
Box Chart
Create a mean chart for the subgroup means. The task superimposes the box-and-whisker plots of the measurements for each subgroup onto the mean chart.
X
c Chart
Create c charts for the numbers of nonconformities (defects) in the subgroup samples.
X
Individual Measurements Chart
Create control charts for the individual measurements and the moving ranges.
X
np Chart
Create np charts for the numbers of nonconformities (defects) in the subgroup samples.
X
p Chart
Create p charts for the proportions of nonconforming (defective) items in the subgroup samples.
X
u Chart
Create u charts for the numbers of nonconformities (defects) per inspection unit in the subgroup samples that contain arbitrary numbers of units.
X
Mean and Range Chart
Create mean and range charts for the subgroup means and the subgroup ranges.
X
Mean and Standard Deviation Chart
Create mean and standard deviation charts for the subgroup means and the subgroup standard deviations.
X
Pareto Category
Pareto Chart
Create a chart that displays the relative frequency of problems in a process as bars. Pareto charts help the user identify the problems that deserve the most attention.
X
Time Series Category
Prepare Time Series Data
Prepare data for analysis by other time series tasks. It can also be used to perform generic transformations on data that is intended for use in any other tasks.
X
X
X
Basic Forecasting
Generate forecasts for many time series in one step. This task uses extrapolative forecasting methods where the forecasts for a series are functions only of time and past values.
X
X
X
ARIMA Modeling and Forecasting
Analyze and forecast equally spaced univariate time series data, transfer function data, and intervention data by using the ARIMA or ARMA model.
X
X
X
Regression Analysis with Autoregressive Errors
Estimate and forecast linear regression models for time series data when the errors are not independent through time or the error variance is not constant.
X
X
X
Regression Analysis of Panel Data
Estimate and forecast linear regression models for time series data when the errors are not independent through time or the error variance is not constant.
X
X
X
Create Time Series Data
Convert transactional data into fixed-interval time series. Transactional data is time-stamped data that is collected over time with irregular or varied frequency.
X
X
X
Forecast Studio Create Project
Specify the forecasting variables, choose whether to forecast your data hierarchically, and specify the forecast horizon for a new SAS Forecast Studio project.
X
X
Forecast Studio Open Project
Open the selected series from an existing SAS Forecast Studio project and specify how to display the results.
X
X
Forecast Studio Override Project
Submit overrides for the forecast data in an existing SAS Forecast Studio project.
X
X
Data Mining Category
Model Scoring
Score a data set against an existing SAS Enterprise Miner predictive model.
X
X
Rapid Predictive Modeler
Create a predictive model using SAS Enterprise Miner procedures.
X
X
1These capabilities were added for the second edition of the SAS 9.3 version of this document. The second edition applies to the 5.1 release for the majority of the desktop applications.