Valid A00-231 Dumps shared by ExamDiscuss.com for Helping Passing A00-231 Exam! ExamDiscuss.com now offer the newest A00-231 exam dumps, the ExamDiscuss.com A00-231 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com A00-231 dumps with Test Engine here:
Scenario: This project will use data set cert.input27. At any time, you may save your program as program27 in cert\programs. You will use this program in the next project. Write a SAS program that will: * Create output data set results.output27a as a subset of cert.input27 where the country variable's value is "US" (any variation of case, such as US or us). * Sort results.output27a: " first by the variable state in ascending order " then by Postal_Code in descending order " and finally by employee_ID in ascending order. Run the program and use the results to answer the question below. What is the value of Employee_ID for observation 100 in results.output27a?
Correct Answer:
120781 Explanation: proc sort data=cert.input27 out=results.output27a(where=(upcase (country)='US')); by state descending Postal_Code employee_ID; run; proc print data=results.output27a (firstobs=100 obs=100); var employee_ID; run: