KT-EG271 SAS ENTERPRISE GUIDE 2: ADVANCED TASKS AND QUERYING Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


SAS ENTERPRISE GUIDE 2: ADVANCED TASKS AND QUERYING


Description: 

This course is intended for experienced SAS Enterprise Guide users who want to learn more about advanced SAS Enterprise Guide techniques. It focuses on using the Query Builder within SAS Enterprise Guide, including manipulating character, numeric, and date values; converting variable type; and building conditional expressions using the Expression Builder. This course also addresses efficiency issues, such as joining tables and using a single query to group, summarize, and filter data.

Skills Gained

  • use tasks to transpose, stack, rank, and create a random sample of your data
  • use functions to convert the data type from character to numeric and from numeric to character
  • use conditional logic in the Query Builder to create new columns
  • use multiple value prompts.

Who Can Benefit

  • Non-programmers with SAS Enterprise Guide experience, as well as experienced programmers with SAS Enterprise Guide experience

 
Click here to view the Course Outline
     
Prerequisite: 
  • Before attending this course, students should understand how to navigate the SAS Enterprise Guide environment, create projects, add data sources, accomplish basic analysis and reporting using tasks, and create queries. You can gain this knowledge by taking the SAS(R) Enterprise Guide(R) 1: Querying and Reporting course or by completing the Getting Started tutorial in SAS Enterprise Guide. No SAS or SQL programming experience is required.
 
   
     
Duration: 
2 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.