We're so confident of our products that we provide no hassle product exchange.
SASInstitute A00-420 Exam Overview:
| Certification Vendor: | SAS Institute |
|---|---|
| Exam Name: | SAS Viya Intermediate Programming |
| Exam Number: | A00-420 |
| Exam Format: | Multiple-choice, Short-answer, Fill-in-the-blank |
| Real Exam Qty: | 60 |
| Certificate Validity Period: | 3 years |
| Exam Price: | 180 USD |
| Passing Score: | 70% |
| Related Certifications: | SAS Certified Specialist: Base Programming Using SAS 9.4 |
| Available Languages: | English |
| Exam Duration: | 120 minutes |
| Recommended Training: | SAS Programming in Viya Course SAS Viya Intermediate Programming Official Content Guide |
| Exam Registration: | Pearson VUE Registration SAS Certification Portal |
| Sample Questions: | SASInstitute A00-420 Sample Questions |
| Exam Way: | Online proctored or in-person at Pearson VUE test centers |
| Pre Condition: | Recommended: SAS Certified Specialist: Base Programming Using SAS 9.4 or equivalent experience |
| Official Syllabus URL: | https://www.sas.com/en_us/certification/exams/a00-420-sas-viya-intermediate-programming.html |
SASInstitute A00-420 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Programming in SAS Viya Concepts | 8% | - SAS Viya architecture: Compute Server vs CAS - Determining when to use CAS for tasks - Serial vs parallel and in-memory processing |
| Prepare Data with CAS Actions | 22% | - Data type conversion and missing value imputation - Using dataStep and fedSQL action sets - Update, copy and alter in-memory tables |
| Explore and Validate Data with CAS Actions | 8% | - Inspecting table metadata and content - Identifying duplicates and invalid values |
| CAS-Enabled Procedures and User Defined Formats | 8% | - Using PROC MEANS, SUMMARY, FREQTAB, MDSUMMARY - Procedures running on CAS vs Compute Server - User-defined formats in CAS |
| CAS Language Basics | 18% | - Capturing and processing CAS action results - CASL syntax, variables, arrays and dictionaries - Using SOURCE blocks for code substitution |
| DATA Step and SQL Programming in CAS | 13% | - Execution location and threading rules - Updating DATA step for CAS compatibility - Converting PROC SQL to PROC FEDSQL |
| Access Data with CAS Actions | 8% | - Managing caslibs and data sources - Loading, uploading and promoting tables |
| Managing Data with CAS Enabled Procedures | 13% | - Loading, promoting, saving and dropping in-memory tables - Working with CAS libraries and sessions - CAS column data types and conversion |
| Analyze and Summarize Data with CAS Actions | 7% | - Summary statistics and frequency tables - Generating visualizations and reports via ODS |
SASInstitute SAS Viya Intermediate Programming Sample Questions:
Question #1
Which CASL program correctly adds the Sales caslib to access data in the /data/sales folder?
- A. proc cas;
table.addCaslib,
name="/data/sales",
path="/data/sales";
run; - B. proc cas;
table.addCaslib /
name="/data/sales",
dataSource={srctype="path"};
run; - C. proc cas;
table.addCaslib /
name="sales",
dataSource={srctype="path"},
path="sales";
run; - D. proc cas;
table.addCaslib /
name="sales",
path="/data/sales";
run;
Correct Answer: D 🗳️
Question #2
Which CAS-enabled procedure is used to import data into a CAS table?
- A. CASLIB
- B. CASDATA
- C. CASTABLE
- D. CASIMPORT
Correct Answer: D 🗳️
Question #3
Which CAS action is used to generate descriptive statistics for numeric variables in a CAS table?
- A. cas.describe
- B. cas.profile
- C. cas.statistics
- D. cas.summarize
Correct Answer: A 🗳️
Question #4
Which CAS action is used to generate a summary report of missing values in a CAS table?
- A. cas.missing
- B. cas.validate
- C. cas.check
- D. cas.summary
Correct Answer: A 🗳️
Question #5
Which SQL clause is used to calculate summary statistics for variables in a CAS table?
- A. FROM
- B. HAVING
- C. GROUP BY
- D. SELECT
Correct Answer: C 🗳️
By Angela
