Guruonline Trainingis a Global Interactive Learning Portal started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. guruonlinetraining.comhas a pool of Expert Trainers worldwide on all the technologies to train the students.

We offer you:

Ø Interactive Learning at Learner’s convenience

Ø Industry Savvy Trainers

Ø Learn Right From Your Place

Ø Customized Curriculum

Ø 24/7 Lab Facility

Support after Training

Resume Preparation

Certification Guidance

Interview assistance

Name:Venkat

For India-Ph:             +91 9290071821       , SkypeId: dataramana.dwh, dataramana@gmail.com

Mail: guruonlinetraining@gmail.com, contactus@guruonlinetraining.

DATASTAGE ONLINE TRAINING WITH REAL TIME SCENARIOS & PROJECT EXPLAINATION WITH REAL TIME FACULTY. WE ARE OFFERING WITH LOWEST FEE. WE ARE PROVIDING 100% JOB PLACEMENTS FOR USSTUDENTS.WE ARE PROVIDING TRAINING ON DATASTAGE8.1 VERSION-IBM WEBSPHERE DATASTAGE&QUALITY STAGE ANDUPDATE THE STUDENTSABOUT LATEST VERSION IBM DATASTAGE 8.5 VERSION WITHLIVE ENVIRONMENT.

The SAS language

Ø  SAS datasets

Ø  The two parts of a SAS program

Ø  Choosing a mode for submitting SAS programs

Ø  Windows and commands in the SAS windowing environment

Ø  Submitting a program in the SAS windowing environment

Ø  Reading the SAS log

Ø  Viewing your results in the output window

Ø  Creating HTML Output

Ø  SAS datasets with SAS explorer

Ø  Using SAS system Options

Ø  Creation of Independent and Dependent libraries 

 Getting your data into SAS

Ø  Methods for getting your data into SAS

Ø  Reading files with the Import wizard

Ø  Reading raw data separated by spaces

Ø  Reading raw data arranged in columns

Ø  Selected formats

Ø  Reading Messy raw data

Ø  Reading delimited files with the data step

Ø  Reading delimited files with the Import procedure

Ø  Reading PC files with the Import procedure

Ø  Using permanent SAS            datasets with Libname statements 

 Exporting your data

Ø  Methods for exporting your data

Ø  Writing files using wizard

Ø  Writing delimited and HTML files using ODS

Ø  Writing PC files with the export procedure 

 Modifying and combining SAS Datasets

Ø  Modifying a Dataset using the SET Statement

Ø  Interleaving datasets using the SET Statement

Ø  Combining Datasets using a One-to-one match merge

Ø  Combining Datasets using a One-to-many match merge

Ø  Updating a master dataset with transactions dataset

Ø  Using SAS dataset Options

Ø  Tracking and selecting Observations with the IN-Option

Ø  Making several observations from one using the output statement changing observations to variables using proc transpose

Ø  Reading messy raw data

Ø  Converting character data type into numeric data type and vice-versa 

 Working with your data

Ø  Creating and redefining variable

Ø  Using SAS functions

Ø  Using IF-THEN statements

Ø  Grouping observations with IF-THEN/ELSE Statements

Ø  Sub setting your data

Ø  Working with SAS dates

Ø  Selected Date Informats, Functions and Formats

Ø  Using the RETAIN and Sum statements

Ø  Simplifying programs with Arrays

Ø  Using of Put Statements

Ø  Differences between the Put statement and the Put function

Ø  Using of Label Statement

Ø  Using of Length Statement

Ø  Using of Location

Ø  Using of Files statement

Ø  Using of Put Functions

Ø  Using of Where statement

Ø  Using of By statement

Ø  Concept of Formats/Informats

Ø  Creating of User defined Formats and Informats

Ø  Sum statement

Ø  Using of OBS and FIRSTOBS

Ø  Using of Modify statement

Ø  Using of pointers

Ø  File system in SAS

Ø  Execution process of  a data step 

 Enhancing your output with ODS

Ø  Concepts of the Output Delivery system

Ø  Tracing and Selecting procedure Output

Ø  Creating SAS datasets from procedure Output

Ø  Using  ODS statements to create HTML output

Ø  Using  ODS statements to create PDF output

Ø  Using  ODS statements to create RTF output

Ø  Using  ODS statements to create PS output

Ø  Using of ODS trace on and trace off statements

Ø  Using of ODS select statement 

 Automatic Variables

Ø  Using of Automatic Variables

Ø  Using of _N_

Ø  Using of _Null_

Ø  Using of _Error_ 

 Procedures in Base SAS

Ø  Proc Contents

Ø  Proc Append

Ø  Proc Options

Ø  Proc Import

Ø  Proc Export

Ø  Proc Compare

Ø  Proc Datasets

Ø  Proc Transpose

Ø  Proc Format

Ø  Proc Copy

Ø  Proc Sort

Ø  Using of Nodupkeys and noduprec in proc sort 

 Reporting procedures

Ø  Proc Report

Ø  Proc Tabulate

Ø  Proc Forms

Ø  Proc Chart

Ø  Proc Gchart

Ø  Proc Plot 

SAS Macros

Ø  Definition of Macro

Ø  Calling of Macro Variables

Ø  Using of Macro Program

Ø  Adding parameters to Macros

Ø  Examples on Macros

Ø  Macro Functions 

SAS SQL

Ø  Introduction to SAS/SQL