SAS Online Training

27/04/2012 Computer - Multimedia Classes

Price: Free

No image available

Description

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 SASSAS 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 environmentWhy using the SAS in different sectors.How to use the data step to read and manipulate complex forms of dataWrite Data and Proc steps.Data step compile and executionRead any type of external raw data into SASReading raw data SAS environment into DATA SET using Input statement & advance INLIFE statement optionsWorking with Data Storage in SAS libraries creation for user defined libraries and multi-engine architectureReading 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 expressionsCreating Summary Information, SAS Functions, Transforming DataChanging variable types using the PUT and INPUT functions summarizing data filesTo expert data from data sets to delimiter files using with data set blockUnderstand error messages in the SAS Log and debug your program PERFORM ITERATIVE PROCESSING ON DATA: Using Do loops for repetitive calculations and processingUsing Arrays to process across an observations and processingUsing 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 placeMerging conceptsConcatenation concept in mergingInterleaving concept and mergingDifferent kind of match merging using MERGE statement using the contribution (IN=) option in merge conceptUsing ODS concept to generate reportsRole of ODS concepts to reporting SAS outputTo 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 joinInnner , FULL,OUTER,LEFT and RIGHT JoinsUnion join,Cross joinsSet Operator us such as union and intersection joining multiple tables ADVANCED SQL Topics HOW TO USE SAS MACROS IN SQLHow to retrieve Raw data different from DATABASES to SAS environment using SQL StatementsTo create table in different databases using SAS sql statementTo manage in different databases using SAS Sql Statements PASS TROUGH FACILITY Uses of pass through facilityHow to communicate with other database like Access, Oracle, DB2To control and manage other databases from the SAS. SAS/MACROS  Macro concepts&Advantages SAS Macro Language Macros And Macro Variables Creating Macro Variables & Using Macro Variables Creating Modular Code With Macros Invoking A Macro Adding Parameters to Macros Writing Macros With Conditional Logic Using Various Procedures in Macro Variables Nesting of Macros Multiple And Multi-Level Macros Macro Functions SAS DATAWAREHOUSING  DATAWAREHOSING Concepts What is ETL SAS/ETL Concepts SAS/OLAP Concept   http://sastrainingonline.com/sas-online-training      

More Details

Total Views:5
Reference Id:#46381
Phone Number:9177856619
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2019 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com