You have decided that you are ready to take your next step on your SAS certification journey and are ready to go for the SAS Certified Professional: Advanced Programming Using SAS 9.4 credential. For those that are coming from the older SAS Base Programmer for SAS 9 credential, this will be your first performance-based exam. Those of you that have earned our newer SAS Certified Specialist: Base Programming Using SAS 9.4 credential have already tackled a performance-based exam, but there is still room for some pointers to explain some differences and tips for this exam.
First, as always, review the information on the credential web page. This includes a video demonstration of the exam experience that will show you the beginning of the exam. You don't want to miss this, as it will help you set-up your lab environment quickly and smoothly.
Next, let's talk about the big difference between this exam and the Base Programming Specialist performance-based exam. First, on the Base Programming exam, you answered questions about your output data sets to determine if you completed the projects correctly. The Advanced Programming Professional exam is different. Because you are being assessed on specific skills, we place more emphasis on your code to be sure that you solved the problem as described. For example, if the project asked you to solve a problem with PROC SQL, we need to ensure that you actually used PROC SQL and not a DATA Step. To accomplish this, you will run a saved SAS Macro against your completed solution, and this macro will evaluate both the content of your code and the output of your code. There is still a lot of flexibility for you to write your own code, we aren't looking for an exact match to a specific 'answer-key' program, as we know there different ways to get to the same solution. More information about the scoring macro and how to use it is in the video on the credential page linked above.
Another small difference from the Specialist exam is that you don't need to define libraries on the advanced exam. That is done automatically when you start SAS. This is explained in the exam introduction, but we have noticed that some candidates overlook this point.
You will create some SAS Macro programs during this exam. Some syntax errors (like unbalanced quotes or missing semicolons) that are rather harmless in DATA Step programs can cause weird problems when they occur in SAS Macro code. Resubmitting your code after fixing the error doesn’t resolve the problem in SAS and you can find yourself stuck with repeated, unexpected messages in your log. If you get notes in your logs such as “The quoted string currently being processed has become more than 262 characters long”, you have arrived in “confused quote-land.” If this happens to you, you should save your programs, close your SAS application, then reopen it and edit your program. Don’t worry about remembering this specific error message, we provide a reminder within the macro questions on the exam in case it happens to you so that you can get back on track quickly.
And to help you along with your prep, here are 3 papers from SAS conferences to supplement your studying, one from each topic area of the exam:
SQL: Merges and Joins
Macro: Macro Quoting Functions
Advanced Topics:Hash Objects
I know that all of this is a lot to digest. One final pointer: If, during your thorough review of the credential web page, you didn't notice that the practice exam is currently free, go back now and take a look at the "Training & Exam Preparation" section for the link to this valuable resource.
Good luck with your exam prep - you can do this!
... View more