SAS

      NEWS EVENTS SERVICES Careers CONTACT US

HOME PRODUCTS AND SOLUTIONS SUCCESS STORIES PARTNERS COMPANYTRAININGCERTIFICATIONTECHNICAL SUPPORT

SAS.COM

TRAINING / CURRICULUM
 
Training
Find a CourseView all Courses
Experienced with SASSAS Programming
CurriculumRoles Based Courses
Find a CoursePublic Training
Find a CourseOn-Site Training
Find a CourseBusiness Knowledge Series
Find a CourseSAS Solution Lines
Find a CourseAuthorized Training Center
 

Querying and Reporting Using SAS Enterprise Guide

Classroom Duration: 1 Day

Audience
This Level I course is designed for end users who are not programmers but who need to retrieve information from different sources, summarize it, and present it in tables and graphs.

Course Description
This course focuses on how to access, manage, summarize, and present data using SAS Enterprise Guide. The course teaches students how to navigate the menu-driven interface of SAS Enterprise Guide to accomplish tasks such as accessing local SAS and Microsoft Excel tables and remote relational databases; creating user-defined formats; managing, manipulating, and joining data using the SQL query builder; generating descriptive statistics, tabular summary reports, and ActiveX graphs; and automating and scheduling tasks. This course does not cover statistical analysis tasks.

Course Contents

Getting Started

introducing SAS Enterprise Guide

   

Working with Data in a Project

introduction to tabular data

accessing local data

accessing remote data  

importing text files

editing tables in the Data Grid (self-study)

 

Getting Started with Tasks

introduction to task dialogs

creating a listing report

creating a frequency report

creating a two-way frequency report

using variable parameters in tasks

 

Creating Simple Queries

introduction to the Query task

controlling when a record loads
reading hierarchical raw data files
 

Creating Summarized Output

generating summary statistics
creating and applying custom formats

creating a tabular summary report  

creating a graph

interacting with an ActiveX graph (self-study)

 
Advanced Queries

controlling query output

creating parameterized queries

grouping and filtering data in a query (self-study)

 

Working with Results and Automating Projects

customizing the output style

combining results

updating results
 

Introducing SAS Programming (Self-Study)

getting started with SAS syntax 

editing SAS code

working with SQL syntax

 
Prerequisites

This course is designed for end users with no programming experience or SAS knowledge. Before attending this course, you should be familiar with Windows and other software, such as Microsoft Office or spreadsheet programs.
 

call: 91-22-6749 2222
fax: 91-22-6749 2299

training.india@sas.com

enquire now
register now
Back to Top
 

 

 

   Contact Us     Search     Terms of Use & Legal Information     Privacy Statement   Copyright © 2007 SAS Institute Inc. All Rights Reserved