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 |