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 |
| Related Certifications: | SAS Certified Specialist: Base Programming Using SAS 9.4 |
| Exam Duration: | 120 minutes |
| Passing Score: | 70% |
| Available Languages: | English |
| Exam Format: | Multiple-choice, Short-answer, Fill-in-the-blank |
| Exam Price: | 180 USD |
| Certificate Validity Period: | 3 years |
| Real Exam Qty: | 60 |
| Recommended Training: | SAS Viya Intermediate Programming Official Content Guide SAS Programming in Viya Course |
| 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 |
|---|---|---|
| Topic 1: DATA Step and SQL Programming in CAS | 13% | - Updating DATA step for CAS compatibility - Execution location and threading rules - Converting PROC SQL to PROC FEDSQL |
| Topic 2: Access Data with CAS Actions | 8% | - Loading, uploading and promoting tables - Managing caslibs and data sources |
| Topic 3: Programming in SAS Viya Concepts | 8% | - SAS Viya architecture: Compute Server vs CAS - Serial vs parallel and in-memory processing - Determining when to use CAS for tasks |
| Topic 4: Explore and Validate Data with CAS Actions | 8% | - Identifying duplicates and invalid values - Inspecting table metadata and content |
| Topic 5: Prepare Data with CAS Actions | 22% | - Update, copy and alter in-memory tables - Data type conversion and missing value imputation - Using dataStep and fedSQL action sets |
| Topic 6: Managing Data with CAS Enabled Procedures | 13% | - CAS column data types and conversion - Loading, promoting, saving and dropping in-memory tables - Working with CAS libraries and sessions |
| Topic 7: CAS-Enabled Procedures and User Defined Formats | 8% | - User-defined formats in CAS - Using PROC MEANS, SUMMARY, FREQTAB, MDSUMMARY - Procedures running on CAS vs Compute Server |
| Topic 8: CAS Language Basics | 18% | - Using SOURCE blocks for code substitution - CASL syntax, variables, arrays and dictionaries - Capturing and processing CAS action results |
| Topic 9: Analyze and Summarize Data with CAS Actions | 7% | - Generating visualizations and reports via ODS - Summary statistics and frequency tables |
SASInstitute SAS Viya Intermediate Programming Sample Questions:
Question #1
Which CAS action is used to create a new variable in the DATA step?
- A. FORMAT
- B. COMPUTE
- C. DROP
- D. ALTER TABLE
Answer: B
Question #2
Which CAS action is used to execute a DATA step program in SAS CAS?
- A. EXECUTE
- B. DATA
- C. RUN
- D. SUBMIT
Answer: D
Question #3
How can you associate a user-defined format with a variable in SAS?
- A. Using the LABEL statement in PROC FORMAT
- B. Using the BY statement in PROC FORMAT
- C. Using the WHERE statement in PROC SQL
- D. Using the FORMAT statement in the DATA step
Answer: D
Question #4
Which CAS action is used to delete a CAS table from memory?
- A. cas.discard
- B. cas.remove
- C. cas.delete
- D. cas.drop
Answer: D
Question #5
Which CAS action is used to calculate the frequency distribution of a categorical variable in a CAS table?
- A. cas.distribution
- B. cas.frequency
- C. cas.histogram
- D. cas.tabulate
Answer: D
By Beryl
