SAS Administration Training

A warm welcome to the SAS Administration course by Uplatz.

SAS (Statistical Analysis Software) is used by business analysts, information management experts, risk managers and researches to provide more efficient methodologies for data visualization and faster business trend analysis and prediction.

SAS is one of the most implemented software in sectors such as pharmaceutical, finance, marketing, aeronautics, agriculture, etc. With the help of SAS we can generate sophisticated analytical reports , graphs, listings and many other statistical calculations. Many clinical research companies, banking & insurance organizations use SAS. Also, companies like Google, Twitter, Facebook, Amazon, IBM, and the like incorporate SAS concepts in their products & services or for internal use. Infact, most of the Fortune global 500 companies implement SAS and functions for their managements and decisions.

SAS Administration refers to the activities and tasks involved in successfully administering and managing the SAS software platform in its entirety. SAS platform administrators perform the following major tasks:

• Secure the SAS configuration on each server machine

• Check status and operate servers

• Monitor server activity and administer logging

• Establish formal, regularly scheduled backup processes

• Add users and manage their access

• Establish connectivity to data sources

• Set up and secure metadata folder structures

• Administer repositories and move metadata

Uplatz provides this comprehensive training on SAS Administration. SAS Admin training course is the best way to equip you with the right set of tools to be prepared for the SAS Platform Administration for SAS 9 certification exam as well as for the large number of job opportunities available in the market. In this SAS Admin training, you will learn how to administer the SAS Metadata Server and the initial authentication process, 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.

If you are aiming for SAS certifications, then this SAS Administration course will be extremely helpful as it prepares you for the SAS Platform Administration for SAS 9 exam. For SAS administrators, SAS 9.4 provides a broad suite of management capabilities that support management tasks, auditing, and software deployment and upgrades.

Course Objectives

• Define the architecture of the platform for SAS Business Analytics

• Describe the Platform Administrator role

• Identify The Platform Administrator tasks

• Examine how to secure SAS Platform configuration

Course Curriculum - SAS Administration

1. Securing The SAS Configuration

• Secure a SAS platform configuration

2. Checking The Status And Operation Of SAS Servers

• Manage metadata repositories

• Identify the properties and functionality of SAS servers

• Configure a SAS Metadata server cluster

3. Monitoring, Logging, And Troubleshooting SAS Servers

• Monitor SAS servers

• Administer SAS server logging and modify logging configurations

• Troubleshoot basic SAS server issues

4. Backing Up The SAS Environment

• Back up the SAS environment

• Restore the SAS environment

5. Administering Users

• Manage connection profiles

• Manage roles

• Register users and groups in the metadata

• Give users access to processing servers and data servers

• Determine when to store passwords in the metadata

6. Administering Data Access

• Register libraries and tables in the metadata

• Update table metadata

• Pre-assign a library

• Troubleshoot data access problems

• Use the metadata LIBNAME engine

7. Managing Metadata

• Identify how the metadata authorization layer interacts with other security layers

• Identify where, how, and to whom metadata permissions are assigned

• Determine the outcome of metadata authorization decisions

• Use metadata permissions to secure metadata

• Create and use Access Control Templates

• Promote metadata and associated content

Key Topics covered in this course include:

Reviewing the Platform for SAS Business Analytics

• Exploring the platform for SAS

• Business Analytics overview

• Exploring the client tier, middle tier, server tier, and data tier

Administering the SAS Environment

• Overview of administration tasks

Determining the State of the SAS Environment

• Checking the state of SAS servers

• Exploring the metadata server and repositories

• Troubleshooting the metadata server

Monitoring, Logging, and Troubleshooting SAS Servers

• Identifying different types of SAS servers

• Monitoring SAS servers and spawners

• Logging SAS servers and spawners

• Troubleshooting SAS servers

Backing Up the SAS Environment

• Backing up metadata with the Backup Wizard

• Exploring OMABAKUP

• Scheduling backups

• Backing up physical files

Administering Client Applications

• Exploring connection profiles

• Using roles to control access to application

• Functionality

• Exploring SAS folders

Administering Users

• Defining regular users and groups

• Defining administrative users

• Giving users access to servers

Administering Data Access

• Registering libraries

• Tables in the metadata

• Updating table metadata

• Pre-assigning libraries

• Troubleshooting data access

Securing Metadata

• Introduction to metadata security

• Exploring metadata permission

• Exploring predefined ACTs

• Securing content in the folder tree

• Securing content outside the folder tree

• Creating additional ACTs

Moving Metadata

• Replicating an entire repository

• Promoting selected content

Updating the SAS Environment

• Applying hot fixes to the SAS environment

Key Roles of SAS Administrator

• There will be different kinds of servers one needs to handle at work like SAS BI which are used by users also

• It includes fixing the daily issues in the server, tuning it and troubleshooting

• One need to know the mechanics of installing the up gradations in servers and software updates

• To do quality checkups and ensure to fix the service packs

• SAS admin needs to test and assure quality on leftest suppuration and fixes

• He need to plan the outages and and monitor the software testing and developments with the help of the SAS Programmer

• In emergency reboots the users should be intimated quickly on risk of managements in outages

• He need to choose and fix the relevant SAS software by analysis and evaluations

• One needs to maintain scheduled backups of meta databases and user defined controls and access

• Risk managements and desk space planning are also done for good user support

• The administration also takes charge of consultation of users on problems like malfunctions and also arrange meetings for incidences

• The SAS Administrator also need to perform the required guiding classes and coaching to other coordinating departments

• To develop tolls and up-gradation s per the best need and ease of usage of the users

• Administrators use SAS Deployment Wizards to install SAS Enterprise guides

• He takes care of the security risks and ensures the safety factors to avoid them as the least possible

• Using the functions one should manually or with software options encrypt data sets

• The metadata backups are taken care through backup wizards and ensures a scheduled times for backups of physical files, and also promotes particular or selected content as required

• Administering users by registering users ,exploring authentications and also creating groups are maintained in the admin team.

• The client applications are taken responsibility by the admin, ensuring their registrations and authentications and even in grouping the similar users

• It is very important for and SAS architect to be able to  foresee the next steps through SAS documents

• The access to the data is secured by the admins it involves registering libraries and tables in the metadata, updating table metadata and trouble shooting the data access

After the SAS Intelligence Platform has been installed, configured, and validated, you will have a functional system. SAS administrators can now begin performing administration tasks that are necessary to fully implement the SAS Intelligence Platform in your environment. These include the following categories of tasks:

• First-Priority Setup Tasks that are necessary to protect the integrity of your system. You should perform these tasks first, as soon as possible after you have completed your installation.

• Standard Setup Tasks that enable the users in your organization to begin using SAS Intelligence Platform client applications to access and analyze your data.

• Optional Setup Tasks that you might want to perform to address specific requirements in your environment.

• Ongoing System Administration Tasks to keep the SAS Intelligence Platform operational.