Base SAS (Statistical Analysis System) training is a good way to enter into the data analytics industry. This course is broadly divided into two categories: essentials and data manipulation techniques.
This business analytics course provides the concepts along with hands-on experience on writing SAS programs, understanding data sets, sub-setting data sets, creating summary reports with different procedures, controlling input and output. Participants build proficiency in data manipulation and debugging techniques. The training will drive the trainees through SAS windowing environment for executing conditional code, SAS array processing; and introduces other SAS languages.
With this comprehensive training, you’ll develop capabilities in the following:
- Writing SAS program
- Reading and customizing data sets
- Reading data from raw data files, database, and spreadsheet
- Formatting and manipulating data
- Merging SAS data-sets
- Generating reports
- Selecting variables and writing observations
- Executing data transformation
- Using the PUTLOG statement for debugging
- Perform Do loop and SAS arrays processing for data iteratively
- Restructuring and combining data sets
- Creating permanent formats
- Familiarity with other SAS languages
Target audience
- Graduates
- Programmers
- Business Analysts
- Data Managers
- SAS Programmers
Prerequisites
The candidates with basic understanding of programming language, EXCEL, and SQL can undergo this training.
SAS Programming 1: Essentials
1. Introduction
- An overview of SAS foundation
- Course logistics
- Course data files
2. SAS Programs
- Introduction to SAS programs
- Submitting a SAS program
- Working with SAS program syntax
3. Accessing Data
- Examining SAS data sets
- Accessing SAS libraries
4. Producing Detail Reports
- Submitting report data
- Sorting and grouping report data
- Enhancing reports
5. Formatting Data Values
- Using SAS formats
- Creating user-defined formats
6. Reading SAS Data Sets
- Reading a SAS data set
- Customizing a SAS data set
7. Reading Spreadsheet and Database Data
- Reading spreadsheet data
- Reading database data
8. Reading Raw Data Files
- Introduction to reading raw data files
- Reading standard delimited data
- Reading nonstandard delimited data
- Handling missing data
9. Manipulating Data
- Using SAS functions
- Conditional processing
10. Combining SAS Data Sets
- Concatenating data sets
- Merging data sets one-to-one
- Merging data sets one-to-many
- Merging data sets with nonmatches
11. Creating Summary Reports
- Using the FREQ procedure
- Using the MEANS and UNIVARIATE procedures
- Using the Output Delivery System
12. Learning More
SAS Programming 2: Data Manipulation Techniques
1. Introduction
- An overview of SAS foundation
- Course logistics
- Course data files
2. Controlling Input and Output
- Writing observations explicitly
- Writing to multiple SAS data sets
- Selecting variables and observations
3. Summarizing Data
- Creating an accumulating total variable
- Accumulating totals for a group of data
4.Reading Raw Data Files
- Reading raw data files with formatted input
- Controlling when a record loads
5. Data Transformations
- Manipulating character values
- Manipulating numeric values
- Converting variable type
6. Debugging Techniques
- Using the PUTLOG statement
7. Processing Data Iteratively
- DO loop processing
- Conditional DO loop processing
- SAS array processing
- Using SAS arrays
8. Restructuring a Data Set
- Rotating with the DATA step
9. Combining SAS Data Sets
- Using data manipulation techniques with match-merging
10. Creating and Maintaining Permanent Formats
- Creating permanent formats
11. Other SAS Languages
- An overview of other languages
- Using the SQL procedure
- The SAS macro language
12. Learning More