Statistical analysis system (sas), The world's fastest and powerful statistical package for data analysis. It compairs multi-engine architecture for data management and reports. SAS training will prepare students for rewarding and better paying career as SAS analyst, programmer, developer and consultant.
Foundation course in analytics using the sas.
This SAS training course is a kind of its in India for SAS certification designed by a team of US and India based experts.This certification course has designed by industry exports for applaing data science skills to solve business problems in fields like retail, FMCG, financial services, telecom and healthcare. Our instructors with their real-time experiences makes you a certified business analyst from a novice.
Who should take the course ?
Professional looking to learn big data analytics skills.
Students looking to pursue data science as a career.
By the end you will acquire a good knowledge of statistical concepts, skills and tools (Excel and SAS language.).
Will be able to use statistical techniques to analze data to make business decisions
Pre-requisites: No prior knowledge of statistics, SAS or analytic techniques is required.
Departments which uses SAS :
Industries
Solutions lines
Foundation course in analytics using the sas.
This SAS training course is a kind of its in India for SAS certification designed by a team of US and India based experts.This certification course has designed by industry exports for applaing data science skills to solve business problems in fields like retail, FMCG, financial services, telecom and healthcare. Our instructors with their real-time experiences makes you a certified business analyst from a novice.
Who should take the course ?
Professional looking to learn big data analytics skills.
Students looking to pursue data science as a career.
By the end you will acquire a good knowledge of statistical concepts, skills and tools (Excel and SAS language.).
Will be able to use statistical techniques to analze data to make business decisions
Pre-requisites: No prior knowledge of statistics, SAS or analytic techniques is required.
Departments which uses SAS :
- Casinos
- Communications
- Education
- Financial Services
- Government
- Health Insurance
- Health Care Providers
- Hotels
- Insurance
- Life Sciences
- Manufacturing
- Media
- Oil & Gas
- Retail
- Travel & Transportation
- Utilities
Solutions lines
- Analytics
- Business Intelligence
- Customer Intelligence
- Financial Intelligence
- Foundation Tools
- Fraud & Security Intelligence
- Governance, Risk & Compliance
- High-Performance Analytics
- Information Management
- IT & CIO Enablement
- OnDemand Solutions
- Performance Management
- Risk Management
- Supply Chain Intelligence
SAS ONLINE TRAINING :
SAS is pronounced as "sass" is an integrated software products provided by SAS Institute Inc., that enables programmers to perform a sequence of operations on data stored as tables. Although non-programmer graphical user interfaces to SAS exist such as SAS Enterprise Guide, these GUIs are most often merely a front-end that automates or facilitates the generation of SAS programs. The functionalities of SAS components are accessed via application programmer interfaces, in the form of statements and procedures.
SAS
- SAS EXPOSURE IN ORGANISATIONS
- Is SAS comes in ERP sector or not? why?
- History of SAS
- What is Clinical Research Study?
- What is Standard Operating Procedure (SOP)?
- What is DBMS?
- What is SAS (Statistical Analysis Plan)?
GETTING STARTED WITH SAS SYSTEM :
- Managing windows in SAS window Environment.
- Why SAS is using in different sectors?.
- How to use 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.
- Advance INLIFE statement options.
- Working with Data storage in SAS
- libraries created 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 Summery 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 message in 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 statements to update 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 contributions (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 likes RTF, HTML, PDF and XML using ODS.
RELEVANT BASE SAS PROCEDURES:
UTILITY PROCEDURES :
- IMPORT PROCEDURE
- EXPORT PROCEDURE
- DBLOAD PROCEDURE
- COPY PROCEDURE
- CPORT PROCEDURE
- CIMPORT PROCEDURE
- DELTE PROCEDURE
- SETININT PROCEDURE
- OPTIONS PROCE
- TEMPLATE PROCEDURE
- APPEND PROCEDURE
- COMPARE PROCEDURE
- SORT PROCEDURE
- DATASETS PROCEDURE
- PRINTOO PROCEDURE
- FORMAT PROCEDURE
- TRANSPOSE PROCEDURE
- ACCESS 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 :
- MEANS PROCEDURE
- SUMMARY PROCEDURE
- UNIVARIATE PROCEDURE
- CORR PROCEDURE
- FREQ PROCEDURE
- ZTEST PROCEDURE
- FREQ PROCEDURE
- RANK
- TTEST PROCEDURE
- ANOVA PROCEDURE
- REG PROCEDURE
- GLM PROCEDURE
How to use PROC SQL to retrieve Information from their Data
· Introduction to SQL Concepts
· Create new tables
· indexes
· views
· reports
· joining Data
What are Cartesian products, what is join?
A. Inner
B. Full
C. Outer
D. Left
E. Right joins
F. Union join
G. Cross joins
Set Operator use such as union and intersection joining multiple tables
ADVANCED SQL TOPICS
A. How to use SAS Macros in SQL?
B. How to retrieve Raw data different from DATABASES to SAS environment
using SQL Statements
using SQL Statements
C. TO Create tables in different databases using SAS SQL statement
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 and Advantages
- SAS Macro Language
- Macros and Macro Variables and Using Macro Variables
- Creating Macro Code with Macros
- Creating Modular Code with Macros
- Invoking a Macro
- Adding parameters to Macros
- Writing Macro with Conditional Logic
- Using Various procedures in Macro Variables
- Nesting of Macros
- Multiple and Multi-Level Macros
- Macro Functions
SAS DATAWAREHOUSING
- Data warehousing Concepts
- What is ETL?
- SAS/ETL Concepts
- SAS/OLAP Concepts
