Douwe Horsthuis 2023-01-15
This Repo contains course summaries tasks and self written summaries for the Coursera course SAS Programmer Specialization. There are 4 courses that lead to a Professional Certificate. Each course has it’s own summary and activities. To do the activities see the screenshot that explain how to upload the files to SAS. To go to the summaries:
Course 1: Getting Started With SAS Programming
Subjects: [ SAS steps, Exporting data, Simple Syntax error solving steps, Column lengths, Missing values, Libraries, Working with excel data, Importing unstructured data, Procedures, WHERE statement (Missing values and WHERE statements, Wildcards for WHERE statements), Format statements (Decimals, Date), combining statement, Macro variables, Formatting your output, Sorting values, Deleting duplicates, Creating new Columns (Using Functions), Conditional Processing with IF-THEN/ELSE (Processing Multiple Statements with IF-THEN/DO), Report (Using Titles and Footnotes, Labels for column names, Segmenting Reports, No observations, Frequency report, Summary Statistics Report), ODS statement, SQL].
Course 2: Doing More with SAS Programming
Subjects: [Data step (Order), Debugging (SAS Enterprise debugger, Online platform, Implicit and explicit outputs, Accumulating column), Functions (Calculation, Formatting, Character functions, Call routine, Converting column type), Combining tables (Concatenating tables, One-to-one merge, One-to-many merge, Merging non-matching rows, Merging multiple tables), Do Loops (Iterative DO loops, Conditional DO loops, Combining both types of DO loops,Restructuring Data (Restructuring table structures, Transposing)].
Course 3: Preparing for the SAS Programming Certification Exam
Subjects: [
Course 4: TO BE STARTED