Data Manager (Analytics Programmer) is for users who want to learn how to write SAS programs and prepare data for analysis. The comparisons of manipulation techniques and resource cost benefits are designed to help programmers choose the most appropriate technique for their data situation. It focuses on the components of the SAS macro facility and how to design, write, and debug macro systems. Emphasis is placed on understanding how programs with and without macro code are processed. It also covers how to process SAS data using Structured Query Language (SQL).
Course helps you prepare you for the following certification exam(s): SAS Base Programming Exam for SAS 9, SAS Certified Advanced Programmer for SAS 9.
Suitable for Targeted Towards Business analysts and SAS programmers
Course Outline:
SAS Programming 1: Essentials
- Navigate the SAS windowing environment
- Navigate the SAS Enterprise Guide programming environment
- Read various types of data into SAS data sets
- Create SAS variables and subset data
- Combine SAS data sets
- Create and enhance listing and summary reports
- Validate SAS data sets.
SAS Programming 2: Data Manipulation Techniques
- Control SAS Data Set Input And Output
- Combine SAS Data Sets
- Summarize, Read, And Write Different Types Of Data
- Perform DO Loop And SAS Array Processing
- Transform Character, Numeric, And Date Variables.
SAS Macro Language 1: Essentials
- Perform text substitution in SAS code
- Automate and customize the production of SAS code
- Conditionally or iteratively construct SAS code
- Use macro variables and macro functions.
SAS SQL 1: Essentials
- Query and subset data
- Summarize and present data
- Combine tables, including complex joins and merges
- Create and modify table views and indexes
- Replace multiple data and proc steps with one sql query.
SAS Programming 3: Advanced Techniques and Efficiencies
- Benchmark computer resource usage
- Control memory, i/o, and cpu resources
- Create and use indexes
- Combine data horizontally
- Use hash and hiter data step component objects and arrays as lookup tables
- Compress sas data sets
- Sample your sas data sets
- Create and use sas data views
- Safely reduce the length of numeric variables
- Create user-defined functions and informats.
Learn how to :
- Read raw data files and SAS data sets
- Investigate and summarize data by generating frequency tables and descriptive statistics
- Create SAS variables and recode data values
- Subset data
- Combine multiple SAS files
- Create listing, summary, HTML, and graph reports.
- Use macro code to write more efficient SAS programs
- Use the SQL procedure as an easy, flexible way to query and combine your data
- Use advanced SAS programming techniques such as creating samples and indexes, using lookup tables to match data, and modifying and tracking data set changes
- Write SAS programs to maximize efficiency.
Prerequisites
- Before attending this course, you should have experience using computer software. Specifically, you should be able to
- Understand file structures and system commands on your operating systems
- Access data files on your operating systems.
- No prior SAS experience is needed.
- If you do not feel comfortable with the prerequisites or are new to programming and think that the pace of this course might be too demanding, you can take the SAS Programming Introduction: Basic Concepts course before attending this course.
- Investigate and summarize data by generating frequency tables and descriptive statistics
- Create SAS variables and recode data values
- Subset data
- Combine multiple SAS files
- Create listing, summary, HTML, and graph reports.
The fees is inclusive of
- Fee: ₹75,000+GST | Duration: 96 Hours
- Training & Digital Badge
- Course material
- 2 attempts of Global certification
The SAS Global Certification Program allows you to validate your SAS software skills and earn the globally-recognised credential endorsed by SAS.
Earn a Digital Badge
Stand out from your peers. You’ve earned it.
When you earn an internationally recognized credential from SAS, you also earn a digital badge that you can share on your social media sites.
