Free A00-215 Exam Braindumps (page: 2)

Page 1 of 16

Which statement is true regarding the XLSX engine in the LIBNAME statement?

  1. The individual worksheets are automatically concatenated when reading a Microsoft Excel workbook.
  2. The XLSX engine can road and write data in Microsoft Excel workbooks.
  3. The XLSX engine can road Microsoft workbooks with both XLSX and XLS extensions
  4. The XLSX extension in the Microsoft Excel workbook name is optional in the LIBNAME statement

Answer(s): A



Which ODS EXCEL statement correctly creates an Excel using the ANALYSIS style?

  1. Ods excel=' c : \report. xlsx' style=analysis;
  2. Ods excel workbook=' report. xles' analysis;
  3. Ods excel=' c : \report. xlsx' / analysis;
  4. Ods excel file ='c \report.xlsx' styleanalysis;

Answer(s): C



Which PROC IMPORT step correctly creates the MYDATA,SALES data set from the SALES.SCV file?

  1. proc import data="mydata. sales" dbms=csv out="mydata.sales;
    nun
  2. proc import datafile="sales.csv" dbms=csv out-mydata. sales;
  3. proc import data=mydata.sales dbms=csv out=mydata.gales; run,-
  4. proc import datafile=sales.csv dbms=csv out--"mydata,sales";
    run;

Answer(s): D



Which PROC MEANS program creates the report below?

  1. proc means data-sashelp. shoes sum mean;
    var Sales;
    Class Product;
    run;
  2. proc means data=sashelp. 'shoes var Sale;
    group Product;
    run/
  3. Pror moans data-uashelp . shoes sum mean nobe;
    by sales;
    class product
  4. proc means data-esea= ashelp. shoes.
    sum Salad;
    mean Sales;
    by product;
    run."

Answer(s): A






Post your Comments and Discuss SAS Institute A00-215 exam with other Community members:

A00-215 Discussions & Posts