SAS Software Training

Statistical Analysis System (SAS) Institute

SAS is the leader in business analytics software and services, and the largest independent vendor in the business intelligence market. Through innovative solutions, SAS helps customers at more than 75,000 sites improve performance and deliver value by making better decisions faster. Since 1976 SAS has been giving customers around the world The Power to Know. Based out of Cary, North Carolina, USA. SAS is always on demand and is growing. There has never been a time where SAS went down even in the time of recession. The demand for SAS Software professionals is always present and compelling. The following training are provided in SAS Software from Goodwill Solutions India

1) SAS Programming

Base SAS Programing

SAS Programming Introduction: Basic Concepts - This course teaches you how to write simple SAS programs.

Learn how to

  • Plan and write simple SAS programs to solve common data analysis problems.
  • Create simple list and summary reports
  • Define new data columns (variables)
  • Execute conditional code
  • Navigate the SAS windowing environment.

SAS Programming 1: Essentials - This course is for users who want to learn how to write SAS programs. It is the entry point to Learning SAS programming and is a prerequisite to many other SAS courses.

Learn how to

  • Navigate the SAS windowing environment.
  • Navigate the SAS Enterprise Guide programming environment.
  • Read various types of data into SAS data sets.
  • Create SAS variables and subset data.
  • Combine SAS data sets.
  • Create and enhance listing and summary reports.
  • Validate SAS data sets.

SAS Programming 2: Data Manipulation Techniques - This course is for those who need to learn data manipulation techniques using SAS DATA and procedure steps to access, transform, and summarize SAS data sets. The course builds on the concepts that are presented in the SAS Programming 1: Essentials course.

Learn how to

  • Control SAS data set input and output.
  • Combine SAS data sets.
  • Summarize, read, and write different types of data.
  • Perform DO loop and SAS array processing.
  • Transform character, numeric, and date variables.

Advanced SAS Programming:

SAS Programming 3: Advanced Techniques and Efficiencies - This course is for SAS programmers who prepare data for analysis. The comparisons of manipulation techniques and resource cost benefits are designed to help programmers choose the most appropriate technique for their data situation. Learn how to compare various SAS programming techniques that enable you to

  • Create and use indexes.
  • Append data.
  • Merge data.
  • Use hash and hiter DATA step component objects and arrays as lookup tables.
  • Compress SAS data sets.
  • Sample your SAS data sets.
  • Create and use SAS data views
  • Safely reduce the length of numeric variables.
  • Create user-defined functions and informats.

SAS Macro Language 1: Essentials - This course focuses on the components of the SAS macro facility and how to design, write, and debug macro systems. Emphasis is placed on understanding how programs with macro code are processed.

Learn how to

  • Perform text substitution in SAS code.
  • Automate and customize the production of SAS code.
  • Conditionally or iteratively construct SAS code.
  • Use macro variables and macro functions.

SAS SQL1: Essentials - This course teaches you how to process SAS data using Structured Query Language (SQL).

Learn how to

  • Query and subset data.
  • Summarize and present data.
  • Combine tables, including complex joins and merges.
  • Create and modify table views and indexes.
  • Replace multiple DATA and PROC steps with SQL query.

SAS Report Writing 1: Essentials - This course teaches you how to create detail and summary tabular reports using Base SAS procedures. You also learn how to enhance your reports using the Output Delivery System (ODS).

Learn how to

  • Enhance PROC PRINT detail tabular reports.
  • Create PROC TABULATE summary tabular reports.
  • Create PROC REPORT detail and summary tabular reports.
  • Send report output to third-party and SAS ODS destinations.
  • Enhance reports using ODS options and statements.

SAS Enterprise Guide - Access the power of SAS for quick data analysis and report generation using the SAS Enterprise Guide point-and-click interface.This course introduces experienced SAS programmers to SAS Enterprise Guide. SAS Enterprise Guide is an interface that enables users to write and submit code, as well as to use point-and-click tasks to generate queries, reports, and graphics.

Learn how to

  • write, edit, and submit SAS programs in SAS Enterprise Guide
  • use point-and-click tasks and wizards to access data and create queries, reports, and graphics.
  • Customize task output by modifying the code that is generated by SAS Enterprise Guide.
  • Use the concept of a SAS Enterprise Guide project to combine SAS programs with point-and-click functionality, including automated exporting and scheduled updates.
  • 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.
  • Build tabular reports with the Summary Tables task.
  • Create and apply custom formats to improve the displayed data values.
  • Generate customized bar charts.

SAS Data Integration Studio

SAS Data Integration Studio: Essentials 1 - This course introduces SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations.

Learn how to

  • Register source data and target tables.
  • Create jobs and explore the functionality of the job editor.
  • Work with many of the various transformations.

SAS Data Integration Studio: Essentials 2 - This course expands on the knowledge learned in SAS Data Integration Studio: Essentials 1 and provides additional information.

Learn how to

  • Work with slowly changing dimensions.
  • Work with Loop transformations.
  • Create new transformations.
  • Examine impact analysis.
  • Examine exporting and importing of metadata.
  • Establish checkpoints.
  • Deploy jobs for scheduling.
  • deploy jobs as SAS Stored Processes.

2) SAS Administration

Install, configure, and maintain the platform for SAS Business Analytics.

SAS Instalation and Licence Renewals on Desktop - This course teaches students how to Install/Uninstall SAS on desktop and renew licence.

Learn how to

  • Working with Software Depot.
  • Working with SID file.
  • Installing SAS software
  • Uninstalling SAS software
  • Checking Installed products

SAS Platform Administration

Metadata Administration - This course teaches students how to administer the SAS Metadata Server and the initial authentication process. Students will learn how to secure the SAS Intelligence Platform and the content that it contains, how to identify and administer the different types of users, identify and establish various security techniques, secure data and other shared content, and troubleshoot metadata security.

Learn how to

  • Administer and view SAS metadata through SAS folder structure.
  • Register users and groups programmatically.
  • Create and use internal accounts.
  • Create and apply ACTs.
  • Secure access to SAS data.
  • Secure access to RDBMS data.
  • Secure access to information maps.
  • Secure access to OLAP data.
  • Secure reports.
  • Secure users and groups, servers, and ACTs.
  • move metadata.

System Administration - This course provides students with the essential knowledge to perform the job functions of a SAS platform administrator.

Learn how to

  • Administer and back up SAS metadata.
  • Administer SAS Metadata Server
  • Administer SAS servers.
  • Monitor, log, and troubleshoot SAS servers.
  • Utilize SAS Environment Manager.

Middle Tier Administration - This course covers the SAS 9.4 middle tier architecture. The SAS Web Application Server, SAS Web Server, SAS Environment Manager, and all the new third-party components are discussed at length, including monitoring the servers and web applications. This course explores the various topologies that are available to address performance, scalability, and security for the SAS middle tier.

Learn how to

  • Use SAS Environment Manager to administer, monitor, and manage SAS resources.
  • Locate and manage middle-tier configuration files and scripts.
  • Use various methods to start/stop/monitor the SAS middle-tier servers.
  • Use SAS Web Administration Console to administer logging and users of SAS web applications.
  • Explore topologies and architectures for SAS 9.4 middle tier.

Installing and Configuring the Platform for SAS Business Analytics - This course is for SAS administrators who need to install and configure the Platform for SAS Business Analytics.

Learn how to

  • Define the architecture of the Platform for SAS Business Analytics.
  • Complete pre-installation tasks.
  • Install the Platform for SAS Business Analytics.
  • Configure the Platform for SAS Business Analytics.
  • Install client applications and identify next steps.

Unix Scripts for SAS Paltform Management:This course teaches using UNIX scripts to Administer SAS GRID Platform.

Learn how to

  • Sequence to start servers
  • Listing all running severs
  • Start and Stop Servers

SAS Grid Manager: Administration - This course covers how to administer a SAS Grid Manager Environment including the users, applications, and resources in that environment. After this course, you will understand SAS Grid Manager concepts and terminology and have a firm grasp of the fundamentals of the SAS Grid Manager architecture.

Learn how to

  • configure the Platform Suite for SAS
  • Add queues, users, custom resources, and tune settings.
  • Monitor and manage a SAS Grid Manager environment
  • Understand Platform RTM for SAS and how it is used.
  • Adjust SAS Grid Manager settings to meet the needs of your users
  • Troubleshoot a SAS Grid Manager environment.

Egosh Services for GRID Management:This course teaches using Egosh services and its commands to Administer SAS GRID Platform.

Learn how to

  • Sequence to start servers on GRID
  • Listing all running severs
  • Start and Stop Servers running on GRID

SAS Enterprise Guide: Administration - This course is for Platform Administrators who need to administer SAS Enterprise Guide.

Learn how to

  • Review the steps to install and configure SAS Enterprise Guide
  • Make SAS libraries available to SAS Enterprise Guide users
  • Control users' access to SAS Enterprise Guide functionality