This course will provide you with the required experience in programming and data management using SAS to be able to import and export raw data files, manipulate and transform data, combine SAS data sets, create basic detail and summary reports using SAS procedures, and identify and correct data, syntax and programming logic errors. Advance SAS (Statistical Analysis System) training enables you to explore the depth and width of SAS knowledge. The training takes you to the higher level of data analysis helping enterprises in taking advantage of business intelligence
Learning Objectives:
At the end of this course, you should be able to:
- Perceive Analytics with SAS
- Explain SAS GUI, datasets, import/export of manipulated data
- Gain in-depth knowledge of integrating and refining datasets
- Perform conditional and iterative looping into your SAS program
- Simplify a SAS program with SAS arrays
- Analyse statistics and perform advanced statistical techniques with SAS
- Perform automation on complex repeated tasks using MACROS
- Implement and invoke SQL queries in SAS program
- Execute ODS statement with SAS
- Build and solve models using PROC OPTMODEL
Course content
PART-I BASE SAS:
- Introduction To SAS System & Architecture History And Various Modules
- Variables & SAS Syntax Rules
- SAS Data Sets
- Data Set Options
- Operators If – Then Else Statement Where Statement
- Creating & Redefining Variables
- Reading Raw Data
- Infile Statement With Options
- Multiple Observations and Multiple
- Input Styles
- SAS Functions
- Select Statement
- Do Loops
- Output Statement & Put Statement
- Stop And Error Statement s
- Array Statement
- Modifying And Combining Data Sets
- Updating Master Data Set Key Board
- Macros & Add Abbreviat ions
BASE SAS PROCEDURES
- Proc Sort
- Proc Print
- Proc Means
- ProcFreq
- Proc Plot
- Proc Chart
- Proc Compare
- Proc Copy
- Proc Summary
- Proc Append
- Proc Datasets
- Proc Contents
- Proc Delete
- Proc Format
- ProcPrintto
SAS / ODS:
- Creating Rtf File
- Creating Html File
- Creating Pdf File
- Creating Xml File
PART –II ORACLE-SQL CONCEPTS:
- Introduction History Features Sql Command
- Set Operators In Sql
- Order By Clause
- Group By Clause
- Having Clause
- Distinct Clause
- Create and Insert Deleting,
- Populating And Updating
SAS / SQL:
- Introduction To SAS / SQL
- Features & Uses Terminology Data Types,
- Key Words, & Operators
- Functions,
- Predicate s & Functions
- Formatting Output Group By Clause,
- Order By Clause & Having Clause
- Case Expression and Conditional
- Creating, Populating & Deleting Tables
- Alter Table Statement
- Renaming A Table & Columns
- Changing Column’s Length Joins & Views
SAS / ACCESS :
- Import & Export Procedures
- Importing data from Ms-Access & Ms- Excel
- Importing data from Oracle data base
- DbLoad Procedure
SAS / GRAPH :
- Gchart Procedure Vertical, Horizontal,
- Pie Donut Group, Subgroups
- Gplot Procedure
- Mutliple Plots & Overlay
- Symbol Statement
- Title and Footnote Statements
- Goptions
SAS / MACROS :
- Macro Concepts Macros And Macro Variables
- Creating Macro Variables Using Macro Variables
- Creating Modular Code With Macros
- Invoking A Macro Adding Parameters To Macros
- Macros With Conditional Logic Using Various Procedures In Macros
- Automatic Variables
- Macro Functions
To see the full course content Download now
Course Prerequisites
- Basic Programming knowledge
- Basic knowledge about Excel and Java / C++
Who can attend
- It is for data scientists and analytics.
- Other professionals, from technology field, willing to acquire a solid foundation of this widely-used Analytical language, can also opt for this course.
Number of Hours: 40hrs
Certification
- SAS Certified Clinical Trials Programmer Using SAS 9
- SAS Certified Associate: Programming Fundamentals Using SAS 9.4
- SAS Certified Specialist: Base Programming Using SAS 9.4
- SAS Certified Professional: Advanced Programming Using SAS 9.4
Key features
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Virtual Live Experience
- Preparing for Certification
FAQs
DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Materials
- Preparing for Certification
Call now: +91-99003 49889 and know the exciting offers available for you!
We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.
Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.
All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.
No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.
DASVM Technologies provides many suitable modes of training to the students like:
- Classroom training
- One to One training
- Fast track training
- Live Instructor LED Online training
- Customized training
Yes, the access to the course material will be available for lifetime once you have enrolled into the course.
You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.
Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.
Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.
We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.
DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.
Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.
Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com
