Default Capabilities Assigned to Roles for the SAS Add-In for
Microsoft Office
|
|
|
|
|
|
|
|
|
|
|
|
|
Open Files from Local
Computer
|
Open a file from the
local file system. This is not a substitute for system security.
|
|
|
|
Open Cube from OLAP
Server
|
Open an OLAP cube source
into a document.
|
|
|
|
|
Open BID indicators
and dashboards in Microsoft Outlook only (EXPERIMENTAL in 5.1).
|
|
|
|
|
Open OLAP cubes in Microsoft
Outlook only (PREPRODUCTION in 5.1).
|
|
|
|
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.
|
|
|
|
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.
|
|
|
|
|
Save content to a SAS
folder.
|
|
|
|
|
Send SAS content in
a mail message, schedule a meeting, or assign a task from Microsoft
Outlook only.
|
|
|
|
|
Save SAS content to
a file from Microsoft Outlook only.
|
|
|
|
|
Print SAS content from
Microsoft Outlook only.
|
|
|
|
1Send SAS Content to Microsoft
Office.
|
Send SAS content to
Microsoft Office applications.
|
|
|
|
|
|
|
|
|
Add or Modify Custom
Code to SAS Tasks
|
Add or modify the custom
code that runs before or after a SAS task.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Modify SAS Server Reference
in Project or Document
|
Change the SAS server
for all SAS content in the document.
|
|
|
|
|
Modify the current security
options for new and existing documents.
|
|
|
|
|
Modify the current e-mail
options for new and existing documents.
|
|
|
|
|
Modify the options in
the SAS Add-In Options dialog box.
|
|
|
|
1Modify Metadata Authorizations
|
Modify the metadata
authorization settings for folders.
|
|
|
|
|
Remove the login from
metadata associated with a server or library.
|
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
Modify the style of
the SAS output.
|
|
|
|
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.
|
|
|
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Change the values and
column properties of a data set in Microsoft Excel.
|
|
|
|
|
Copy an active data
source to SAS servers.
|
|
|
|
|
Create a report that
compares two data sets or compares two variables within or across
data sets.
|
|
|
|
|
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.
|
|
|
|
|
Create an output data
set that contains a random sample of the rows in the input data set.
|
|
|
|
|
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.
|
|
|
|
|
Sort a data source by
any of its columns.
|
|
|
|
|
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.
|
|
|
|
|
Create an output data
set by splitting the unique combination of values of the selected
columns in the input data set into multiple columns.
|
|
|
|
|
Create an output data
set by restructuring selected columns in the input data set so that
these columns are transposed into observations.
|
|
|
|
|
Turn the selected columns
of an input data source into the rows of an output data set.
|
|
|
|
|
|
|
|
|
|
Create detail or summary
reports.
|
|
|
|
|
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.
|
|
|
|
|
Create a summary report,
graphs, and frequency and univariate SAS data sets that describe the
main characteristics of the data.
|
|
|
|
|
Print the observations
in a SAS data set, using all or some of the variables. The user can
create a variety of reports.
|
|
|
|
|
Generate frequency tables
from the data. The user can also use this task to perform binomial
and chi-square tests.
|
|
|
|
|
Compute descriptive
statistics for variables across all observations and within groups
of observations. The user can also summarize data in a graphical display.
|
|
|
|
|
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.
|
|
|
|
|
Generate crosstabulation
tables, also known as contingency tables, from the data.
|
|
|
|
|
|
|
|
|
|
Enables the Automatic
Chart task.
|
|
|
|
|
Create line, filled,
pattern, or smooth plots that show the mathematical relationships
between three numeric variables.
|
|
|
|
|
Create simple bubble
plots. The bubbles are circles of varying proportions at data points
that are plotted on the vertical and the horizontal axes.
|
|
|
|
|
Create radar (or star)
charts that show the relative frequency of data measures in quality
control or market research problems.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Create area, spline,
step, or overlay plots that show the mathematical relationship between
two variables.
|
|
|
|
|
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.
|
|
|
|
|
Create line, scatter,
spline, needle, step, regression, smooth, STD, Lagrange interpolation,
or overlay plots that show the mathematical relationships between
variables.
|
|
|
|
|
Create vertical, horizontal,
or three-dimensional bar charts that compare numeric values or statistics
between different values of a chart variable.
|
|
|
|
|
Create three-dimensional
wireframe plots, smooth plots, or gradient plots that show the mathematical
relationships between three numeric variables.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Create two-dimensional
scatter plots, three-dimensional scatter plots, or three-dimensional
needle plots that show the relationships between two or three variables.
|
|
|
|
|
Create a matrix of scatter
plots.
|
|
|
|
|
Create a tile chart.
Each unique category combination is represented by a rectangular
tile whose size and color are determined by the response variables.
|
|
|
|
1Show ODS Statistical Graph
|
Show ODS Statistical
Graph from an SGD file.
|
|
|
|
|
|
|
|
|
|
Analyze data within
the framework of general linear models. This task uses the method
of least squares to fit general linear models.
|
|
|
|
|
Fit a variety of mixed
linear models to data and to use these fitted models to make statistical
inferences about the data.
|
|
|
|
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.
|
|
|
|
|
Test for differences
among the means of the levels and quantify the differences.
|
|
|
|
|
Perform t-tests for
one sample, two samples, and paired observations.
|
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
Perform linear regression
analysis on multiple dependent and independent variables.
|
|
|
|
|
Investigate the relationship
between discrete responses and a set of explanatory variables.
|
|
|
|
|
Produce least squares
or weighted least squares estimates of the parameters of a nonlinear
model.
|
|
|
|
|
|
|
|
|
|
Examine the relationship
between a linear combination of a set of X variables and a linear
combination of a set of Y variables.
|
|
|
|
|
Create hierarchical
clusters of the observations in a SAS data set that contains either
coordinate data or distance data.
|
|
|
|
|
Determine the relationship
between numeric variables. The relationship is described by calculating
correlation coefficients for the variables.
|
|
|
|
|
Develop a discriminant
criterion that can be used to classify the values of the quantitative
variables into the groups defined by the classification variable.
|
|
|
|
|
Perform a variety of
common factor and component analyses and rotations.
|
|
|
|
|
Examine relationships
among several quantitative variables. This task can be used for summarizing
data and detecting linear relationships.
|
|
|
|
Survival Analysis Category
|
|
|
|
|
|
Compute nonparametric
estimates of the survival distribution of data that may be right-censored
due either to withdrawals or to termination of the study.
|
|
|
|
|
Perform regression analysis
of survival data based on the Cox proportional hazards model.
|
|
|
|
|
|
|
|
|
|
Plot the observed cumulative
distribution function (CDF) of a variable.
|
|
|
|
|
Compare the distribution
of measurements from a process in statistical control to its specification
limits.
|
|
|
|
|
Compare ordered values
of a variable to the quantiles of a specified theoretical distribution,
such as the normal distribution.
|
|
|
|
|
Compare ordered values
of a variable to the percentiles of a specified theoretical distribution,
such as the normal distribution.
|
|
|
|
|
Compare the empirical
cumulative distribution function (ECDF) of a variable to a specified
theoretical cumulative distribution function, such as the normal distribution.
|
|
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
Create c charts for
the numbers of nonconformities (defects) in the subgroup samples.
|
|
|
|
Individual Measurements
Chart
|
Create control charts
for the individual measurements and the moving ranges.
|
|
|
|
|
Create np charts for
the numbers of nonconformities (defects) in the subgroup samples.
|
|
|
|
|
Create p charts for
the proportions of nonconforming (defective) items in the subgroup
samples.
|
|
|
|
|
Create u charts for
the numbers of nonconformities (defects) per inspection unit in the
subgroup samples that contain arbitrary numbers of units.
|
|
|
|
|
Create mean and range
charts for the subgroup means and the subgroup ranges.
|
|
|
|
Mean and Standard Deviation
Chart
|
Create mean and standard
deviation charts for the subgroup means and the subgroup standard
deviations.
|
|
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
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.
|
|
|
|
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.
|
|
|
|
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.
|
|
|
|
|
Convert transactional
data into fixed-interval time series. Transactional data is time-stamped
data that is collected over time with irregular or varied frequency.
|
|
|
|
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.
|
|
|
|
Forecast Studio Open
Project
|
Open the selected series
from an existing SAS Forecast Studio project and specify how to display
the results.
|
|
|
|
Forecast Studio Override
Project
|
Submit overrides for
the forecast data in an existing SAS Forecast Studio project.
|
|
|
|
|
|
|
|
|
|
Score a data set against
an existing SAS Enterprise Miner predictive model.
|
|
|
|
|
Create a predictive
model using SAS Enterprise Miner procedures.
|
|
|
|
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.
|