The tasks in SAS Enterprise Guide and SAS Add-In for Microsoft Office cover a wide range of SAS capabilities. These SAS tasks are easy-to-use interfaces that create SAS programs to do their work. The programs call on SAS procedures, where each procedure represents a specialized capability. And to make it even more interesting, SAS (the company) provides these procedures in product bundles, which must be separately licensed for customers to use them. With all of this at work, it can be tricky to keep track of which tasks use which procedures that need which SAS products.

The following table lays it all out for you: all the tasks, how to find them in the menu, which procedures they use, and which SAS products are involved.

Task
and
Menu Location
SAS Procedures
and
SAS Products
Import Data
(Excel)

File→Import Data
DATA step; IMPORT

Base SAS
Open
Information Map

File→Open
DATA step

Base SAS
Linear Models

Tasks→ANOVA
GLM

SAS/STAT
Mixed Models

Tasks→ANOVA
MIXED

SAS/STAT
Nonparametric
One-Way
ANOVA

Tasks→ANOVA
NPAR1WAY

SAS/STAT
One-Way
ANOVA

Tasks→ANOVA
ANOVA; GPLOT

SAS/STAT; SAS/GRAPH
t Test

Tasks→ANOVA
TTEST

SAS/STAT
CDF Plots

Tasks--
>Capability
CAPABILITY

SAS/QC
Histograms

Tasks--
>Capability
CAPABILITY

SAS/QC
P-P Plots

Tasks--
>Capability
CAPABILITY

SAS/QC
Probability
Plots

Tasks→Capability
CAPABILITY

SAS/QC
Q-Q Plots

Tasks--
>Capability
CAPABILITY

SAS/QC
Box Chart

Tasks→Control
Charts
SHEWHART

SAS/QC
c Chart

Tasks→Control
Charts
SHEWHART

SAS/QC
Individual
Measurements
Chart

Tasks→Control
Charts
SHEWHART

SAS/QC
Mean and
Range Chart

Tasks→Control
Charts
SHEWHART

SAS/QC
Mean and
Standard
Deviation Chart

Tasks→Control
Charts
SHEWHART

SAS/QC
np Chart

Tasks→Control
Charts
SHEWHART

SAS/QC
p Chart

Tasks→Control
Charts
SHEWHART

SAS/QC
u Chart

Tasks→Control
Charts
SHEWHART

SAS/QC
Append Table

Tasks→Data
SQL

Base SAS
Compare Data

Tasks→Data
COMPARE

Base SAS
Create Format

Tasks→Data
FORMAT

Base SAS
Data Set
Attributes

Tasks→Data
DATASETS

Base SAS
Delete Data
Sets and
Formats

Tasks→Data
DELETE

Base SAS
Download Data
Files to PC

Tasks→Data
SQL

Base SAS
Filter and Sort

Tasks→Data
SQL

Base SAS
Query Builder

Tasks→Data
SQL

Base SAS
Random Sample

Tasks→Data
SURVEYSELECT

SAS/STAT
Rank

Tasks→Data
RANK

Base SAS
Sort Data

Tasks→Data
SORT

Base SAS
Split Columns

Tasks→Data
TRANSPOSE

Base SAS
Stack Columns

Tasks→Data
TRANSPOSE

Base SAS
Standardize
Data

Tasks→Data
STANDARD

Base SAS
Table Analysis

Tasks→Data
FREQ

Base SAS
Transpose

Tasks→Data
TRANSPOSE

Base SAS
Upload Data to
SAS Server

Tasks→Data
SQL

Base SAS
Import from
SPSS

Tasks→Data
IMPORT

SAS/ACCESS
Interface to PC File
Formats
Import from JMP

Tasks→Data
IMPORT

SAS/ACCESS
Interface to PC File
Formats
Import from
Stata

Tasks→Data
IMPORT

SAS/ACCESS
Interface to PC File
Formats
Characterize Data Wizard

Tasks→Describe
CONTENTS;
UNIVARIATE;
FREQ

SAS/STAT
Distribution
Analysis

Tasks→Describe
UNIVARIATE

SAS/STAT
List Data

Tasks→Describe
PRINT

Base SAS
List Report

Tasks→Describe
REPORT

Base SAS
One-Way
Frequencies

Tasks→Describe
FREQ

Base SAS
Summary Statistics

Tasks→Describe
MEANS

Base SAS
Summary Tables

Tasks→Describe
TABULATE

Base SAS
Area Plot

Tasks→Graph
GPLOT

SAS/GRAPH
Bar Chart

Tasks→Graph
GCHART

SAS/GRAPH
Bar-Line Chart

Tasks→Graph
GBARLINE

SAS/GRAPH
Box Plot

Tasks→Graph
GPLOT

SAS/GRAPH
Bubble Plot

Tasks→Graph
GPLOT

SAS/GRAPH
Contour Plot

Tasks→Graph
GCONTOUR

SAS/GRAPH
Create Map
Feature Table

Tasks→Graph
GPROJECT

SAS/GRAPH
Donut Chart

Tasks→Graph
GCHART

SAS/GRAPH
Line Plot

Tasks→Graph
GPLOT

SAS/GRAPH
Map Graph

Tasks→Graph
GMAP

SAS/GRAPH
Pie Chart

Tasks→Graph
GCHART

SAS/GRAPH
Radar Chart

Tasks→Graph
GRADAR

SAS/GRAPH
Scatter Plot

Tasks→Graph
GPLOT; G3D

SAS/GRAPH
Surface Plot

Tasks→Graph
G3D

SAS/GRAPH
Tile Chart

Tasks→Graph
GTILE

SAS/GRAPH
Model Scoring

Tasks→Model Scoring
NONE

SAS Enterprise Miner
Canonical
Correlation

Tasks→
Multivariate
CANCORR

SAS/STAT
Cluster Analysis

Tasks→
Multivariate
CLUSTER, TREE,
FASTCLUS

SAS/STAT
Correlations

Tasks→
Multivariate
CORR

Base SAS
Discriminant Analysis

Tasks→
Multivariate
DISCRIM

SAS/STAT
Factor Analysis

Tasks→
Multivariate
FACTOR

SAS/STAT
Principal
Components

Tasks→Multivariate
PRINCOMP

SAS/STAT
Pareto Chart

Tasks→Pareto
PARETO

SAS/QC
Generalized Linear
Models

Tasks→
Regression
GENMOD

SAS/STAT
Linear Regression

Tasks→
Regression
REG

SAS/STAT
Logistic Regression

Tasks→
Regression
LOGISTIC

SAS/STAT
Nonlinear
Regression

Tasks→
Regression
NLIN

SAS/STAT
Life Tables

Tasks→
Survival Analysis
LIFETEST

SAS/ETS
Proportional
Hazards

Tasks→
Survival Analysis
PHREG

SAS/ETS
ARIMA Modeling
and Forecasting

Tasks→
Time Series
ARIMA

SAS/ETS
Basic Forecasting

Tasks→
Time Series
FORECAST

SAS/ETS
Create Time
Series Data

Tasks→
Time Series
TIMESERIES

SAS/ETS
Forecast Studio
Create Project
Wizard

Tasks→
Time Series
Forecast Studio

SAS
Forecast Server
Forecast Studio
Open Project Wizard

Tasks→Time
Series
Forecast Studio

SAS
Forecast Server
Forecast Studio
Override Wizard

Tasks→Time Series
Forecast Studio

SAS
Forecast Server
Prepare Time
Series Data

Tasks→Time
Series
EXPAND

SAS/ETS
Regression
Analysis of Panel
Data

Tasks→Time
Series
TSCSREG

SAS/ETS
Regression
Analysis with
Autoregressive
Errors

Tasks→Time
Series
AUTOREG

SAS/ETS
Update Library
Metadata

Tools
METALIB

Base SAS
Assign Project
Library

Tools
LIBNAME

Base SAS