So what do you need to know before taking SAS Base Programming?
SAS 9 exam is the most basic and first certification you need to take before you can advance to another level so things can get pretty boring because it will test you on theory and assesses your attention to detail through programming skills questions. But the good news is that the test is fairly simple and easy to score.
This brings us to the FIVE MAIN AREAS that test takers should know:
- How to access and read various type of data on SAS?
- It is important to assess if test takers know when to use formatted or list input to read raw data files through INPUT statement including COLUMN and LINE POINTER CONTROLS and TRAILING @ CONTROLS, understand the difference between character and numeric data & standard and non-standard data, how to use INFILE statement with DLM/PAD/DSD options to read data and how to combine datasets.
- How to create data structures?
- Another important thing that any new SAS beginners should definitely have knowledge of is how to assess temporary and permanent datasets – including knowing how to handle and manipulate different kinds of data values such date and time. Test takers will also be tested on how to filter and subset data using WHERE, DROP= and KEEP= statements.
- How to manage and clean data?
- This is essentially the longest chapter that we need to cover and ones need to know how to execute SAS statements and sort observations – including how to use various modification syntax such as RENAME=, LABEL and FORMAT, BY statement and functions – for instance: SCAN, SUBSTR, UPCASE, TRIM, LOWCASE, INT and ROUND.
- They will be tested on how to process data using DO loops and SAS arrays.
- Cleaning data is the most time consuming process and one needs to know how to make use of PROC FREQ, PROC MEAN and PROC UNIVARIATE to validate data values and check for missing observations and anomalies.
- How to generate reports?
- Once all logic checks have been in place, we will need to know how to generate output using PROC PRINT by selecting certain variables with VAR statement or by selecting certain observations with WHERE statement. Of course, the necessary styling and formatting such as titles, footnotes would be good to know and learn.
- Ones can also generate and save the report in HTML, PDF, RTF and LISTING using ODS statement.
- How to handle errors?
- Test takers will be tested on identifying and rectifying programming logic errors, syntax errors and data errors.
Categories: SAS Learning