SAS Enterprise Guide 1: Querying and Reporting

This course is for users who do not have SAS programming experience but need to access, manage, and summarize data from different sources, and present results in reports and graphs.

Duration 2 Days
Certificate SAS Global
Language English

Fees 12000 + taxes


Power up your staff’s skills and boost your business

or Call us on +91 79 403 270 00


Course Description

Data, business, and statistical analysts who licensed or are considering licensing SAS Enterprise Guide or SAS Analytics Pro and would like training to get started with data access, management, and analysis

About Program

This course is for users who do not have SAS programming experience but need to access, manage, and summarize data from different sources, and present results in reports and graphs. This course focuses on using the menu-driven tasks in SAS Enterprise Guide, the point-and-click interface to SAS, to create queries and reports. It does not address writing SAS code or statistical concepts. This course serves as a prerequisite for the SAS Enterprise Guide 2: Advanced Tasks and Querying course and for the Creating Reports and Graphs with SAS Enterprise Guide course. It also serves as a prerequisite for the SAS Enterprise Guide: ANOVA, Regression, and Logistic Regressioncourse, which teaches statistical concepts using SAS Enterprise Guide.

Format of Training

All the benefits of the classroom without the travel:

Led by an expert instructor who can virtually look over your shoulder. Discuss, share, exchange ideas with students from different countries

Classroom training options include courses offered in our regional training centers or via our Live Web classroom.

Taught by certified instructors at high-tech facilities across the country

  • A SAS expert at your side.
  • Focused learning away from the office
  • Networking opportunities
  • State-of-the-art facilities
  • Electronic course notes downloadable to your device and permission to print
  • Business Knowledge Series: in-depth courses on the latest business topics
  • We offer Connected Classes! Watch for courses in Cary, New York, Arlington, Dallas and San Francisco that connect remote students via our Live Web classroom.

Train when and where you want

  • Eliminate travel costs and time away
  • Enjoy award-winning e-Courses

SAS e-Learning courses do not include SAS software. You must have SAS software installed to complete the practice exercises.

Prerequisite

This course is designed for 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.

This course addresses SAS Enterprise Guide software.

Training Features

  • access and manipulate local and remote data of various types
  • create queries that filter and summarize data, compute new columns, and join multiple tables
  • create frequency and tabular reports
  • create interactive graphs
  • automate output results.

Course Curriculum

Getting Started

  • introducing SAS Enterprise Guide
  • course scenarios

Working with Data in a Project

  • understanding the SAS data structure
  • accessing SAS and DBMS data
  • importing data files

Getting Started with Tasks

  • introduction to tasks and wizards
  • creating a frequency report
  • generating HTML, PDF, and RTF output
  • creating a listing report
  • filtering data in a task
  • creating a graph

Creating Simple Queries

  • filtering and sorting data
  • creating new columns with an expression
  • grouping and summarizing data in a query
  • joining tables

Creating Summarized Output

  • generating summary statistics
  • creating a summary report with the Summary Tables task

Using Prompts in Tasks and Queries

  • prompting in projects
  • creating and using prompts in tasks
  • creating and using prompts in queries

Customizing and Organizing Project Results

  • combining results
  • updating and organizing projects

Learning More

  • SAS resources
  • beyond this course

Writing and Submitting SAS Programs

  • writing and submitting SAS programs

Project

  • filtering and sorting data
  • creating new columns with an expression
  • grouping and summarizing data in a query
  • joining tables

FAQs

Each exam challenges candidates to apply specific knowledge they have acquired through SAS software training and/or job experience. Computer-based in format, SAS Global Certification exams comprise multiple-choice and/or short-answer questions, depending on the exam. Exams are generally scheduled through Pearson VUE but are also held at various locations around the world on a pre-scheduled basis. Candidates are allotted varying time limits to complete the exam, depending on which exam is taken. Specific exam content and passing criteria are located within each exam. To encourage your feedback, SAS Global Certification exams include a feature that allows candidates to comment on specific test questions. Your opinions are important to us and are a critical component in test development. Additionally, SAS Global Certification requires candidates to accept the terms of the SAS Institute Inc. Certification Program CandidatCancele Agreement before taking a certification exam.

Short-answer questions require you type your answer in a text box, rather than select your answer from four options. Typically, you will provide a numeric answer or a short section of SAS programming code. When entering code, case is ignored, and all variations of SAS syntax that correctly complete the program are accepted as correct.

Course Fees

e-learning

  

  

12000

+ Applicable Taxes
Enroll Now