SAS Base Programming (A00-231) Certification Exam | Sample Question

1. How to Prepare for SAS Base Programming A00-231 Certification? A00-231 Certification Made Easy with AnalyticsExam.com.

2. SAS A00-231 Exam Summary: SAS Certified Specialist - Base Programming Using SAS 9.4 Exam Name A00-231 Exam Code 40-45 No. of Questions 725 / 1000 Passing Score 125 minutes Time Limit $180 (USD) Exam Fees SAS Base Programming Certification Practice Exam Online Practice Test SAS Base Programming Certification Sample Question Sample Questions Rise & Shine with AnalyticsExam.com

3. SAS Base Programming Syllabus Content: Syllabus Topics: Access and Create Data Structures Manage Data Error Handling Generate Reports and Output Rise & Shine with AnalyticsExam.com

4. SAS Base Programming Training: Recommended Training: SAS Programming 1: Essentials SAS Programming 2: Data Manipulation Techniques Rise & Shine with AnalyticsExam.com

5. Tips to Prepare for A00-231 ● Understand the all Syllabus Topics. ● Perform SAS Base Programming online test at AnalyticsExam.com. ● Identify your weak areas from SAS Base Programming mock test and asses yourself frequently. Rise & Shine with AnalyticsExam.com

6. SAS A00-231 Sample Questions Rise & Shine with AnalyticsExam.com

7. Que.: 1: Given the SAS data set WORK.INPUT: Var1 Var2 ------ ------- A one A two B three C four A five The following SAS program is submitted: data WORK.ONE WORK.TWO; set WORK.INPUT; if Var1='A' then output WORK.ONE; output; run; How many observations will be in data set WORK.ONE? Enter your numeric answer in the space below. [.......] Solution: 8 Determine whether the given solution is correct? Options: a) Incorrect b) Correct Rise & Shine with AnalyticsExam.com

8. Answer: b) Correct Rise & Shine with AnalyticsExam.com

9. Que.: 2 Given the SAS data set WORK.ONE: Revenue2008 Revenue2009 Revenue2010 ----------- ----------- 1.2 1.6 2.0 The following SAS program is submitted: data WORK.TWO; set WORK.ONE; Total=sum(of Rev:); run; What value will SAS assign to Total? Options: a) 3 ----------- b) 1.6 c) The program fails to execute due to errors. d) 4.8 Rise & Shine with AnalyticsExam.com

10. Answer: d) 4.8 Rise & Shine with AnalyticsExam.com

11. Que.: 3 This project will use the data set sashelp.shoes. Write a SAS program that will: Read sashelp.shoes as input. Create a new SAS data set, work.shoerange. Create a new character variableSalesRange that will be used to categorize the observations into three groups. Set the value of SalesRange to the following: - Lower when Sales are less than $100,000. - Middle when Sales are between $100,000 and $200,000, inclusively. - Upper when Sales are above $200,000. Run the program, then use additional SAS procedures to answer the following questions: How many observations are classified into the “Lower” group? Solution: 288 Determine whether the given solution is correct? Options: a) Correct b) Incorrect Rise & Shine with AnalyticsExam.com

12. Answer: a) Correct Rise & Shine with AnalyticsExam.com

13. Que.: 4 The following SAS program is submitted: data WORK.TEMP; Char1='0123456789'; Char2=substr(Char1,3,4); run; What is the value of Char2? Options: a) 23 b) 34 c) 345 d) 2345 Rise & Shine with AnalyticsExam.com

14. Answer: d) 2345 Rise & Shine with AnalyticsExam.com

15. Que.: 5 This project will use data set sashelp.shoes. Write a SAS program that will: Read sashelp.shoes as input. Create the SAS data set work.sortedshoes. Sort the sashelp.shoes data set: First by variable product in descending order. Second by variable sales in ascending order. Run the program and answer the following questions: What is the value of the product variable in observation 148? Solution: Slipper Determine whether the given solution is correct? Options: a) Correct b) Incorrect Rise & Shine with AnalyticsExam.com

16. Answer: a) Correct Rise & Shine with AnalyticsExam.com

17. Follow Us on: Rise & Shine with AnalyticsExam.com