• slide1

Advance SAS Certification

SAS Certified Advanced Programmer for SAS9 Credential

Required Exam
Candidates who earn this credential will have taken and earned passing scores of the following two exams:1)SAS Base Programming for SAS 9 exam, and 2)SAS Advanced Programming for SAS9 exam. This exam is administered bySAS and Pearson VUE.
63multiple-choiceandshort-answer questions(must achievescoreof65% correcttopass)
2hourstocomplete exam
Use exam IDA00-212 ;required when registering with Pearson VUE.

Exam topics include:
Accessing Data Using SQL
Generate detail reports by working with a single table, joining tables,or using set operators in the SQL procedure.
Generate summary reports by working with a single table,joining tables, or using set operators in the SQL procedure.
Construct sub-queries and in-line views withinan SQL procedure step.
Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques.
Access Dictionary Tables using the SQL procedure.

Macro Processing
Create and use user-defined and automatic macro variable swith in the SAS Macro Language. Automate programs by defining and callingm acros using the SAS Macro Language. Understand the use of macro functions.
Use various systemo ptions that are a vailable form acrode bugging and displaying values of
user defined and automatic macro variables in the SAS log.
Create data-driven programs using SAS Macro Language.

Advanced ProgrammingTechniques
Demonstrate the use ofa dvanced data look-up techniques such as array processing, hash objects, formats, and combining/merging data.

Reduce computing resource requirements by controlling the spacerequired to storeSAS data sets using compression techniques,length statements, or eliminating variables and observations.

Reduce programming time by developing reusable SAS programs which incorporate data stepviews, DATA steps that write SAS programs,and theF CMP procedure.

Perform effective benchmarking by using the appropriate SAS System options and interpreting the resulting resource utilization statistics.

Determine the resource sused by the SORT procedure and avoid unnecessary sorts by using appropriate indexes,dataset options, BY statement options, and the CLASS statement. Identify appropriate applications for using indexes and create them using the DATA step,the DATASETS procedure,or the SQL procedure.

Compare techniques to eliminated uplicate data using the DATA step,the SORT procedure, and the SQL procedure.

Why choose Main Value?

Flexible Timing

Flexible Payment option

Lab facility with Wi-Fi

Job assistance

All training are provided with best quality, professionally designed

Fully AC classrooms with projectors

Both industrial and professional training are conducted

Highly qualified and experienced trainer (min 8 year of industry exp)

Our Clients