SAS Online Training Modules Overview

Core topics of SAS Online Course

Introduction SAS

• Advantages of using SAS
• Major components of SAS suite
• SAS windows

Accessing Data in SAS

• Use COLUMN, FORMATTED and LIST input to read raw data files.
• Use INFILE statement options to control processing when reading raw data files.
• Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls.
• SAS libraries: Creating temporary and permanant libraries
• Options to read raw data: Missover,Truncover,Stopover,Flowover,DSD,DLM

Behind the scene

• SAS DATA Step Processing – Compilation Phase and Execution Phase
• Program Data Vector (PDV)
• SAS dataset: data and descriptor portions
• Understanding how SAS files are stored

SAS statements

• Differences between system options, data set options and statement options
• Informats, Formats, Attrib, Datalines, Delete, Drop, Keep, Label, Length, Retain, Sum, Dim

SAS Options

• Data set options: KEEP, DROP, RENAME, FIRSTOBS, OBS, IN, LABEL, WHERE
• SAS System Options – OBS, FIRSTOBS, BUFNO, BUFSIZE, LINESIZE,PAGESIZE, NODATE, YEARCUTOFF

SAS Functions

• INPUT and PUT
• Functions for Date and Time – MONTH, YEAR, DAY, MDY, DATE, TODAY, DATETIME
• Other SAS functions – SCAN, SUBSTR, TRIM, LEFT, RIGHT, INDEX, UPCASE, LOWCASE, MEAN, COMPRESS, LENGTH

Arrays

• Creating variables using Arrays
• Assigning Initial Values to Arrays
• Multidimensional Array

Conditional Processing

• Subsetting IF
• IF-THEN/ELSE statement
• DO statement
• Nesting of the DO Loop
• DO UNTIL statement
• DO WHILE statement

Connecting to outside world

• FTP thru SAS
• Connect to different servers (SQL server etc)
• Export data to create standard and comma-delimited raw data files

Merging & Appending Data

• SET and MERGE Statements
• MODIFY and UPDATE Statements
• WHERE Statement and differences with IF
• RETAIN and RETURN Statements

Analysis and report generation: SAS Procedures

• Proc Print, Proc Sort, Proc Means and Proc Contents
• Enhance reports through the use of user-defined formats, titles, footnotes

SAS Macros

• Storing SAS Macros
• Defining and Calling Macros
• Referencing Macro Variables
• Macro Parameters
• Macro Quoting Technique
• Macro Debugging Technique

Error Handling

• Identify and resolve programming logic errors
• Recognize and correct syntax errors

SAS Administration Training

Securing The SAS Configuration

• Secure a SAS platform configuration

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

Monitoring, Logging, And Troubleshooting SAS Servers

• Monitor SAS servers
• Administer SAS server logging and modify logging configurations
• Troubleshoot basic SAS server issues

Backing Up The SAS Environment

• Back up the SAS environment
• Restore the SAS environment

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

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

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

Job Opportunities in SAS

It’s an open fact that this is an industry where opportunities are quite plenty. If you have got the right set of skills & qualification, the jobs are waiting for you—now and in the future. To be clearly precise the whole world is facing shortage of skilled experts in this domain & most of the companies are coming forward offering whopping salary packages for the right talented experts who have successfully completed their training certification from a qualified institute. Make the most out of the rising career opportunities in the domain of SAS by availing our SacrosTek Systems complete industry concentric SAS Online Training certification program

SacrosTek Systems offer certification programs for SAS. Certificates are issues on successful completion of the course and the assessment examination. Students are requested to participate in the real-time project program to get first-hand experience on the usage and application of the SAS. The real-time projects are designed by our team of industry experts to help students get best possible exposure to the SAS and its applications.