Carnegie African Diaspora Programme

The structures of a SAS program; Write a typical SAS program made up of DATA and PROC steps; Navigate the SAS programming environment, and employ various tools therein for writting, and debugging SAS programs; Output, critically examine, and interpret the outputs of a SAS program; Enter raw data internally in SAS, and input raw data from external files into SAS to create SAS data sets; Read data into SAS using various INFORMATS and INPUT styles; Write SAS variables using various FORMATS; Subset SAS data sets at different stages using various programming tools such as logical expressions in the DATA step; Properly manipulate data in the DATA STEP which includes DATA using SAS functions and the DROP or KEEP options; Syntatically call for various SAS procedures as well as options and ancillary statements within their syntaxes; Use ARRAYS in SAS to perform table-look-ups, rotate data sets, and perform repeated iterations using indexed variables; Reduce coding by using nested do loops in iterative processing; Export SAS data sets as external data useful to other applications; Import data from other applications using dynamic data exchange; Join and merge SAS data sets under different conditions; Carry out basic statistical analysis, and produce reports using various SAS procedures; Manage data within SAS by creating permanent libraries and moving data from one library to another.

SAS –SQL programming. The use of SAS programming tools and PROC SQL to achieve the following: • SAS Programming Basics; • The Data Step; • The PROC step, • Sundry methods of data entry, storage, retrieval • Data manipulations within SAS, • dealing with incomplete observations, • SAS numeric functions • SAS character functions; • Iterative processing • Accumulating totals • Do groups • Array processing • Table look-ups • Programming with SAS software; • Statistical data analysis with SAS • Applications • Reducing data entry