SAS Language

Write idiomatic, production-quality SAS code. This skill covers the SAS language itself, independent of any framework.

Scope

DATA step programming (SET/MERGE/BY, RETAIN, arrays, DO loops, hash objects, first./last. processing)
PROC SQL (joins, subqueries, views, pass-through with CONNECT TO)
Macro language (%macro/%mend, macro variables, %local/%global, conditional %IF logic, quoting functions %STR/%NRSTR/%BQUOTE, CALL SYMPUTX)
Common PROCs: SORT, MEANS/SUMMARY, FREQ, TRANSPOSE, REPORT, PRINT, CONTENTS, DATASETS, FORMAT, IMPORT/EXPORT
Formats and informats (user-defined via PROC FORMAT, picture formats)
ODS output (HTML, PDF, RTF, Excel, OUTPUT destination)
File I/O: LIBNAME, FILENAME, INFILE/INPUT, FILE/PUT