Welcomes to eworldclasses - Data Warehousing SAS

HOME

ABOUT US

SERVICES

REGISTRATION

COURSES

ENQUIRY

PAYMENT

CONTACT US

LOGIN

Courses

SAP Technical

SAP Functional

SAP New Dimensional

Microsoft Technologies

Oracle

Testing Tools

Middleware Technologies

Siebel

Administration

Adobe Flex 3.0

Mainframes

Course :	Data Warehousing	Duration : 45 Hrs
Sub Course :	SAS
Course Content :	SAS EXPOSURE IN ORGANISATIONS
	History of SAS SAS comes in ERP sector or not? Why? Role of Statistical Analysis in Clinical Research Study and Banking analysis SAS role in Clinical Research Study and Banking analysis Data modeling and Data mining concepts Project Management in Clinical Research Study analysis and Banking analysis What is Clinical Research Study? What is Protocol and role of Protocol in Clinical Research Study? What is randomization and non randomization? Which is playing main role in Clinical Research Study? What is SOP (Standard Operating Procedure)? What is DBMS? Role of DBMS team in Clinical Research Study What is CDM (Clinical Data Management)? Importance of CDM systems for data loading What is SAP (Statistical Analysis Plan)? Role of SAP in Clinical Research Study SAS Work Flow in Clinical Research Study Relation between SAS and DBMS Interaction between SAS with CDMs for data access Various report generation in Clinical Research Study Role of SAS in Credit Analysis and Different Banking Channels. When we go any industry for Data modeling and Data mining. Role of SAS in Data modeling and Data mining GETTING STARTED WITH SAS SYSTEMS: Basic operating system commands, operating system file structures Managing windows in SAS window environment How to run SAS application in different modes and in different environment like Windows, Unix and Mainframes Use of different kind of SAS products and how to use in SAS application. Difference between the SAS products. Why using the SAS in different sectors. How to use the data step to read and manipulate complex forms of data Write Data and Proc steps. Data step compile and execution To run SAS application on different modes Reading internal reading and printing l raw data into SAS Read any type of external raw data into SAS Reading raw data SAS environment into DATA SET using Input statement & advance INLIFE statement options Working with Data Storage in SAS libraries creation for user defined libraries and multi-engine architecture Using a single libref to reference some or all SAS libraries reading and printing mixed records formats. Reading packed and zoned decimal data working with EBCDIC and ASCII data Reading data from data set to another data set. To manage the SAS window environment used with global options. Reducing memory requirements with BUFFNO and BUFSIZE working with SAS data set options To manage existing data with controlling statements and expressions Creating Summary Information, SAS Functions, Transforming Data Changing variable types using the PUT and INPUT functions summarizing data files Generation data sets to create historical information SAS To expert data from data sets to delimiter files using with data set block Understand error messages in the SAS Log and debug your program Use with Error Handling concepts PERFORM ITERATIVE PROCESSING ON DATA: Using Do loops for repetitive calculations and processing Using Arrays to process across an observations and processing Using DO WHILE and DO UNTIL statements for conditional looping DATA STORAGE METHODS AND COMPRESSION: SAS Engines Space reduction Data set compression INDEXING TECHINIQUES AND USES: When to use indexes Creating and deleting indexes Index advantages and disadvantages UTILITIES TO MANAGE AND WORK WITH DATASETS: Data using append procedure to add date values in existing dataset Using the update statement to update data in existing dataset. Using the MODIFY statements to update and modify data in place Merging concepts Data transformation Concatenation concept in merging Interleaving concept and merging Different kind of match merging using MERGE statement using the contribution (IN=)option in merge concept Using ODS concept to generate reports RELEVANT BASE SAS PROCEDURES: Organize and sort SAS data sets and working with duplicates To generate listing output use print Comparing data sets with proc compare To create user defined informat and format statements use format Using proc copy to copy data sets Importance of contents procedure Reading data from dataset for reporting use report Using Proc Datasets to modify data set structure , attributes, how to use permanent formats , Setting up Integrity Consraints to maintain clean data and Setting up indexes Role of ODS concepts to reporting SAS output To generate SAS output in different panels like RTF, HTML,PDF and XML Using ODS How to use PROC SQL to retrieve INFORMATION from their Data Introduction to SQL Concepts The origin of SQL and why we use it. Create new tables, indexes , views and reports Simple Queries Understanding to SQL Concepts How to specify columns and subset rows Using functions to summarize outputs Performing group analysis, remerging and sub quiries Joining Data What are Cartesian Products , what is join Innner , FULL,OUTER,LEFT and RIGHT Joins Set Operator us such as union and intersection joining multiple tables PROC SQL as compared to the data step WORKING WITH TABLES , VIEWS AND indexes Creating Indexes and table in SQL Why we use Views in SQL Performance and space ISSUES ADVANCED SQL Topics HOW TO USE SAS MACROS IN SQL How dictionary table and views can simplify programming SQL options How to retrieve Raw data different from DATABASES to SAS environment using SQL Statements To create table in different databases using SAS sql statement To manage in different databases using SAS Sql Statements PASS TROUGH FACILITY Uses of pass through facility How to communicate with other database like Access, Oracle, DB2 To control and manage other databases fro the SAS. To access required data from other databases To create DATAWAREHOUSING environment Basic Statistical Procedures (SAS/STAT) and reporting Procedure To summary statistical Analysis Summary Procedure Producing Statistical with means Procedure Testing Categorical Data with FREQ PROCEDURE Reporting areas in SAS To generate report use with Proc Report Examining Data with Univarate Procedure T-tests and non parametric Comparison Proc ANOVA for one way ANOVA for one way Analysis of Variance Examining Correlations with PROC CORR PROC REG for Regression Analysis Creating bar & PIE Charts Producing BAR & pie chart Enhancing O/P with Title FOOTNOTES Color & font Producing & Overlaying lots CONTROLLING Appearance of axe’s Generating Graphs use with ODS How to work with SAS/ACCESS & SAS/Connect To import data from different PC files use import procedure To export data from different source use access procedure To export data from datasets to different PC files use export Procedures Uses of DBLoad procedure and how to work To transport datasets one environment to another environment and one version to another version to another version (windows to UNIX)use with cprot and cimport procedures How to use Upload Procedure How to use Download Procedure How to work with MACRO LANGUAGE INTRODUCTION to MACROS How the SAS macros Language Works What is the role of macro in SAS Introduction to tokening , compiling and executing a SAS program How the macro Processor Works Applying MACRO VARIABLES in a SAS PROGRAM Applying automatic macro variables Designing customized macro variables Submitting the macro variables in SAS Programming Displaying MACRO VARIABLES VALUES in the SAS log Applying quoting functions with macros Incorporating SAS Macros in the DATA STEP Designing macro variables during Data step Execution Indirecting referencing Macro variables Resolving Macro variables during DATA STEP EXECUTION Understaining the functionality and application of the SYSMGET function and SYSMPUT routine Usinig the INTO clause to build macro variables during PROC SQL execution RUNNING MACRO PROGRAMS IN SAS SOFTWARE Designing and implementing simple macros and reduce customizing SAS application To Develop Reusable Application use with MACRO Specifying conditional coding inside a macro The macro compilation and execution processes in the macro processor SAS system options use dfor debugging macros Reviewing error and warning log messages displayed by bthe macro processor Designing and using macros containing parameters within them Using positional and keyword parameters in macro calls Difference macros and symbol table Hierarchies Concepts in MACRO FUNCTIONS , MACRO INTERFACE AND MACRO Quoting Functions and how to use MACRO CODING. Techniques for Storing MACROS Understanding the auto call feature Permanently storing and using compiled macros Writing Efficient macro programs DEBUGGING SAS PROGRAMS SAS programs that work Fixining Programs that don’t work Seraching for the missing semicolon Input statement reaching past the end of line Lost card Invalid Data How to handle different kind of SAS errors Missing VALUES were Generated Numeric values have been converted to Charcter WRONG results but no error message The data step Debugger SAS Trucated a character variable SAS stops in the middle of the job SAS runs pout of memeory or disk space Statistical DATAWAREHOUSING DATAWAREHOSING Concepts What is ETL SAS/ETL Concepts What is OLAP SAS/OLAP Concepts Role of Pass through to create Data warehousing Environment