A00-215 V1

Which statement is true regarding the XLSX engine in the LIBNAME statement?A . The individual worksheets are automatically concatenated when reading a Microsoft Excel workbook. B. The XLSX engine can road and write data in Microsoft Excel workbooks. C. The XLSX engine can road Microsoft workbooks with both XLSX and...

Which statements read the input data set SASHELP. SHOES and create the output data set WORK. TOTAL?A . data sashalp.shoes; out work.total; B. data sashelp.shoes; output work.total; C. data work.total; set sashelp.shoes; D. data out=work.total; input sasholp.shoesView AnswerAnswer: C

The SAS log of a submitted DATA step is shown below: Which action resolve the error messages?A . Remove the period after the value of Inc. B. Enclose the value of ABC Inc. in quotation marks. C. Add a LENGTH statement to declare the company variable as character D. Enclose...

Which statement is true regarding a variable?A . A character variable can contain alphabetic characters, numeric digits, and other special characters. B. A numeric value must be specified in single or double quotes. C. A character value cannot exceed 200 bytes. D. A numeric variable can contain digits, decimal point,...

Which PROC SORT option allows you to create an output data set of the sorted data?A . Data= B. SORTOUT= C. OUTPUT= D. OUT=View AnswerAnswer: D

The following program is summited: The following report is created: However, the desired report is shown below: What change is needed to display the desired formatted values for the Answer varia?A . Change the unformatted values on the VALUE statement to upper case letters B. Remove the comma located on...

What type of error does NOT produce the expected results and does NOT generate errors or warnings in the log?A . Syntax error B. Logic error C. Special error D. Data errorView AnswerAnswer: B

Given the report shown below: Which PROC PREQ step creates the frequency report?A . proc freq data= cars; tables make drivetrain; run; B. proc freq data= cars; tables make *drivetrain; run; C. proc freq data- cars; tables drivetrain make; run; D. proc freq data- cars; tables drivetrain* make; run;View AnswerAnswer:...

CORRECT TEXT Given the following DATA step: What is the value of average? Enter your numeric answer in the space above.View AnswerAnswer: 3

How does SAS display missing values?A . a period for missing numeric and a blank for missing character B. an N for missing numeric and C for missing character C. a blank for Doth numeric and character missing D. a blank for missing numeric and a $ for missing characterView...