Description
SAS Enterprise Guide 2: Advanced Tasks and Querying is designed for experienced users who want to develop more advanced skills. It focuses on Query Builder, including manipulating character, numeric and date values, converting variable types and creating conditional expressions with the expression builder.
The course also addresses efficient table joins and using a single query to group, summarize and filter data. This two-day program covers basic modeling, variable analysis and statistical analysis through the SAS Enterprise Guide interface. It is suitable for teams working with data analysis and modeling.
What Will You Learn?
- Preparing data and building models
- Transposing, stacking and sorting data
- Converting character data to numeric values and vice versa
- Conditional logic in Query Builder to create columns
- Multiple-value prompts
- Statistical, relationship and classification analyses
- Time series forecasting
- Linear and logistic regression
- Analyzing data with charts
Who Should Attend?
Non-programmers and experienced programmers who already have experience with SAS Enterprise Guide.
Outline
Use Cases
- Data analysis with SAS Enterprise Guide
- Statistical analysis
- Analysis with charts, including scatter plots
- Preparing data for modeling
- Selecting samples
- Splitting data into training, validation and test sets
- ANOVA and t-tests
- Relationship analysis: correlation
- Classification and cluster analysis
- Linear and logistic regression
- Building models quickly with RPM
- Time series forecasting (optional)
- Analyzing anomalies in insurance data
- Creating new business rules and variables
- Producing dynamic daily reports, such as motor insurance policy and fraud counts, comparing them with previous months and years, and visualizing the results
Prerequisites
Completion of SAS Enterprise Guide – Part 1 or equivalent knowledge of the topics covered in that course.