Find
in
Avoid scams by dealing locally! Always exchange items and money in person and Never pay in advance. More info

SAP, DWH, SAS, JAVA, ORACLE



SAS ONLINE TRAINING COURSE

SAS EXPOSURE IN ORGANISATIONS
• 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 PROCEDURE
2. EXPORT PROCEDURE 12. COMPARE PROCEDURE
3. DBLOAD PROCEDURE 13. SORT PROCEDURE
4. COPY PROCEDURE 14. DATASETS PROCEDURE
5. CPORT PROCEDURE 15. PRINTTO PROCEDURE
6. CIMPORT PROCEDURE 16. FORMAT PROCEDURE
7. DELTE PROCEDURE 17. TRANSPOSE PROCEDURE
8. SETININT PROCEDURE 18. ACCESS PROCEDURE
9. OPTIONS PROCEDURE
10. TEMPLATE PROCEDURE
REPORTING PROCEDURES
1. PRINT PROCEDURE
2. TABULATE PROCEDURE
3. REPORT PROCEDURE
4. CHART PROCEDURE
5. GCHART PROCEDURE
6. PLOT PROCEDURE
7. GPLOT PROCEDURE

STAT PROCEDURES
1. MEANS PROCEDURE 7. FREQ PROCEDURE
2. SUMMARY PROCEDURE 8. RANK
3. UNIVARIATE PROCEDURE 9. TTEST PROCEDURE
4. CORR PROCEDURE 10. ANOVA PROCEDURE
5. FREQ PROCEDURE 11. REG PROCEDURE
6. 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
• Uses of pass through facility
• How to communicate with other database like Access, Oracle, DB2
• To 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 Concepts
Should you require any further information please do not hesitate to contact us
Contact: trainings@keentechnologies.com any queries are always welcomed
Please feel free to mail us for demo session or call @ 9989754807
URL:http://www.keentechnoligies.com

COURSES OFFERING


JAVA TECHNOLOGIES-> Advanced java, Core java, Hibernate, J2EE, Java scripting, Springs, Struts.

MICROSOFT TECHNOLOGIES-> Wcf, Ado.net, Asp, C#.net, Microsoft bi, Sharepoint, Sqlserver development, VB.net, SqlserverDBA, Wpf, Biztalkserver,
Msbi ssis, Microstrategy.

ORACLE APPS-> Obiee, Sql, 10g, Adf, Apps financial, Apps dba, Apps crm,
Apps hrms, Soa, Apps technical,Application framework.

DATAWAREHOUSING-> 8online, Essbase, Informatica, Initio, Interactive reports, Odi, Objects, Cognos, Planning and budjeting, Tm1 online.

SAP-> Security, Bw, Bo/bi, Crm functional, Crm technical, Crm, Fscm, Fscd, Mdm, Pp, Ps, Is retail, Hr, Fico, Plm, Netweaver, Srm
Mm, Sd, Sem, Warehouse management, Xi, Abab hr, Abap workflow, Apo, Basis.

SAS-> SAS Online.

BUSSINESS ANALYST-> Bussiness analyst online.

MIDDLEWARE-> Tibco, Web methods.

SIBEAL-> Sibeal crm admin, Sibeal crm, sibeal analyst.

PEOPLE SOFT TECH-> PSTechnical, PSFinancial, PSHrms.

NETWORKING SYSTEMS-> Ccna, Ccnp, Linux, Mcitp, Mcsp, sunsolaris, Unix admin.

TESTING TOOLS-> Load runner, Manual testing, Qtp test professional, Quality center,
Test director, Win runner.

OTHER TECHNOLOGIES-> Android, Cloud computing, Cristal reports, Lombardi, Pmp, Perl scripting, Salesforce crm, Shell scripting, Smartphone app, Six sigma, Vmware, Webmethods.
 Respond to this ad


Ad ID: 2015489
Similar ads: