Purchase & study exam preparing with A00-212 pass-king quiz training materials

SASInstitute A00-212 Exam Overview:

Topics of A00-212 : SAS Advanced Programming for SAS 9 Exam

Candidates must know the exam topics before they start of preparation. because it will really help them in hitting the core. Our A00-212 : SAS Advanced Programming for SAS 9 Dumps will include the following topics:

1. Accessing Data Using SQL

Generate detail reports by working with a single table, joining tables, or using set operators in the SQL procedure.

• Combine tables using set operators - union, outer join, except, intersect.
• Use the SELECT statement.
• Validate a query.
• Create new columns.
• Sort data.
• Join tables - inner joins, full joins, right joins, left joins.
• Retrieve rows that satisfy a condition.
• Select columns in a table.

Generate summary reports by working with a single table, joining tables, or using set operators in the SQL procedure.

• Summarize data.
• Group data.
• Filter grouped data.

Construct sub-queries and in-line views within an SQL procedure step.

• Subset data by using correlated subqueries.
• Subset data by using non-correlated subqueries (HAVING clause).
• Reference an in-line view with other views or tables (multiple tables).

Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques.

• Alter columns attributes.
• Delete rows.
• Use SAS data set options with PROC SQL.
• Delete a table.
• Insert rows into tables.
• Use PROC SQL with the SAS Macro Facility.
• Create an index.
• Update data values in a table.
• Create SAS Data sets (tables).

Access Dictionary Tables using the SQL procedure.

• Use the DESCRIBE TABLE statement.
• Access SAS system information by using DICTIONARY tables.

2. Macro Processing

Create user-defined and automatic macro variables within the SAS Macro Language.

• Use %GLOBAL statement.
• Define Macro variables.
• Use the SYMPUT and SYMPUTX routine in the DATA Step.
• Use INTO clause of the SELECT statement in SQL.
• Use %LOCAL statement.
• Use %INPUT statement.
• Use the SYMGET function to return the value of a macro variable to the DATA step during DATA step execution.

Automate programs by defining and calling macros using the SAS Macro Language.

• Pass information into a macro using parameters.
• Define a macro.
• Generate SAS Code conditionally by using the %IF-%THEN-%ELSE macro statements or iterative %DO statements.
• Use the %MACRO statement.
• Insert comments into macros.

Understand the use of macro functions.

• Pass information into a macro using parameters.
• Define a macro.
• Generate SAS Code conditionally by using the %IF-%THEN-%ELSE macro statements or iterative %DO statements.
• Use the %MACRO statement.
• Insert comments into macros.

Use various system options that are available for macro debugging and displaying values of user-defined and automatic macro variables in the SAS log.

• Use system options to track problems.
• Examine macro variable resolution with SYMBOLGEN.
• Use the %PUT statement to track problems.
• Examine the generated SAS statements with MPRINT.
• Trace the flow of execution with MLOGIC.

Create data-driven programs using SAS Macro Language.

• Create macro variables with a list of values.
• Use indirect reference to macro variables.
• Generate repetitive macro calls using the %DO loop, macro variable, and the EXECUTE routine.

3. Advanced Programming Techniques

Demonstrate the use of advanced data look-up techniques such as array processing, hash objects, formats, and merging.

• Use formats to create data via lookups.
• Combine multiple data sets using FILEVAR= option.
• Combine data conditionally using multiple set statements.
• Create custom formats with the PICTURE statement.
• Process data with multi-dimensional arrays.
• Combine data using multiple set statements with KEY= option.
• Compare DATA step match-merge and PROC SQL joins.
• Use hash objects as lookup tables.
• Manage custom formats with FMTSEARCH= system option.

Reduce computing resource requirements by controlling the space required to store SAS data sets.

• Eliminate variables and observations.
• Reduce length of numeric variables.
• Use compression techniques, RLE (Run-Length Encoding) and RDC (Ross Data Compression).
• Use SAS views.

Use the FCMP procedure to create a user-defined function.

• Define a SAS function

Perform effective benchmarking.

• Interpret the resulting resource utilization statistics for the Z/OS environment and for directory based OS.
• Understand resources related to efficiency.
• Use SAS System options to track resources.

Use SAS indexes.

• Create and delete indexes using the DATA step, the DATASETS procedure, or the SQL procedure.
• Identify appropriate applications for using indexes.

Compare techniques to eliminate duplicate data.

• Use the SORT procedure.
• Use the SQL procedure.
• Use the DATA step.

SASInstitute A00-212 Exam Syllabus Topics:

Reference: https://www.sas.com/en_us/certification/credentials/foundation-tools/advanced-programmer.html