SAS Online Training

Location : andhra pradesh >> hyderabad

Posted on : Apr 26,2012

Online SAS Training by SAS Base and Advanced Certified Professional @ Sas Training Online

www.sastrainingonline.com/

+91 91778 56619 (India)

Skype ID: naveen_sas

SAS Training Online Course Content:

SAS COURSE CONTENT

History of SAS
SAS comes in ERP sector or not? Why?
What is Clinical Research Study?
What is SOP (Standard Operating Procedure)?
What is DBMS?
What is SAP (Statistical Analysis Plan)

GETTING STARTED WITH SAS SYSTEMS

Managing windows in SAS window environment
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
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
Reading data from data set to another data set.
To manage the SAS window environment used with global 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
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

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

UTILITIES TO MANAGE AND WORK WITH DATASETS:

Using the update statement to update data in existing dataset.
Using the MODIFY statements to update and modify data in place
Merging concepts
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
Role of ODS concepts to reporting SAS output
To generate SAS output in different panels like RTF, HTML,PDF and XML Using ODS

RELEVANT BASE SAS PROCEDURES:

UTILITY PROCEDURES:1.IMPORT PROCEDURE 11.APPEND PROCEDURE2.EXPORT PROCEDURE 12.COMPARE PROCEDURE3.DBLOAD PROCEDURE 13.SORT PROCEDURE4.COPY PROCEDURE 14.DATASETS PROCEDURE5.CPORT PROCEDURE 15.PRINTTO PROCEDURE6.CIMPORT PROCEDURE 16.FORMAT PROCEDURE7.DELTE PROCEDURE 17.TRANSPOSE PROCEDURE8.SETININT PROCEDURE 18.ACCESS PROCEDURE9.OPTIONS PROCEDURE10.TEMPLATE PROCEDURE

REPORTING PROCEDURES:

1.PRINT PROCEDURE2.TABULATE PROCEDURE3.REPORT PROCEDURE4.CHART PROCEDURE5.GCHART PROCEDURE6.PLOT PROCEDURE7.GPLOT PROCEDURE

STAT PROCDURES:

1.MEANS PROCEDURE 7.FREQ PROCEDURE2.SUMMARY PROCEDURE 8.RANK3.UNIVARIATE PROCEDURE 9.TTEST PROCEDURE4.CORR PROCEDURE 10.ANOVA PROCEDURE5.FREQ PROCEDURE 11.REG PROCEDURE6.ZTEST PROCEDURE 12.GLM PROCEDURE

How to use PROC SQL to retrieve INFORMATION from their Data

Introduction to SQL Concepts

Create new tables, indexes , views and reports

Joining Data

What are Cartesian Products , what is join
Innner , FULL,OUTER,LEFT and RIGHT Joins
Union join,Cross joins
Set Operator us such as union and intersection joining multiple tables

ADVANCED SQL Topics

HOW TO USE SAS MACROS IN SQL
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