SAS Certifications are among the most globally recognised credentials in the industry. This event includes a study session in the morning followed by the SAS® Certified Professional: Advanced Programming Using SAS® 9.4 exam in the afternoon. For more details about exam topics, preparation and logistics click click here.

• Understand the logistics for sitting the SAS® Certified Professional: Advanced Programming Using SAS® 9.4 exam
• Improve specific areas of your SAS programming knowledge

Who should attend

Individuals wanting to sit the SAS® Certified Professional: Advanced Programming Using SAS® 9.4 exam.

Formats available	Standard Duration (duration can vary, see event schedule for details)
Classroom:	1.0 day

Prior to this event you should have experience in advanced programming and data management using SAS®9 and should be able to

• Accessing Data Using SQL
  • Generate detail reports by working with a single table, joining tables, or using set operators in SQL
  • Generate summary reports by working with a single table, joining tables, or using set operators in the SQL.
  • Construct sub-queries and in-line views within an SQL procedure step.
  • Use special features of the SQL procedure
• Macro Processing
  • Create and use user-defined and automatic macro variables within the SAS Macro Language.
  • Automate programs by defining and calling macros using the SAS Macro Language.
  • Use macro functions.
  • Debug Macros
  • Create data-driven programs using SAS Macro Language
• Advanced Techniques
  • Process data using 1 and 2 dimensional arrays.
  • Process data using hash objects
  • Use SAS utility procedures

  You can attain this knowledge by attending the SAS SQL 1: Essentials, SAS Macro Language 1: Essentials and SAS Programming 3: Advanced Techniques courses.

Key exam areas will be reviewed with the opportunity for you to ask questions

SAS® Certified Professional: Advanced Programming Using SAS® 9.4 exam