Basic

Base & Advance Sas

Base advance sas training institute in delhi  We offer base and advance SAS training by well qualified IT professionals working in big mnc’s. We have experienced trainer. We provide daily basis study material, assignments.  We offer base advance sas training by most experienced trainer. We offer below syllabus for base advance sas.

base advance sas training

SAS BASE TRAINING SYLLABUS

  • INTRODUCTION TO SAS PROGRAMMING
  • Working in the SAS Environment
  • Working with the Windows
  • Enhance Editor
  • Result Window
  • Log Window
  • Explorer Window
  • Output Window
  • Program Editor Window

 

  • BASICS OF SAS LANGUAGE
  • SAS Libraries
  • Data Sets
  • Cube
  • Data View
  • Referencing Files in Catalog
  • Creating a SAS Program
  • Components of SAS Program
  • Characteristics of SAS Program
  • Layout of SAS Program

 

  • ACCESSING DATA
  • Use FORMATTED, LIST and COLUMN 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
  • Combine SAS data sets using the DATA step

 

  • ADVANCE SAS TRAINING SYLLABUS
  • Introduction to SAS Macro Language Elements
  • Introduction to Macro Variables
  • Automatic Macro Variables
  • User define Macro Variables
  • How Macro processing will undergo inside the SAS system
  • Macro Statements
  • Macro Functions
  • Autocall Macros

 

  • SAS MACROS
  • SAS Libraries
  • Introduction to SAS Macro Language Elements
  • Introduction to Macro Variables
  • Automatic Macro Variables
  • User define Macro Variables
  • How Macro processing will undergo inside the SAS system
  • Macro Statements
  • Macro Functions
  • Autocall Macros

 

  • ACCESSING DATA USING SQL
  • Introduction to Proc SQL
  • Generate detail reports by working with a single table or joining tables using PROC SQL
  • Generate summary reports by working with a single table or joining tables using PROC SQL
  • Inserting data into Tables
  • Alter & update the tables
  • Construct sub queries within a PROC SQL step
  • SQL pass through Facility
  • Connecting to DBMS
  • Natural Joins
  • Inner Joins
  • Outer Joins
  • Access Dictionary Tables using the SQL procedure
  • Work with indexes using the macro interface/creating macro variables with SQL, defining integrity constraints

 

  • MACRO PROCESSING
  • Creating and using user-defined and automatic macro variables within the SAS Macro Language
  • Automating programs by defining and calling macros using the SAS Macro Language
  • Various system options available for macro debugging
  • Displaying values of user-defined and automatic macro variables in SAS log
  • Understand the use and implantation of macro functions

 

VBA – EXCEL
1 – GETTING STARTED
  • Introducing Visual Basic for Applications
  • Displaying the Developer Tab in the Ribbon
  • Recording a Macro
  • Saving a Macro-Enabled Workbook
  • Running a Macro
  • Editing a Macro in the Visual Basic Editor
  • Understanding the Development Environment
  • Using Visual Basic Help
  • Closing the Visual Basic Editor
  • Understanding Macro Security

 

2 – WORKING WITH PROCEDURES AND FUNCTIONS
  • Understanding Modules
  • Creating a Standard Module
  • Understanding Procedures
  • Creating a Sub Procedure
  • Calling Procedures Using the Immediate Window to Call Procedures
  • Creating a Function Procedure
  • Naming Procedures
  • Working with the Code Editor
3 – UNDERSTANDING OBJECTS
  • Understanding Objects
  • Navigating the Excel Object Hierarchy
  • Understanding Collections
  • Using the Object Browser
  • Working with Properties
  • Using the With Statement
  • Working with Methods
  • Creating an Event Procedure
4 – USING EXPRESSIONS, VARIABLES, AND INTRINSIC FUNCTIONS
  • Understanding Expressions and Statements
  • Declaring Variables
  • Understanding Data Types
  • Working with Variable Scope
  • Using Intrinsic Functions
  • Understanding Constants
  • Using Intrinsic Constants
  • Using Message Boxes
  • Using Input Boxes
  • Declaring and Using Object Variables

 

5 – CONTROLLING PROGRAM EXECUTION
  • Understanding Control-of-Flow Structures
  • Working with Boolean Expressions
  • Using the If End If Decision Structures
  • Using the Select Case End Select Structure
  • Using the Do Loop Structure
  • Using the For To Next Structure
  • Using the For Each Next
  • Structure Guidelines for use of Control-of-Flow Structures

 

6 – WORKING WITH FORMS AND CONTROLS
  • Understanding UserForms
  • Using the Toolbox Working with UserForm Properties, Events, and Methods
  • Understanding Controls
  • Setting Control Properties in the Properties Window
  • Working with the Label Control
  • Working with the Text Box Control
  • Working with the Command Button
  • Control Working with the Combo Box Control
  • Working with the Frame Control Working with Option Button
  • Controls Working with Control Appearance
  • Setting the Tab Order
  • Populating a Control
  • Adding Code to Controls
  • Launching a Form in Code

 

 

7 – DEBUGGING CODE
  • Understanding Errors
  • Using Debugging Tools
  • Setting Breakpoints
  • Stepping through Code
  • Using Break Mode during Run mode
  • Determining the Value of Expressions

 

8 – HANDLING ERRORS

  • Understanding Error Handling
  • Understanding VBAs Error Trapping Options
  • Trapping Errors with the On Error Statement
  • Understanding the Err Object
  • Writing an Error-Handling Routine
  • Working with Inline Error Handling

 

 

SAS DI STUDIO (Data Integration Studio)

SAS DI STUDIO (Data Integration Studio)

Exploring SAS Data Integration Studio
Working on Change Management
Explaining how to define source, target data structures and designing jobs.
Introduction to jobs and the job editor
Working with propagation and mappings
working with intermediate files
working with the extract transformation
working with summary statistics transformation
explore status handling for transformations and jobs
working with the data validation transformation
working with the sort transformation
working with the append transformation
working with the transpose transformation
working with the apply lookup standardization transformation
iterating a job with Loop transformations
basics of the Table Loader transformation
load styles of the Table Loader transformation
table properties and load techniques of the Table Loader transformation
Defining slowly changing dimensions
Using the SCD type 2 Loader and Change Data capture transformations (Pre & Post Process).
analyzing metadata using impact analysis

 

SPSS

Course Objective

Managers play an important role in organizational decision making. To be effective in this role, Managers need to be enabled to conceive and execute business research using theoretical inputs on research methodology if the research is manageable at their level. Knowledge of SPSS is all the more important for interacting with Consultants should their help be needed for the organization. It is also necessary to enable managers on software like SPSS to facilitate statistical analysis of data to support the research. With this capability, managers would be able to handle many routine business research problems at their levels. This course aims at equipping you on these.

Detailed Syllabus

  • MEASUREMENT AND SCALING
  • Measurements – Types of Measurement Scales – Attitude
  • Measurement – Classification of Scales – Single vs Multiple, Comparative vs Non-comparative
  • Types of Errors in Measurement – Criteria for good measurement – Reliability – Validity – Sensitivity.
  • Measurement and Scaling, Primary Scales of Measurement. Nominal Scale, Ordinal Scale, Interval Scale, Ratio Scale.
  • Comparative Scaling Techniques – Paired Comparison, Rank Order Scaling, Constant Sum Scaling, Q-Sort and Other Procedures.
  • Verbal Protocols, International Marketing Research and Ethics in Marketing Research

 

  • QUESTIONNAIRE DESIGN
  • Objectives of a Questionnaire, Criteria for Questionnaire Designing, Questionnaire Designing Procedure, Types of Questions to ask and intricacies in them.

 

  • DATA PREPARATION
  • Data Coding, Data Cleaning, Identification Outlier, Handling Missing Values (all using SPSS)
  • The Data Preparation Process , Questionnaire Checking, Editing, Treatment of Unsatisfactory Responses, Coding, Coding Questions, Code-book, Coding Questionnaires

 

  • EXPLORATORY RESEARCH
  • Pre-Experimental Design, True-Experimental Design
  • Quasi-Experimental Design

 

  • TWO-WAY ANOVA
  • Applications of two-way ANOVA as an analysis tool for complex experimental designs complex experimental designs

 

  • FACTOR ANALYSIS
  • Basics with Real time example

 

  • REGRESSION

                                                     

  • Simple   Regression   –   Linear   regression,   Regression Analysis and Real time Interpretation.
  • Multiple Regression – Assumptions & Basics, SPSS Output Interpretation, Transforming Dependent & Independent Variables
  • Multiple Regression – Dealing with Multi-co linearity, idea of Autocorrelation, Regression with Dummy Variables

 

  • DISCRIMINANT ANALYSIS
  • Discriminant Analysis – Basics with Real time example Interpretation.
  • Discriminant Analysis – Two Group Case
  • Discriminant Analysis – Multiple Group Case

 

  • CLUSTER ANALYSIS
  • Cluster Analysis – Basics with Real time example Interpretation.
  • Hierarchical Clustering
  • K-Means Clustering

 

  • Conjoint Analysis
  • Report Writing
  • Parametric And Non-Parametric Test
  • Sign Test, Mann – Whitney Test, Spearman Test, Kruscal –Wallis Test, Friedman Test.
  • Hypothesis Test, Level Of Significance, Significance Interval, Type I and Type Ii Error Occurrence.
  • Correlation, Types Of Correlation And Correlation Coefficient With Real Time Example
  • Types of Statistical Test and Situation Wise Explanation.
  • T-test, F-Test, Chi square test, Z – Test.
  • Experimental Design – Pre – Experimental Design, True Experimental Design, Quasi – Experimental Design.
  • Real Time Data Collection, Code Book preparation, Project Report preparation and their Analysis.
  • Real Time Project Walkthrough, Interview material Discussion and Data Analysis Resume Preparation
  • Communication Management – Communication: Introduction, Email Communication, Teleconference and Meetings, Assertiveness and Scenarios