Contents
About
About This Book
Data Tasks
List Table Attributes
About the List Table Attributes Task
Example: Table Attributes for the Sashelp.Pricedata Data Set
Selecting an Input Data Source
Setting Options
Characterize Data Task
About the Characterize Data Task
Example: Characterize Data Task
Assigning Data to Roles
Setting Options
Describe Missing Data
About the Describe Missing Data Task
Example: Describing Missing Data for SASHELP.BASEBALL
Setting the Data Options
List Data
About the List Data Task
Example: Reports of Drive Train, MSRP, and Engine Size by Car Type
Assigning Data to Roles
Setting Options
Transpose Data
About the Transpose Data Task
Example: Transposing the Data in the CLASS Data Set
Assigning Data to Roles
Setting Options
Stack/Split Columns
About the Stack/Split Columns Task
Stacking Columns
Splitting Columns
Filter Data
About the Filter Data Task
Example 1: Creating a Simple Filter
Example 2: Creating a Compound Filter
Creating Your Filter
Select Random Sample
About the Select Random Sample Task
Example: Creating a Random Sample of the Sashelp.Pricedata Data Set
Assigning Data to Roles
Setting Options
Partition Data
About the Partition Data Task
Example: Partitioning the SASHELP.CLASSFIT Data Set
Creating a Partitioned Data Set
Sort Data
About the Sort Data Task
Example: Sort the SASHELP.CLASS Data Set by Sex and Age
Assigning Data to Roles
Setting Options
Rank Data
About the Rank Data Task
Example: Ranking Students by Height within Age
Assigning Data to Roles
Setting Options
Transform Data
About the Transform Data Task
Example: Transforming the Data in the BASEBALL Data Set
Transforming Columns from the Input Data Set
Standardize Data
About the Standardize Data Task
Example: Standardizing Variables in the SASHELP.BASEBALL Data Set
Assigning Data to Roles
Setting the Options
Setting the Output Options
Graph Tasks
Bar Chart
About the Bar Chart Task
Example: Bar Chart of Mean Sales for Each Product Line
Assigning Data to Roles
Setting Options
Bar-Line Chart
About the Bar-Line Chart Task
Example: City and Highway Mileage by Origin
Assigning Data to Roles
Setting Options
Box Plot
About the Box Plot Task
Example: Box Plots Comparing MPG (City) for Cars
Assigning Data to Roles
Setting Options
Bubble Plot
About the Bubble Plot Task
Example: Bubble Plot
Assigning Data to Roles
Setting Options
Histogram
About the Histogram Task
Example: Histogram of Stock Volume
Assigning Data to Roles
Setting Options
Line Chart
About the Line Chart Task
Example: Displaying the Mean Horsepower for Each Car Type
Assigning Data to Roles
Setting Options
Mosaic Plot
About the Mosaic Plot Task
Example: Mosaic Plot
Assigning Data to Roles
Setting Options
Pie Chart
About the Pie Chart Task
Example: Pie Chart That Shows Total MSRP for Each Car Type by Region
Assigning Data to Roles
Setting Options
Scatter Plot
About the Scatter Plot Task
Example: Scatter Plot of Height versus Weight
Assigning Data to Roles
Setting Options
Series Plot
About the Series Plot Task
Example: Series Plot of Stock Trends
Assigning Data to Roles
Setting Options
Simple HBar
About the Simple HBar Task
Example: Horizontal Bar Chart of Mileage by Origin and Type
Assigning Data to Roles
Setting Options
Combinatorics and Probability Tasks
Permutations
About the Permutations Task
Example: Calculating the Permutations of Six Objects
Setting Options
Combinations
About the Combinations Task
Example: Calculating the Combinations of 52 Objects in 5 Sets
Setting Options
Same Birthday Probability
About the Same Birthday Probability Task
Example: Probability of Two or More People Sharing a Birthday in a Room of 145 People
Setting Options
Dice Roll Simulation
About the Dice Roll Simulation Task
Example: Probability of Outcomes for 100,000,000 Dice Rolls
Setting Options
Coin Toss Simulation
About the Coin Toss Simulation Task
Example: Probability of Outcomes for 10,000,000 Coin Tosses
Setting Options
Poker Hand Probability
About the Poker Hand Probability Task
Example: Results from the Poker Hand Probability Task
Statistics Tasks
Data Exploration
About the Data Exploration Task
Example: Exploring the SASHELP.CARS Data
Assigning Data to Roles
Setting the Plot Options
Summary Statistics
About the Summary Statistics Task
Example: Summary Statistics of Unit Sales
Assigning Data to Roles
Setting Options
Setting the Output Options
Distribution Analysis
About the Distribution Analysis Task
Example: Distribution Analysis of Sales for Each Region
Assigning Data to Roles
Setting Options
One-Way Frequencies
About the One-Way Frequencies Task
Example: One-Way Frequencies of Unit Sales
Assigning Data to Roles
Setting Options
Correlation Analysis
About the Correlation Analysis Task
Example: Correlations in the Sashelp.Cars Data Set
Assigning Data to Roles
Setting Options
Setting the Output Options
Table Analysis
About the Table Analysis Task
Example: Distribution of Type by DriveTrain
Assigning Data to Roles
Setting Options
t Tests
About the t Tests Task
One-Sample t Test
Paired Test
Two-Sample t Test
One-Way ANOVA
About the One-Way ANOVA Task
Example: Testing for Differences in the Means for MPG_Highway by Car Type
Assigning Data to Roles
Setting Options
Setting the Output Options
Nonparametric One-Way ANOVA
About the Nonparametric One-Way ANOVA Task
Example: Wilcoxon Scores for MPG_Highway Classified by Origin
Assigning Data to Roles
Setting Options
Creating an Output Data Set
N-Way ANOVA
About the N-Way ANOVA Task
Example: Analyzing the Sashelp.RevHub2 Data Set
Assigning Data to Roles
Building a Model
Setting Options
Setting the Output Options
Analysis of Covariance
About the Analysis of Covariance Task
Example: Analyzing the Sashelp.Class Data Set
Assigning Data to Roles
Setting Options
Setting the Output Options
Linear Regression
About the Linear Regression Task
Example: Predicting Weight Based on a Student’s Height
Assigning Data to Roles
Building a Model
Setting the Model Options
Setting the Model Selection Options
Creating Output Data Sets
Binary Logistic Regression
About the Binary Logistic Regression Task
Example: Classifying Email as Junk
Assigning Data to Roles
Building a Model
Specifying the Model Selection Options
Setting Options
Creating Output Data Sets
Predictive Regression Models
About the Predictive Regression Models Task
Example: Predicting a Baseball Player’s Salary
Partitioning Data
Assigning Data to Roles
Building a Model
Selecting a Model
Setting the Options for the Final Model
Setting the Scoring Options
Generalized Linear Models
About the Generalized Linear Models Task
Example: Analyzing the Sashelp.Baseball Data Set
Assigning Data to Roles
Building a Model
Setting Options
Setting the Output Options
Mixed Models
About the Mixed Models Task
Example: Analyzing Age and Gender
Assigning Data to Roles
Building a Model
Setting the Options
Creating Output Data Sets
Partial Least Squares Regression
About the Partial Least Squares Regression Task
Example: Partial Least Squares Regression Analysis
Assigning Data to Roles
Building a Model
Setting Options
Creating Output Data Sets
High-Performance Statistics Tasks
Bin Continuous Data
About the Bin Continuous Data Task
Example: Winsorized Binning
Assigning Data to Roles
Setting Options
Creating an Output Data Set
High-Performance Correlation Analysis
About the High-Performance Correlation Analysis Task
Example: Correlation between Weight, Oxygen, and Run Time
Assigning Data to Roles
Setting Options
Creating an Output Data Set
High-Performance Generalized Linear Models
About the Generalized Linear Models Task
Example: Model Selection
Partitioning Data
Assigning Data to Roles
Building a Model
Setting the Model Selection Options
Setting Options
Setting the Output Options
Replace Missing Values
About the Replace Missing Values Task
Assigning Data to Roles
Setting the Output Options
Random Sampling
About the Random Sampling Task
Assigning Data to Roles
Creating the Output Data Set
Setting Options
Power and Sample Size
Pearson Correlation
About the Pearson Correlation Task
Example: Pearson Correlation for Power and Sample Size Analysis
Assigning Properties
Setting the Plot Options
Multiple Regression
About the Multiple Regression Task
Example: Solve for Power
Assigning Properties
Setting the Plot Options
Confidence Intervals
About the Confidence Intervals Task
Example: Confidence Interval for One-Sample Means
Assigning Properties
Setting the Plot Options
Tests of Proportions
About the Tests of Proportions Task
Example: Power Analysis for One Proportion
Create a One-Proportion Test
Create a Two Correlated Proportions Test
Create a Two Independent Proportions Test
Setting the Plot Options
t Tests
About the t Tests Task
Example: One-Sample t Test for Mean
Assigning Properties
Setting the Plot Options
Cox Regression
About the Cox Regression Task
Example: Cox Regression
Assigning Properties
Setting the Plot Options
Multivariate Analysis
Principal Component Analysis
About the Principal Component Analysis Task
Example: Principal Component Analysis of Sashelp.Class Data Set
Assigning Data to Roles
Setting Options
Setting the Output Options
Factor Analysis
About the Factor Analysis Task
Example: Factor Analysis
Assigning Data to Roles
Setting Options
Setting the Output Options
Canonical Correlation
About the Canonical Correlation Analysis Task
Example: Canonical Correlation Analysis
Assigning Data to Roles
Setting Options
Setting the Output Options
Discriminant Analysis
About the Discriminant Analysis Task
Example: Discriminant Analysis on Crops Data
Assigning Data to Roles
Setting Options
Setting the Selection Options
Setting the Output Options
Correspondence Analysis
About the Correspondence Analysis Task
Example: Correspondence Analysis
Assigning Data to Roles
Setting Options
Setting the Output Options
Multidimensional Preferences Analysis
About the Multidimensional Preference Analysis Task
Example: Multidimensional Preference Analysis
Assigning Data to Roles
Setting Options
Setting the Output Options
Econometrics Tasks
Causal Models
About the Causal Models Task
Two-Stage Least Squares
Heckman’s Two-Step Selection Method
Cross-sectional Data Models
About the Cross-Sectional Data Models Task
Linear Models
Logit Model
Probit Model
Poisson Models
Negative Binomial Models
Censored Regression
Truncated Regression
Panel Data Models
About the Panel Data Models Task
Linear Models
Logit Model
Probit Model
Poisson Models
Negative Binomial Models
Censored Regression
Truncated Regression
Time Series Analysis
About the Time Series Analysis Task
Time Series Analysis for One Dependent Variable
Time Series Analysis for Multiple Dependent Variables
Forecasting Tasks
Time Series Data Preparation
About the Time Series Data Preparation Task
Understanding SAS Time Intervals
Example: Transforming the Data in the Sashelp.PriceData Data Set
Assigning Data to Roles
Setting the Transformations Options
Creating the Output Data Set
Time Series Data Exploration
About the Time Series Exploration Task
Example: Exploring the Sashelp.PriceData Data Set
Assigning Data to Roles
Setting the Analyses Options
Modeling and Forecasting Task
About the Modeling and Forecasting Task
Example: Creating a Random Walk Model for the SASHELP.PRICEDATA Data Set
Assigning Data to Roles
Setting the Model Options
Setting the Forecasting Options
Setting the Output Options
Statistical Process Control
Control Charts
About the Control Charts Task
Example: Determine the Mean and Range for the Diameters of Wafers
Assigning Data to Roles
Setting Options
Setting the Output Options
Capability Analysis
About the Capability Analysis Task
Example: Analysis of Plating Thickness
Assigning Data to Roles
Setting Options
Setting the Output Options
Pareto Analysis
About the Pareto Analysis Task
Example: Causes of Failure
Assigning Data to Roles
Setting Options
Setting the Output Options
Analysis of Means
About the Analysis of Means Task
Example: Determine the Deviation of Label Positions
Assigning Data to Roles
Setting Options
Setting the Output Options
Data Mining Tasks
Rapid Predictive Modeler
About the Rapid Predictive Modeler
Assigning Data to Roles
Setting the Model Options
Setting the Report Options
Setting the Output Options
Appendixes
Input Data Sets for Task Examples
About the Task Data Sets
CIGAR Data Set
FITNESS Data set
GETSTARTED Data Set
GREENE Data Set
IN Data Set
LONG97DATA Data Set
MROZ Data Set
References
Recommended Reading
Product
Release
SAS Studio Mid-Tier Help and Documentation
3.5
Type
Usage and Reference
Copyright Date
February 2016
Last Updated
16Feb2016