SAS course – Home page

[Philip Holland]

The SAS course is made up of sections containing SAS-related topics, with new topics posted over time. Note that the course topics below are not available to registered members with Free membership, so to upgrade your membership please click here.

The topics in each section are intended to be read in order, but most sections will be independent of other sections, unless otherwise stated:

• • • A. SAS components
      • [A1] What is SAS?
      • [A2] What is Base SAS?
      • [B1] How does a Data Step work?
      • [C1] What is a SAS procedure?
      • [F1] What is PROC SQL?
      • [G1] What is a SAS macro and what is a SAS macro variable?
      • [I1] What are the differences between graphs in classic SAS/GRAPH and ODS Graphics
      • [K1] What is Efficiency
      • [N1] What is SAS Enterprise Guide?
      • [O1] What is SAS Studio?
      • The SAS course notes can be found if you use the SAS course eBook Web App (for Free members) in the SAS Skills Discussion Forum (included in the Free membership)
    • B. Data Steps
      • Full course in LMS
      • [B1] How does a Data Step work?
      • [B2] IF THEN ELSE, SELECT WHEN OTHERWISE & WHERE
      • [B3] DO loops
      • [B4] Numeric functions
      • [B5] Character functions
      • [B6] Date & time values and functions
      • [B7.1] Formats & informats – Introduction
      • [B7.2] Formats & informats – Dates and times
      • [B8] Output SAS data sets
      • [B9] Merging data sets
      • [B10.1] FILE & PUT statements – Introduction
      • [B10.2] FILE & PUT statements – Creating and updating files
      • [B10.3] FILE & PUT statements – Columns, lines and pages
      • [B11] Errors and debugging
      • Buy the SAS course notes ebook
      • The SAS course notes can be found if you use the SAS course eBook Web Apps in the SAS Programming Forum (included in the Programming subscription)
    • C. Base SAS Procedures
      • Full course in LMS
      • [C1] What is a SAS procedure?
      • [C2] PROC SORT
      • [C3] PROC COPY
      • [C4] PROC FORMAT
      • [C5] PROC COMPARE
      • [C6] PROC TRANSPOSE
    • D. External files
    • E. SAS/ACCESS
    • F. PROC SQL
      • Full course in LMS
      • [F1] What is PROC SQL?
      • [F2] SELECT & FROM
      • [F3] ORDER BY
      • [F4] GROUP BY, HAVING & summary functions
      • [F5.1] Joins, WHERE & ON – Introduction
      • [F5.2] Joins, WHERE & ON – JOIN & UNION
      • [F5.3] Joins, WHERE & ON – Sub-queries
      • [F6] DISTINCT
      • [F7] CREATE
      • [F8] DROP
      • [F9] DELETE FROM
      • [F10] INSERT INTO
      • [F11] UPDATE
      • [F12] ALTER TABLE
      • [F13] Limitations
      • Buy the SAS course notes ebook
      • The SAS course notes can be found if you use the SAS course eBook Web Apps in the SAS Programming Forum (included in the Programming subscription)
    • G. SAS Macros
      • Full course in LMS
      • [G1] What is a SAS macro and what is a SAS macro variable?
      • [G2] %MACRO & %MEND
      • [G3.1] Calling macros: Introduction
      • [G3.2] Calling macros: Autocall and SASAUTOS
      • [G3.3] Calling macros: SASMACR catalog
      • [G4] Macro statements
      • [G5.1] Macro variables: Introduction
      • [G5.2] Macro variables: Automatic system variables
      • [G5.3] Macro variables: %LET
      • [G5.4] Macro variables: CALL SYMPUT
      • [G5.5] Macro variables: PROC SQL SELECT INTO
      • [G5.6] Macro variables: Scope
      • [G5.7] Macro variables: Resolving
      • [G6.1] Macro functions: Introduction
      • [G6.2] Macro functions: Using Data Step functions
      • Buy the SAS course notes ebook
      • The SAS course notes can be found if you use the SAS course eBook Web Apps in the SAS Programming Forum (included in the Programming subscription)
    • H. ODS destinations
    • I. ODS Graphics
    • J. SAS/GRAPH
    • K. Performance
    • L. SAS platform differences
    • M. Editors for SAS Programs
    • N. SAS Enterprise Guide
      • [N1] What is SAS Enterprise Guide?
    • O. SAS Studio
      • [O1] What is SAS Studio?

Topic