Course Batch Starts, Timing, Price & Enroll

Program Duration Batch Starts Time Price # Enroll Book free demo
Weekend
60 Hrs Weekend Evening-Batch USD 600
INR 30000
Enroll Now Book free demo class
Weekend
60 Hrs Weekend Morning-Batch USD 600
INR 30000
Enroll Now Book free demo class
Weekdays
60 Hrs Weekdays Morning-Batch USD 600
INR 30000
Enroll Now Book free demo class
Weekdays
60 Hrs Weekdays Evening-Batch USD 600
INR 30000
Enroll Now Book free demo class

# Cloud lab charges will be extra. Our technical consultant will share actual lab charges with you.

About Course

This course can be a best choice for those professional who are looking to make a career in data management and data warehousing. This course is ideal for working professional also who are working in Business Intelligence area and want to explore their knowledge in SAS 9. The best suited audience can be -
SAS Administrators
SAS Architects
Data management professionals
Data warehousing professionals
This course will help you in learning to write SAS programs, data manipulation techniques using SAS DATA, procedure steps to access, transform, and summarize SAS data sets. After doing this course candidate can prepare data for analysis, use the SAS macro facility to design, write, and debug macro systems and learn how to process SAS data using Structured Query Language (SQL).
This course will provide you the in-depth knowledge of SAS programs and you will learn -

SAS programming to navigate the SAS windowing
SAS Data-sets, subset data and variables
Combining and controlling SAS Data-sets input and output
Creating summary reports.
DO loop, array processing in SAS
Working with user-defined functions and informats
Combining tables using JOIN and modifying table views and indexes
After completing this course you will be able to -

Importing and Exporting raw data files
Manipulating and Transforming data
Combining SAS Datasets
Working with summary reports using SAS procedures
Handling and correcting errors while using SAS.
Using advanced DATA step to solve complex problems
Writing and Interpreting SAS SQL code
Creating and Using the SAS MACRO facility
There is no formal prerequisite to attend this course but having a good understanding about file structures, system commands and accessing data files on your operating systems can help you to cover this SAS 9 course in a quick way.

CURRICULUM

SAS 9 Base + Advance

  • 1.1 Working in SAS environment
    - 1.1.1 Editor window
    - 1.1.2 Log window
    - 1.1.3 Output window
    - 1.1.4 Result window
  • 1.2 Overview of libraries
    - 1.2.1 Referencing files in SAS libraries
  • 1.3 Basic concepts
    - 1.3.1 Creating a SAS program – Hello World
    - 1.3.2 Components of SAS programs
  • 1.4 Understanding data step processing
    - 1.4.1 Program Data Vector (PDV)
  • 1.5 Input styles
    - 1.5.1 List input
    - 1.5.2 Column input
    - 1.5.3 Formatted input
    - 1.5.4 Modified input
    - 1.5.5 Named input
  • 1.6 Informats and Formats
    - 1.6.1 Difference between Informats and Formats
    - 1.6.2 Character informat & format
    - 1.6.3 Numeric informat & format
    - 1.6.4 Data and Time informat & format
  • 1.7 Functions
    - 1.7.1 Arithmetic functions
    - 1.7.2 String functions
    - 1.7.3 Date and time functions
  • 1.8 Combining data sets
    - 1.8.1 Concatenating
    - 1.8.2 Merging
    - 1.8.3 One to one merging
    - 1.8.4 One to many merging
    - 1.8.5 Many to one merging
    - 1.8.6 Many to many merging
    - 1.8.7 Interleaving
  • 1.9 Control Statements
    - 1.9.1 If else statement
    - 1.9.2 Where statement
    - 1.9.3 Case statement
    - 1.9.4 Loops (do, dountill, dowhile)
  • 1.10 Reading raw data from external file
    - 1.10.1 Infile statement
    - 1.10.2 Filename statement
  • 1.11 Writing data to external file statement
    - 1.11.1 File statement
    - 1.11.2 Put statement
    - 1.11.3 Export option
  • 1.12 Datalines/Card statement
    - 1.12.1 Invalid data
    - 1.12.2 Missing values generated
  • 1.13 Procedures
    - 1.13.1 Proc print
    - 1.13.2 Proc sort
    - 1.13.3 Proc contents
    - 1.13.4 Proc append
    - 1.13.5 Proc import/export
    - 1.13.6 Proc means
    - 1.13.7 Proc copy
    - 1.13.8 Proc freq
    - 1.13.9 Proc transpose
    - 1.13.10 Proc datasets
  • 1.14 Functional Procedures
    - 1.14.1 Proc correlation
    - 1.14.2 Proc regression
    - 1.14.3 Proc means
    - 1.14.4 Proc freq
    - 1.14.5 Proc annova
  • 2.1 SAS macros
    - 2.1.1 Introduction to SAS macros
    - 2.1.2 Automatic macro variables
    - 2.1.3 User defined macro variables >
  • 2.2 Proc SQL
    - 2.2.1 Introduction to Proc SQL
    - 2.2.2 Creating tables
    - 2.2.3 Inserting data into tables
    - 2.2.4 Combining two or more tables
    - 2.2.5 Joins
  • 2.3 SAS Arrays
    - 2.3.1 Introduction to arrays
    - 2.3.2 Processing data with SAS arrays
  • 2.4 SAS Stored Procedures
    - 2.4.1 Introduction to stored procedures
    - 2.4.2 Developing SAS products on stored procedures

Exam & Certification

SAS Base Programming for SAS 9:
Question: 60-65
Question Type: multiple-choice and short-answer
Passing score: 70%
Exam Duration: 110 Minutes
exam ID - A00-211
Authorized testing center - Pearson VUE


SAS Advanced Programming for SAS 9

Question: 60-65
Question Type: multiple-choice and short-answer
Passing score: 65%
Exam Duration: 2 Hours
exam ID - A00-212
Authorized testing center - Pearson VUE.

Select Trainer for Demo


DEBABRATA DALAL
Certification: PMP , VMware Certified (VCP-DCV) , Citrix CCP-V , MCSE
From
Professional Experience
Training Experience

Qualification
BE (Electrical)

Skills
Agile and Scrum Master, Citrix Xen, Communication Skill, English, Hardware, HR, IT Architecture, IT Infra Helpdesk, JIRA, Linux , Microsoft Project, Microsoft System Center, Microsoft Windows Server , Networking Helpdesk, Networking Support, PMP, Primavera, Procurement, Salesforce.com, SAS, Telecom, UNIX, VMware ,

Profile
To lead a business entity of an Information Techno logy organization by strategizing, planning , implementing businesses in line with organization vision Read More...
RATING & REVIEWS
Bhupendra Singh
Debabrata Dalal took charge of Infosys’s prestigious Ministry of Corporate Affairs (MCA21 Project) as Program Manager from Dimension Data from June ’13. Infosys had assigned major responsibility of 6 technical tracks - NOC Helpdesk, Network,Unix,DB2,Storage,TSM and Windows to Dimension Data. He has displayed exemplary leadership skills in making this project successful. Some of Highlights: • The Delivery Team was aligned to the MCA project requirements which brought clarity of objectives • Brought efficiency in operations with proper governance • Improved Incident Management metrics Average resolution from 47hrs in April’13 to 2.9Hrs in Dec’13 . TAT for tickets closed within 24Hrs improved to 99% in Dec’13 Reduced Attrition • Supported successfully the critical DR-DC Switch over in Aug’13 • Historic Peak Filing in Sept’13 when Infosys beat the previous year’s Peak Filing record of TCS. We at Infosys are extremely satisfied by the leadership and services rendered by Debabrata Dalal and wish him all the success for future.
Sangeeta Garg
A perfectionist, A Leader, A good mentor and the list goes on and on.... Mr. Debabrata is an extremely focused Delivery Head who watches the bottom line like a hawk. He is capable to manage all the details whilst still keeping the big picture very much in focus. An excellent communicator who has a very high level of professionalism. He has an excellent customer interface and is an effective negotiator under most challenging of circumstances. He is a team player and one who leads his team by example and sets the bar very high for all of his team members, this ability singles him out as one of the key people I have always tried to emulate in my career. He leads by example which is both inspiring and motivating. As part of the Delivery management team, he has worked hard to build authentic relationships with the employees & customers . His efforts have created a happier and more productive team. I wish him all the success for all his future endeavors.
Rajesh Kumar
In my entire tenure in IT Industry I found DD as most sincere and dedicated professional, no second thought for sure. As a part of Dimension Data, DD, he seemed to be best at strategic vision on long run project and program management front, granular scope on mapping with delivery efficiency and best optimizing, coordination and being accessible for his team, providing biggest buffer to his operation managers who can always bank on his diligence and feel at home, his physical availability for clients and internal teams, endurance to stay back constantly very late at work place, accommodating nature not for peer and senor but also for ones smaller and junior, his supportive and useful interface on any kind of fire-fighting scenarios or con-call courses. I strongly endorse to his professional language forte, his mastering on alignment and scripts with services sales and presentations and his contribution to DD services biz closures. He is a combination of most of the professional pre-requisites. was a privilege to work with him
Vipin Jain
DD, as everyone calls him, was Program Manager for all projects of North & East region. All the Project Managers were reporting to him and he used to ensure that all projects were completed in a coordinated manner within timelines. He set up processes to initiate projects and monitor them to achieve the overall business objectives while optimizing the use of resources and keeping cost under control. This responsibility was being done very efficiently and DD was recognized by Management Stakeholders for his good performance, hard work and professionalism. DD is having excellent leadership skills and many clients have formally appreciated the work done by DD and his team. Besides this DD was handling Operations and Buisness Development of the region successfully. On personal front, DD is very humble and gets along with people very well. I wish him all the best for his future endeavors and hope we can work together again
Sanjay Bhat
DD used to head our North operations and was extremely passionate about his work. He always led from the front and as the position demanded used to put in long hours daily. I have always seen him persue every issue with a smile which gave great motivation to his team. DD is great human being and a friend you can have for life. All the very best DD
Michael Igbo
Debabrata is a great Trainer. He is paient and willing to share his professional experiences and plans for the Trains. Besides his subject matter knowledge, presentation skills, etc., Debabrata managed participation very well. Good listening and to the point. Would love to take another Training Session with him.
Pankaj Kumar Pathak
Certification:
From
Professional Experience
Training Experience

Qualification
MCA

Skills
Cloudera, Cloudera Impala, Hadoop , Hbase, OpenStack, Python, R, Red Hat , Redhat Linux , RUBY, Ruby on Rails, SAS, Tableau, UNIX, Data Science,

Profile
Pankaj has around 16 years of experience in IT cor porate along with 4 years of experience in Data Science. He is expertise in complete Data Science (Data Analysis, Data Migration and Data Visualization) also and already has trained more than 100 Hadoop architect. he has worked with prominent IT companies like HCL and CSC. he has handle various national and overseas projects on various technologies like Python, R, Linux, Hadoop , Tableau an Qlikview. I also provide world wide training on open source hot skills such as Apache Hadoop, R, Python, Tableau, Qlikview etc.... Read More...
RATING & REVIEWS
Mukesh kumar
I do not hesitate to give a 5 star for Mr Pankaj. He has enormous knowledge on Analytics, he knows what industries needs and how can a student be trained in that path. Even a beginner can be able to catch up with an experienced one with his way of teaching. His knowledge on Data science concepts was exceptional well.
Gaurav Kumar
Pankaj has excellent knowledge about statistics and modelling and would be the best tutor, if you are looking out for any kind of knowledge on Data science. He is very patient with the students and goes extra mile to make them understand the subject. Hats of to good work. Thank you.
Sunil baliwal
Pankaj is a very knowledgeable and efficient tutor. He knows the subject and also teaches very well. His classes are a must take for some one looking for statistics or modelling or data science knowledge. Highly appreciate his knowledge and effort he takes for making the students understand the subject.
Anurag Sharma
Highly recommended. Pankaj has fantastic understanding about the subject and also the current economic situation. Pankaj teaching skills are fantastic and the best thing is he always happy to help.
Anurag Sharma
Excellent Trainer!!!
Vinay Rastogi
it was a fantastic experience with Mr Pankaj, According to me he is one of the best trainer for the experienced candidates. He has the ability to guide the students for industrial environment.
Farhan
Good trainer .
Sachin Pandey
Pankaj sir is a very calm teacher he clear our each and every doubt calmly.
tribhuwan
I am very much delighted to let you know that I have successfully finished the Hadoop classes with Mr pankaj Sir . I am pleased with the class lectures, lecturer, tech hub team members. Provide good quality lectures for all the classes. Its a good experienced took hadoop course with tech hub institute specially pankaj sir. He has a very good experienced.
Deepanjali Saxena
Class s gd
Priyanshu Purwar
I am taking python classes from Pankaj sir. The methodology of teaching is quite different i.e. more hands-on and less theory, that is good for the students. he is very good in explaining things.
Sakshi Kaul
Good knowledge.
Jatin Mahajan
Good knowledge and able to resolve my issue .... Always motivating for good performance...
prachi,saraph
Certification:
From
Professional Experience
Training Experience

Qualification
Master of Science, Computer Science, Universoty of South Florida

Skills
Big Data, SAS,

Profile
RATING & REVIEWS
Sachin Adnaik
Certification: Statistics
From
Professional Experience
Training Experience

Qualification
Ph.D. (Statistics)

Skills
Business Analysis, Machine Learning, Microsoft Azure, SAS, Statistics, Data Science,

Profile
Have strong knowledge of R, SAS, RapidMiner, Machi ne Learning and Predictive Modeling. Conducted trainings (for Industries and for Training Institutes) on Data Science, Machine Learning, Predictive Modeling, Statistics using R and other tools. Read More...
RATING & REVIEWS
Disclaimer

** The above course information is taken from SAS Institute Inc.

* Money Back Guarantee till demo and 1st class of the course.

* All trademarks and logos appearing on this website are the property of their respective owners.


Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US