SASInstitute A00-231 시험요강:
| 주제 | 소개 |
|---|
| 주제 1 | - This section of the exam measures skills of Business Intelligence Analysts and covers generating structured reports using SAS procedures. Candidates must use PROC PRINT to create list reports while modifying output through statements like VAR, SUM, and WHERE. The section also focuses on generating summary reports using PROC FREQ, MEANS, and UNIVARIATE to analyze data distribution and validate information. Enhancing reports through user-defined formats, titles, and footnotes is also covered. Candidates are expected to utilize the Output Delivery System (ODS) to create reports in multiple formats such as HTML, PDF, RTF, XLSX, and CSV. Lastly, exporting data using PROC EXPORT and the SAS
- ACCESS XLSX engine is an essential competency.
|
| 주제 2 | - Access and Create Data Structures: This section of the exam measures skills of Data Analysts and covers the creation of temporary and permanent SAS data sets using the DATA step. Candidates are expected to investigate SAS data libraries using utility procedures such as LIBNAME and PROC CONTENTS. They must demonstrate proficiency in accessing data through the SET statement and PROC IMPORT, including reading delimited and Microsoft Excel files. Additionally, they must understand data set combination techniques such as concatenation and merging, manage SAS date values using appropriate informats and formats, and apply filtering techniques using WHERE, IF, DROP, and KEEP statements.
|
| 주제 3 | - Generate Reports and Output:
|
| 주제 4 | - Error Handling: This section of the exam measures skills of SAS Programmers and covers techniques for identifying and resolving programming errors. Candidates must be able to debug logic errors using the PUTLOG statement and temporary variables like N and ERROR. The section emphasizes recognizing and correcting syntax errors, including misspelled keywords, missing semicolons, and unmatched quotation marks. Candidates should also know how to interpret SAS logs to diagnose issues effectively and apply best practices to prevent common errors.
|
| 주제 5 | - Manage Data: This section of the exam measures skills of Data Engineers and covers essential data management techniques in SAS. Candidates must be able to sort observations using the SORT procedure, eliminate duplicates, and conditionally execute statements using IF-THEN
- ELSE and DO-END structures. They should be proficient in creating and modifying variables using assignment statements and formatting options, such as LABEL and FORMAT. The section also covers methods for accumulating subtotals using BY-group processing and RETAIN and SUM statements. Additionally, candidates must manipulate character and numeric data using SAS functions such as SCAN, SUBSTR, ROUND, and INT, perform type conversions with INPUT and PUT functions, and process data iteratively using DO loops.
|
참조: https://www.sas.com/en_us/certification/credentials/foundation-tools/base-programming-specialist.html#exam-details
SASInstitute A00-231 시험 개요:
| 인증 벤더: | SAS |
| 시험명: | SAS 9.4 Base Programming - 실기 기반 시험 |
| 시험 번호: | A00-231 |
| 지원 언어: | 영어 |
| 시험 형식: | 대화형 (실기 기반), 객관식, 단답형 |
| 시험 시간: | 110분 |
| 관련 자격증: | SAS Certified Specialist: Base Programming Using SAS 9.4 |
| 실제 시험 문항 수: | 40-45 |
| 자격증 유효 기간: | 5년 |
| 합격 점수: | 725 |
| 응시료: | USD 180 |
| 샘플 문제: | SASInstitute A00-231 샘플 문제 |
| 응시 방법: | 온라인 (Pearson VUE OnVUE) 또는 Pearson VUE 시험 센터 |
| 전제 조건: | 공식적인 선수 조건은 없습니다. 응시자는 Base SAS 소프트웨어에 대한 실무 경험이 있어야 합니다. |
| 공식 요강 URL: | https://www.sas.com/en_us/certification.html |