SAS Institute A00-215 SAS 9.4 Programming Fundamentals Exam Exam Practice Test Questions

• Question 1

  Which statement is true about the DROP statement during the compilation phase of the DATA step?

  • The DROP statement flags the variables in the Program Data Vector to be dropped at output.
  • The DROP statement determines the order of the variables in the Program Data Vector
  • Variables on the DROP statement are removed from the input data set.
  • Variables on the DROP statement are not created in the Program Data Vector

  Show Answer Answer: C Next

• Question 2

  Which statement is true regarding a variable?

  • A character variable can contain alphabetic characters, numeric digits, and other special characters.
  • A numeric value must be specified in single or double quotes.
  • A character value cannot exceed 200 bytes.
  • A numeric variable can contain digits, decimal point, minus sign, currency symbol, and E for scientific notation.

  Show Answer Answer: C Next

• Question 3

  Which statements read the input data set SASHELP. SHOES and create the output data set WORK. TOTAL?

  • Data sashalp.shoes; out work.total;
  • Data sashelp.shoes;
  • Output work.total;
  • Data work.total; set sashelp.shoes;
  • Data out=work.total; input sasholp.shoes

  Show Answer Answer: A Next

• Question 4

  Which SAS format displays a SAS date as 25JUN2019?

  • DdMMMyy9.
  • Date9.
  • Ddmmmyyyy9.
  • Dmy9.

  Show Answer Answer: D Next

• Question 5

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

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

  Show Answer Answer: A Next