Introduction to Base and Advance SAS

What we will be covering in 18 Lesson :

1. Lesson 1: SAS Course Introduction and SAS Datasets Creation

   • Introduction to the SAS environment and creating permanent libraries.

   • Learning to create SAS datasets, including character and numeric variables.

   • Formatting variables, renaming, labeling, and modifying variable properties.

2. Lesson 2: Report Generation on SAS

   • Generating reports using PROC PRINT and PROC REPORT.

   • Customizing reports with titles, footnotes, and formatting options.

   • Saving reports in different formats (HTML, PDF, RTF).

3. Lesson 3: Basic Queries and Subsetting in SAS

   • Subsetting datasets using the KEEP and DROP statements.

   • Using conditional statements (IF-THEN) and operators (WHERE, IN, BETWEEN) for data selection.

   • Performing basic data transformations and calculations.

4. Lesson 4: Creating Variables in SAS

   • Creating new variables using assignment statements and expressions.

   • Working with SAS functions for data manipulation and transformation.

   • Modifying variable attributes, lengths, and formats.

5. Lesson 5: SAS and Categorical Data - Splitting Data Sets and Sorting

   • Splitting datasets based on condition statements using IF-THEN and SELECT CASE.

   • Sorting datasets by variables in ascending or descending order.

   • Identifying unique observations using NODUPKEY and NODUP.

6. Lesson 6: Displaying Frequency Distribution and Using PROC TABULATE

   • Generating frequency distribution reports using PROC FREQ.

   • Cross-tabulating variables and creating summary tables with PROC TABULATE.

   • Applying formats, adding rows and columns, and customizing tabular reports.

7. Lesson 7: Quantitative Data and SAS - Saving Reports using ODS and PROC MEANS

   • Saving reports in different output formats using the Output Delivery System (ODS).

   • Generating means reports for variables and applying formats.

   • Segmenting reports using CLASS variables and applying conditions with WHERE statement.

8. Lesson 8: Generating Summary Reports and Descriptive Reports using PROC UNIVARIATE

   • Creating summary reports using PROC PRINT, PROC SUMMARY, and PROC MEANS.

   • Generating descriptive statistics and histograms using PROC UNIVARIATE.

   • Analyzing and visualizing data distributions and outliers.

9. Lesson 9: Functions in SAS - User-defined Formats, In-built Functions, DATE, TIME, TEXT, and Numeric Functions

   • Creating and using user-defined formats for data manipulation.

   • Exploring in-built functions for date, time, text, and numeric manipulations.

   • Applying functions such as INPUT, PUT, DATE, TIME, SUBSTR, CATX, ROUND, and more.

10. Lesson 10: Advanced Options - Converting Data Types, Generating Advanced Reports using Procedure Report

    • Converting data types using INPUT and PUT functions.

    • Generating advanced reports with headers, footers, page numbers, and titles using PROC REPORT.

    • Utilizing options like COLUMN, DEFINE, COMPUTE, and BREAK to customize report output.

11. Lesson 11: Transposing, Combining, and Appending Data Sets

    • Transposing observations into variables using PROC TRANSPOSE.

    • Combining and appending datasets using SET, MERGE, and UPDATE statements.

    • Manipulating data structures and variable names during combining and appending.

12. Lesson 12: Advanced Options - Merging Data Sets, Using Arrays, Reading from RAW and Delimited Files

    • Merging datasets using different types of joins (FULL, INNER, LEFT, RIGHT).

    • Working with arrays for efficient processing of multiple variables.

    • Reading and importing data from raw and delimited files.

13. Lesson 13: Learning Proc SQL - Selecting, Creating, Grouping, and Joining Data

    • Performing data manipulations and queries using PROC SQL.

    • Selecting columns, filtering rows, and creating new variables.

    • Grouping and summarizing data, joining datasets using SQL syntax.

14. Lesson 14: SAS Macros - Creating and Using Macro Programs and Variables

    • Understanding the concept of SAS macros and macro variables.

    • Creating and executing macro programs with positional and keyword parameters.

    • Managing local and global macro variables and incorporating macros in data steps and PROC SQL.

15. Lesson 15: Advanced SAS (I) - Proc SQL, Advanced Data Manipulation Techniques

    • Using advanced techniques in PROC SQL, including subqueries, correlated queries, and set operators.

    • Performing advanced data manipulations using advanced SQL functions.

    • Leveraging SQL with SAS data step and other procedures.

16. Lesson 16: Advanced SAS (II) - SAS Macros, Creating and Managing Macro Variables

    • Advanced techniques in SAS macros, such as conditional processing and looping.

    • Creating and managing macro variables within macro programs.

    • Integrating macros with other SAS procedures and data steps.

17. Lesson 17: Advanced SAS (III) - Advanced Data Manipulation Techniques, PROC SQL and Macros Integration

    • Exploring advanced data manipulation techniques using SAS functions and techniques.

    • Integrating PROC SQL and SAS macros for advanced data processing and manipulation.

    • Creating complex data transformation and analysis scenarios.

18. Lesson 18: Review and Practice, Final Project or Case Study