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: Intermediate Programming Using SAS Viya SAS Viya Programming Specialist |
| Real Exam Qty: | 65-70 |
| Exam Price: | $180 USD |
| Certificate Validity Period: | 5 years |
| Available Languages: | English |
| Exam Format: | Multiple Choice, Short Answer |
| Passing Score: | 71% |
| Exam Duration: | 110 minutes |
| Sample Questions: | SASInstitute A00-420 Sample Questions |
| Exam Way: | Pearson VUE testing centers or online proctored exam. |
| Pre Condition: | Recommended experience with SAS programming and familiarity with SAS Viya platform concepts. |
| Official Syllabus URL: | https://www.sas.com/en_gb/certification/credentials/foundation-tools/viya-programming-specialist.html |
SASInstitute A00-420 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Managing Data with CAS-Enabled Procedures | 10-15% | - Managing data with CAS-enabled procedures
|
| Topic 2: Analyze and Summarize Data with CAS Actions | 5-10% | - Data analysis and summarization
|
| Topic 3: Explore and Validate Data with CAS Actions | 5-10% | - Data exploration and validation
|
| Topic 4: CAS-Enabled Procedures and User-Defined Formats | 5-10% | - CAS-enabled procedures and formats
|
| Topic 5: Programming in SAS Viya Concepts | 5-10% | - Programming in SAS Viya concepts
|
| Topic 6: DATA Step and SQL Programming in CAS | 10-15% | - DATA step and SQL programming in CAS
|
| Topic 7: CAS Language Basics | 15-20% | - CASL fundamentals
|
| Topic 8: Access Data with CAS Actions | 5-10% | - Data access using CAS actions
|
| Topic 9: Prepare Data with CAS Actions | 20-25% | - Data preparation using CAS actions
|
SASInstitute SAS Viya Intermediate Programming Sample Questions:
Question #1
Which CAS action is used to aggregate data at a higher level of granularity in a CAS table?
- A. cas.summarize
- B. cas.groupby
- C. cas.aggregate
- D. cas.collapse
Answer: B
Question #2
Assume all caslib names follow libref naming conventions.
Which code assigns librefs of the same name to each caslib?
- A. caslib assign libref;
- B. caslib _all_ assign;
- C. caslib libref assign;
- D. caslib assign _all_;
Answer: B
Question #3
Which CAS action is used to calculate summary statistics for variables in a CAS table?
- A. cas.describe
- B. cas.stats
- C. cas.summary
- D. cas.aggregate
Answer: C
Question #4
Which statement is used to define a user-defined format in SAS Viya?
- A. FORMAT statement
- B. INFORMAT statement
- C. LABEL statement
- D. LENGTH statement
Answer: A
Question #5
Which statement is used to apply a user-defined format within a PROC SQL query?
- A. FORMAT SASDATE
- B. GROUP BY
- C. WHERE
- D. FORMAT
Answer: D
By Cornelia
