Your version of SAS Enterprise Guide or SAS Add-In for Microsoft Office might not include all of the tasks listed here. The availability of a task depends on whether the necessary SAS software is licensed and installed at your site. For more information, contact your system administrator.
Note: If your site licenses and installs SAS Studio, additional tasks might be available. For more information, see SAS Studio Tasks and Associated Procedures and Licenses.
| SAS Task | SAS Procedures Used | SAS License Required |
|---|---|---|
| Append Table | SQL | Base SAS |
| Area Plot | GPLOT | Base SAS, SAS/GRAPH |
| ARIMA Modeling and Forecasting | ARIMA | Base SAS, SAS/ETS |
| Assign Project Library * | LIBNAME | Base SAS |
| Bar Chart | GCHART | Base SAS, SAS/GRAPH |
| Bar Chart Wizard | GCHART | Base SAS, SAS/GRAPH |
| Bar-Line Chart | GBARLINE | Base SAS, SAS/GRAPH |
| Basic Forecasting | FORECAST | Base SAS, SAS/ETS |
| Box Chart | SHEWHART | Base SAS, SAS/QC |
| Box Plot | GPLOT | Base SAS, SAS/GRAPH |
| Bubble Plot | GPLOT | Base SAS, SAS/GRAPH |
| c Chart | SHEWHART | Base SAS, SAS/QC |
| Canonical Correlation | CANCORR | Base SAS, SAS/STAT |
| CDF Plots | CAPABILITY | Base SAS, SAS/QC |
| Characterize Data | CONTENTS, UNIVARIATE, FREQ | Base SAS |
| Cluster Analysis | CLUSTER, FASTCLUS, TREE | Base SAS, SAS/STAT |
| Compare Data | COMPARE | Base SAS |
| Contour Plot | GCONTOUR, G3GRID | Base SAS, SAS/GRAPH |
| Correlations | CORR | Base SAS |
| Create Format | FORMAT | Base SAS |
| Create Format from Data Set | FORMAT | Base SAS |
| Create Map Feature Table | GPROJECT | Base SAS, SAS/GRAPH |
| Create Time Series Data | TIMESERIES | Base SAS, SAS/ETS |
| Data Set Attributes | DATASETS | Base SAS |
| Delete Data Sets and Formats | SQL, CATALOG | Base SAS |
| Discriminant Analysis | DISCRIM | Base SAS, SAS/STAT |
| Distribution Analysis | UNIVARIATE | Base SAS |
| Donut Chart | GCHART | Base SAS, SAS/GRAPH |
| Download Data Files to PC | SQL | Base SAS |
| Factor Analysis | FACTOR | Base SAS, SAS/STAT |
| Filter and Sort * | SQL | Base SAS |
| Forecast Studio Create Project | None | SAS Forecast Server |
| Forecast Studio Open Project | None | SAS Forecast Server |
| Forecast Studio Override Project | None | SAS Forecast Server |
| Generalized Linear Models | GENMOD | Base SAS, SAS/STAT |
| High-Performance Linear Regression | HPREG | Base SAS, SAS High-Performance Analytics Server, SAS/STAT |
| High-Performance Logistic Regression | HPLOGISTIC | Base SAS, SAS High-Performance Analytics Server, SAS/STAT |
| Histograms | CAPABILITY | Base SAS, SAS/QC |
| Import Data (Microsoft Excel, text files, Microsoft Access) * | DATA step, IMPORT | Base SAS, SAS/ACCESS to PC File Formats (optional) |
| Import JMP file * | DATA step, IMPORT | Base SAS, SAS/ACCESS to PC File Formats |
| Import SPSS file * | DATA step, IMPORT | Base SAS, SAS/ACCESS to PC File Formats |
| Import Stata file * | DATA step, IMPORT | Base SAS, SAS/ACCESS to PC File Formats |
| Individual Measurements Chart | SHEWHART | Base SAS, SAS/QC |
| JMP Stored Process Packager * | DATA step | JMP |
| Life Tables | LIFETEST | Base SAS, SAS/STAT |
| Line Plot | GPLOT | Base SAS, SAS/GRAPH |
| Line Plot Wizard | GPLOT | Base SAS, SAS/GRAPH |
| Linear Models | GLM | Base SAS, SAS/STAT |
| Linear Regression | REG | Base SAS, SAS/STAT |
| List Data | Base SAS | |
| List Report Wizard | REPORT | Base SAS |
| Logistic Regression | LOGISTIC | Base SAS, SAS/STAT |
| Map Chart | GMAP | Base SAS, SAS/GRAPH |
| Mean and Range Chart | SHEWHART | Base SAS, SAS/QC |
| Mean and Standard Deviation Chart | SHEWHART | Base SAS, SAS/QC |
| Mixed Models | MIXED | Base SAS, SAS/STAT |
| Model Scoring | None | SAS Enterprise Miner |
| Nonlinear Regression | NLIN | Base SAS, SAS/STAT |
| Nonparametric One-Way ANOVA | NPAR1WAY | Base SAS, SAS/STAT |
| np Chart | SHEWHART | Base SAS, SAS/QC |
| One-Way ANOVA | ANOVA | Base SAS, SAS/STAT |
| One-Way Frequencies | FREQ | Base SAS |
| Open ODS Graphics Designer | None | ODS Graphics Designer |
| p Chart | SHEWHART | Base SAS, SAS/QC |
| Pareto Chart | PARETO | Base SAS, SAS/QC |
| Pie Chart | GCHART | Base SAS, SAS/GRAPH |
| Pie Chart Wizard | GCHART | Base SAS, SAS/GRAPH |
| P-P Plots | CAPABILITY | Base SAS, SAS/QC |
| Prepare Time Series Data | EXPAND | Base SAS, SAS/ETS |
| Principal Components | PRINCOMP | Base SAS, SAS/STAT |
| Probability Plots | CAPABILITY | Base SAS, SAS/QC |
| Proportional Hazards | PHREG | Base SAS, SAS/STAT |
| Q-Q Plots | CAPABILITY | Base SAS, SAS/QC |
| Query Builder * | SQL | Base SAS |
| Radar Chart | GRADAR | Base SAS, SAS/GRAPH |
| Random Sample | SURVEYSELECT | Base SAS, SAS/STAT |
| Rank | RANK | Base SAS |
| Rapid Predictive Modeler | SAS Enterprise Miner macros | SAS Enterprise Miner |
| Recency, Frequency, and Monetary Analysis | SAS Macro | Base SAS |
| Regression Analysis of Panel Data | TSCSREG | Base SAS, SAS/ETS |
| Regression Analysis with Autoregressive Errors | AUTOREG | Base SAS, SAS/ETS |
| Scatter Plot | GPLOT, G3D | Base SAS, SAS/GRAPH |
| Scatter Plot Matrix | SGSCATTER | Base SAS, SAS/GRAPH |
| Show ODS Statistical Graph | SGDESIGN | Base SAS |
| Sort Data | SORT | Base SAS |
| Split Columns | TRANSPOSE | Base SAS |
| Stack Columns | TRANSPOSE | Base SAS |
| Standardize Data | STANDARD | Base SAS |
| Summary Statistics | MEANS | Base SAS |
| Summary Statistics Wizard | MEANS | Base SAS |
| Summary Tables | TABULATE | Base SAS |
| Summary Tables Wizard | TABULATE | Base SAS |
| Surface Plot | G3D | Base SAS, SAS/GRAPH |
| t Test | TTEST | Base SAS, SAS/STAT |
| Table Analysis | FREQ | Base SAS |
| Tile Chart | GTILE | Base SAS, SAS/GRAPH |
| Transpose | TRANSPOSE | Base SAS |
| u Chart | SHEWHART | Base SAS, SAS/QC |
| Update Library Metadata * | METALIB | Base SAS |
| Upload Data Files to Server * | SQL, DATA step | Base SAS |
Note: Tasks followed by an asterisk are available only in SAS Enterprise Guide.
The following table lists the SAS Studio tasks that could be available in SAS Enterprise Guide and SAS Add-In for Microsoft Office. These tasks are available from the Tasks pane and the Tasks window after you have selected the Display SAS Studio tasks option in the Options dialog box.
The availability of a task depends on whether the necessary SAS software is licensed and installed at your site. The table lists the primary SAS procedures and the SAS software licenses that are required to run each task. For more information about a task, click the link to open the documentation for SAS Studio.
| SAS Studio Task | SAS Procedures Used | SAS License Required |
|---|---|---|
| Analysis of Covariance | DELETE, GLM, STDSIZE | SAS/STAT | Analysis of Means | ANOM | SAS/QC |
| Assess | ASSESS | SAS Viya, SAS Visual Statistics |
| Bar Chart | SGPLOT | Base SAS, SAS/GRAPH |
| Bar-Line Chart | SGPLOT, MEANS | Base SAS, SAS/GRAPH |
| Biconnected Components | OPTNET, OPTMODEL | SAS/OR |
| Biconnected Components | NETWORK, OPTNETWORK | SAS Viya, SAS Optimization |
| Bin Continuous Data | HPBIN | SAS High-Performance Procedures |
| Binary Logistic Regression | LOGISTIC | SAS/STAT |
| Binning | BINNING | SAS Viya, SAS Visual Statistics |
| Boolean Rules | TEXTMINE, BOOLRULE | SAS Viya, SAS Visual Data Mining and Machine Learning |
| Box Plot | SGPLOT | Base SAS, SAS/GRAPH |
| Bubble Plot | SGPLOT | Base SAS, SAS/GRAPH | Canonical Correlation | CANCORR | SAS/STAT | Capability Analysis | CAPABILITY | SAS/QC | Casual Models | MODEL, QLIM | SAS/ETS |
| Centrality Metrics | NETWORK, OPTNETWORK, CAS | SAS Viya, SAS Optimization |
| Characterize Data | FREQ, MEANS, SQL, UNIVARIATE | Base SAS | Cluster Observations | CLUSTER, FASTCLUS, DISTANCE | SAS/STAT | Cluster Variables | VARCLUS | SAS/STAT |
| Clustering | KCLUS | SAS Viya, SAS Visual Statistics |
| Coin Toss Simulation | Base SAS | |
| Combinations | None | Base SAS |
| Community Detection | NETWORK, OPTNETWORK, OPTMODEL, CAS | SAS Viya, SAS Optimization | Compute Similarities and Distances | DISTANCE | SAS/STAT |
| Confidence Intervals | POWER | SAS/STAT |
| Connected Components | OPTNET, OPTMODEL | SAS/OR |
| Connected Components | NETWORK, OPTNETWORK, OPTMODEL, CAS | SAS Viya, SAS Optimization | Control Charts | SHEWHART | SAS/QC |
| Core Decomposition | NETWORK, CAS | SAS Viya, SAS Optimization |
| Correlation Analysis | CORR | Base SAS |
| Correlation Analysis | HPCORR | SAS High-Performance Procedures | Correspondence Analysis | CORRESP | SAS/STAT |
| Cox Regression | POWER | SAS/STAT | Cross-sectional Data Models | REG, QLIM, COUNTREG | SAS/ETS |
| Cross-sectional Data Models | CQLIM, CNTSELECT | SAS Viya, SAS Econometrics |
| Custom Tests | POWER | SAS/STAT |
| Cycle Detection | OPTNET, OPTMODEL | SAS/OR |
| Cycle Detection | NETWORK, OPTNETWORK, OPTMODEL, CAS | SAS Viya, SAS Optimization |
| Data Exploration | SGSCATTER, UNIVARIATE, FREQ, BOXPLOT | Base SAS, SAS/GRAPH |
| Decision Tree | TREESPLIT | SAS Viya, SAS Visual Statistics |
| Describe Missing Data | FREQ | Base SAS |
| Dice Roll Simulation | Base SAS | Discriminant Analysis | DISCRIM, STEPDISC | SAS/STAT |
| Distribution Analysis | UNIVARIATE | Base SAS | Estimate Within-Cluster Covariances | ACECLUS | SAS/STAT |
| Equivalance Tests | POWER | SAS/STAT | Factor Analysis | PRINCOMP | SAS/STAT |
| Factorization Machine | FACTMAC | SAS Viya, SAS Visual Data Mining and Machine Learning |
| Filter Data | SQL, UNIVARIATE | Base SAS |
| Forest | FOREST | SAS Viya, SAS Visual Data Mining and Machine Learning |
| Generalized Linear Models | GENMOD | SAS/STAT |
| Generalized Linear Models | HPGENSELECT | SAS High-Performance Procedures |
| Generalized Linear Models | GENSELECT | SAS Viya, SAS Visual Statistics |
| Gradient Boosting | GRADBOOST | SAS Viya, SAS Visual Data Mining and Machine Learning |
| Heat Map | SGPLOT | Base SAS, SAS/GRAPH |
| Histogram | SGPLOT | Base SAS, SAS/GRAPH |
| Imputation | VARIMPUTE | SAS Viya, SAS Visual Statistics | K-Means Clustering | FASTCLUS | SAS/STAT |
| Line Chart | SGPLOT | Base SAS, SAS/GRAPH |
| Linear Assignment | OPTNET, OPTMODEL | SAS/OR |
| Linear Assignment | OPTNETWORK, OPTMODEL, CAS | SAS Viya, SAS Optimization |
| Linear Regression | GLMSELECT, PLM, REG | SAS/STAT |
| Linear Regression | REGSELECT | SAS Viya, SAS Visual Statistics |
| List Data | PRINT, SORT | Base SAS |
| List Table Attributes | DATASETS | Base SAS |
| Logistic Regression | POWER | SAS/STAT |
| Logistic Regression | LOGSELECT | SAS Viya, SAS Visual Statistics |
| Maximal Cliques | OPTNET, OPTMODEL | SAS/OR |
| Maximal Cliques | NETWORK, OPTNETWORK, OPTMODEL, CAS | SAS Viya, SAS Optimization |
| Minimum Cost Network Flow | OPTNET, OPTMODEL | SAS/OR |
| Minimum Cost Network Flow | OPTNETWORK, OPTMODEL, CAS | SAS Viya, SAS Optimization |
| Minimum Cut | OPTNET, OPTMODEL | SAS/OR |
| Minimum Cut | OPTNETWORK, OPTMODEL, CAS | SAS Viya, SAS Optimization |
| Minimum Spanning Tree | OPTNET, OPTMODEL | SAS/OR |
| Minimum Spanning Tree | OPTNETWORK, OPTMODEL, CAS | SAS Viya, SAS Optimization |
| Mixed Models | MIXED | SAS/STAT | Modeling and Forecasting | ARIMA, ESM, UCM | SAS/ETS |
| Moving Window Principal Component Analysis | MWPCA | SAS Viya, SAS Visual Data Mining and Machine Learning |
| Mosaic Plot | FREQ | Base SAS | Multidimensional Preference Analysis | PRINQUAL, PRINCOMP | SAS/STAT |
| Multiple Regression | POWER | SAS/STAT |
| N-Way ANOVA | GLM | SAS/STAT |
| Neural Network | NNET | SAS Viya, SAS Visual Data Mining and Machine Learning |
| Nonparametric One-Way ANOVA | NPAR1WAY | SAS/STAT |
| One-Way ANOVA | GLM | SAS/STAT |
| One-Way ANOVA | POWER | SAS/STAT |
| One-Way Frequencies | FREQ | Base SAS | Panel Data Models | PANEL, QLIM, COUNTREG | SAS/ETS |
| Panel Data Models | CPANEL, CNTSELECT | SAS Viya, SAS Econometrics | Pareto Analysis | PARETO | SAS/QC |
| Partial Least Squares Regression | PLS | SAS/STAT |
| Partial Least Squares Regression | PLSMOD | SAS Viya, SAS Visual Statistics |
| Partition Data | None | Base SAS |
| Partitioning | PARTITION | SAS Viya, SAS Visual Statistics |
| Pearson Correlation | POWER | SAS/STAT |
| Permutations | None | Base SAS |
| Pie Chart | SGRENDER, TEMPLATE | Base SAS, SAS/GRAPH |
| Predictive Regression Models | GLMSELECT, REG | SAS/STAT |
| Principal Component Analysis | PRINCOMP | SAS/STAT |
| Principal Component Analysis | PCA | SAS Viya, SAS Visual Statistics |
| Poker Hand Probability | Base SAS | |
| Quantile Regression | QTRSELECT | SAS Viya, SAS Visual Statistics |
| Random Sampling | HPSAMPLE | SAS High-Performance Procedures |
| Rank Data | RANK | Base SAS | Rapid Predictive Modeler | None | SAS Enterprise Miner |
| Reach Network | NETWORK, CAS | SAS Viya, SAS Optimization |
| Recode Ranges | None | Base SAS |
| Recode Values | None | Base SAS |
| Replace Missing Values | HPIMPUTE | SAS High-Performance Procedures |
| Robust Principal Component Analysis | RPCA | SAS Viya, SAS Visual Data Mining and Machine Learning |
| Same Birthday Probability | Base SAS | |
| Sampling | PARTITION | SAS Viya, SAS Visual Statistics |
| Scatter Plot | SGPLOT | Base SAS, SAS/GRAPH |
| Scoring | DATA step | SAS Viya, SAS Visual Statistics |
| Select Random Sample | SURVEYSELECT | Base SAS |
| Series Plot | SGPLOT | Base SAS, SAS/GRAPH |
| Severity Models | SEVSELECT | SAS Viya, SAS Econometrics |
| Shortest Paths | OPTNET, OPTMODEL | SAS/OR |
| Shortest Paths | NETWORK, OPTNETWORK, OPTMODEL, CAS | SAS Viya, SAS Optimization |
| Sort Data | SORT | Base SAS |
| Stack/Split Columns | TRANSPOSE | Base SAS |
| Standardize Data | STDIZE, SORT | Base SAS |
| Summary | CARDINALITY | SAS Viya, SAS Visual Statistics |
| Summary Statistics | MEANS, UNIVARIATE, BOXPLOT | Base SAS, SAS/GRAPH |
| Support Vector Data Description | SVD | SAS Viya, SAS Visual Data Mining and Machine Learning |
| Support Vector Machine | SVMACHINE | SAS Viya, SAS Visual Data Mining and Machine Learning |
| Survival Rank Tests | POWER | SAS/STAT |
| t Tests | TTEST, UNIVARIATE | Base SAS, SAS/STAT |
| t Tests | POWER | SAS/STAT |
| Table Analysis | FREQ | Base SAS |
| Tests of Proportions | POWER | SAS/STAT |
| Text Parsing and Topic Discovery | TEXTMINE | SAS Viya, SAS Visual Data Mining and Machine Learning | Time Series Analysis | VARMAX, AUTOREG | SAS/ETS | Time Series Data Preparation | TIMEDATA | SAS/ETS | Time Series Exploration | TIMEDATA, ARIMA | SAS/ETS |
| Transitive Closure | OPTNET, OPTMODEL | SAS/OR |
| Transitive Closure | NETWORK, OPTNETWORK, OPTMODEL, CAS | SAS Viya, SAS Optimization |
| Transform Data | DATA Step | Base SAS |
| Transform Data | DATA Step | SAS Viya, SAS Visual Statistics |
| Transpose Data | TRANSPOSE | Base SAS |
| Traveling Salesman Problem | OPTNET, OPTMODEL | SAS/OR |
| Traveling Salesman Problem | OPTNETWORK, OPTMODEL, CAS | SAS Viya, SAS Optimization |
| Variable Selection | VARREDUCE | SAS Viya, SAS Visual Statistics |
| Wilcoxon Test | POWER | SAS/STAT |