SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 1:

  The following SAS program is submitted:

  data WORK.PRODUCTS;

  Prod=1;

  do while (Prod LE 7);

  Prod + 1;

  end;

  run;

  What is the value of the variable Prod in the output data set?

  A. 7
  B. 8
  C. 6
  D. .(missing numeric)
  B. 8

• Question 2:

  The following SAS program is submitted:

  Data WORK.COMPRESS; ID = `1968 05-10 567'; NewID = compress (ID, "-"); run;

  What will the value of NewID be in the WORK.COMPRESS data set?

  A. 1968 05-10 567
  B. 19680510567
  C. 196805-10567
  D. 1968 0510 567
  A. 1968 05-10 567

• Question 3:

  This questions will ask you to provide two missing variable names.

  The following SAS program is submitted:

  data WORK.TOTAL;

  set WORK.SALARY;

  by Department Gender;

  if First. then Payroll=0

  Payroll+Wagerate;

  if Last.;

  run;

  The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?

  variable 2: Department

  A. variable 1: Gender
  B. variable 1: Gender variable 2: Gender
  C. variable 1: Department variable 2: Gender variable 2: Department
  D. variable 1: Department
  B. variable 1: Gender variable 2: Gender

• Question 4:

  Given the SAS data set WORK.TEMPS with numeric variables Day and Temp and character variable Month:

  

  The following SAS program is submitted:

  proc sort data=WORK.TEMPS; by Day descending Month; run;

  proc print data=WORK.TEMPS; run;

  Which output is correct?

  

  A. B.
  C. D.
  B

• Question 5:

  Given the following data set WORK.TOYS:

  

  The following SAS program s submitted:

  data WORK.GROUPS;

  set WORK.TOYS;

  if Product="Cards" then Group_Desc="Indoors";

  else if Product in ("Drum", "Recorder") then Group_Desc="Instruments";

  else if Product="Ball" then Group_Desc="Outdoors";

  run;

  proc print data=WORK.GROUPS noobs;

  run;

  Which output is produced?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C

• Question 6:

  The Excel workbook REGIONS.XLSX contains the following four worksheets:

  EAST WEST NORTH SOUTH

  The following program is submitted:

  libname MYXLS XLSX `c:\ data\ regions.xlsx';

  Which PROC PRINT step correctly displays the NORTH worksheet?

  A. proc print data=MYXLS.`NORTH'e; run;
  B. proc print data=MYXLS.NORTH.XLSX; run;
  C. proc print data=MYXLS.NORTH; run;
  D. proc print data=MYXLS.`NORTH$'n; run;
  D. proc print data=MYXLS.`NORTH$'n; run;

• Question 7:

  A SAS programmer assigns a library reference to an existing Excel workbook named exceldata.xlsx. Using a DATA step, the programmer attempts to create a worksheet named outdata in this Excel workbook. However, the Excel workbook already contains a worksheet named outdata.

  What will happen?

  A. A second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet outdata.
  B. A second worksheet outdata(2) will be added to the existing exceldata.xlsx workbook.
  C. The program will overwrite the outdata worksheet in the exceldata.xlsx workbook.
  D. The program will produce an error message indicating that the exceldata.xlsx workbook already exists.
  A. A second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet outdata.

• Question 8:

  When SAS encounters a data when reading from a raw data file, which action will occur?

  A. SAS will write an ERROR message to the SAS log and suspend execution.
  B. SAS will write a WARNING message to the SAS log and suspend execution.
  C. SAS will write a NOTE to the SAS log and continue execution.
  D. SAS will print NOTES to the SAS log until the limit that is set by ERRORS = option is reached, then execution will stop.
  D. SAS will print NOTES to the SAS log until the limit that is set by ERRORS = option is reached, then execution will stop.

• Question 9:

  The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

  

  The following SAS program is submitted:

  proc print data=WORK.ONE; where Num=contains (1); run;

  Which output is generated?

  

  A. B. C.
  D. No output is generated
  D. No output is generated

• Question 10:

  Given the SAS data set WORK. PRODUCTS:

  

  The following SAS program is submitted:

  data WORK. REVENUE (drop=Sales Returns);

  set WORK. PRODUCTS (keep=ProdId Price Sales Returns);

  Revenue-Price* (Sales-Returns);

  run;

  How many variables does the WORK.REVENUE data set contain?

  A. 5
  B. 2
  C. 4
  D. 3
  A. 5