SAS Institute A00-215 Online Practice Questions and Exam Preparation

SAS Institute A00-215 Online Questions & Answers

• Question 31:

  Given the following SAS program:

  

  What footnotes appear for the second PROC PRINY report?

  A. Created by HR
  B. Created by HR
  C. Draft - Do Not Distribute Create by HR
  D. Draft - Do NOT Distribute
  A. Created by HR

• Question 32:

  You submit a program and the SAS log is shown below:

  

  Which statement is true regarding the submitted program?

  A. The error in the PROC SORT step caused the program to stop processing
  B. All three steps ran successfully
  C. The DATA step and PROC PRINT steps ran without errors.
  D. The PROC SORT and PROC PRINT steps failed.
  A. The error in the PROC SORT step caused the program to stop processing

• Question 33:

  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 XLS extensions
  D. The XLSX extension in the Microsoft Excel workbook name is optional in the LIBNAME statement
  A. The individual worksheets are automatically concatenated when reading a Microsoft Excel workbook.

• Question 34:

  Which line contains a syntax error?

  

  A. Line 3
  B. Line 1
  C. Line 2
  D. Line 5
  B. Line 1

• Question 35:

  Which PROC MEANS program creates the report below?

  

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

• Question 36:

  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 character
  A. a period for missing numeric and a blank for missing character

• Question 37:

  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.shoes
  A. data sashalp.shoes; out work.total;

• Question 38:

  Given the program below: Why does the program fail?

  

  A. You must use two different DATA statements for HEIGHT1 and HEIGHT2
  B. You cannot output to different data sets
  C. You must include the data set height2 in the DATA statement
  D. You cannot use numbers in data set names.
  A. You must use two different DATA statements for HEIGHT1 and HEIGHT2

• Question 39:

  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, minus sign, currency symbol, and E for scientific notation.
  C. A character value cannot exceed 200 bytes.

• Question 40:

  Which PROC SORT option allows you to create an output data set of the sorted data?

  A. Data=
  B. SORTOUT=
  C. OUTPUT=
  D. OUT=
  A. Data=