SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 221:

  The following SAS program is submitted:

  proc print data = sasuser.houses; run;

  proc means data = sasuser.shoes; run;

  Which one of the following OPTIONS statements resets the page number to 1 for the second report?

  A. options pageno = 1;
  B. options pagenum = 1;
  C. options reset pageno = 1;
  D. options reset pagenum = 1;
  A. options pageno = 1;

• Question 222:

  The following SAS program is submitted:

  data WORK.ACCOUNTING;

  set WORK.DEPARTMENT;

  length EmpId $6;

  CharEmpid=EmpId;

  run;

  If data set WORK.DEPARTMENT has a numeric variable EmpId. Which statement is true about the output dataset?

  A. The type of the variable CharEmpid is numeric.
  B. The type of the variable CharEmpid is unknown.
  C. The type of the variable CharEmpid is character.
  D. The program fails to execute due to errors.
  D. The program fails to execute due to errors.

• Question 223:

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

  

  The following SAS program is submitted:

  

  What is output?

  

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

• Question 224:

  Given the SAS data set PRICES:

  PRICES

  prodid price

  K12S 5.10 producttype

  NETWORK sales

  15 returns

  B132S 2.34 HARDWARE 300 10

  R18KY21.29 SOFTWARE 25 5

  3KL8BY 6.37 HARDWARE 125 15

  DY65DW 5.60 HARDWARE 45 5

  DGTY23 4.55 HARDWARE 67 2

  The following SAS program is submitted:

  data hware inter soft;

  set prices (keep = producttype price);

  if price le 5.00;

  if producttype = `HARDWARE' then output HWARE;

  else if producttype = `NETWORK' then output INTER;

  else if producttype = `SOFTWARE' then output SOFT;

  run;

  How many observations does the HWARE data set contain?

  B. 2
  C. 3
  D. 4
  B. 2

• Question 225:

  The following SAS program is submitted:

  data work.test;

  First = 'Ipswich, England';

  City = substr(First,1,7);

  City_Country = City!!', '!!'England';

  run;

  Which one of the following is the value of the variable CITY_COUNTRY in the output data set?

  A. Ipswich!!
  B. Ipswich, England
  C. Ipswich, 'England'
  D. Ipswic h, England
  B. Ipswich, England

• Question 226:

  FILL BLANK

  Given the SAS data set WORK.EMP_NAME:

  

  Given the SAS data set WORK.EMP_DEPT:

  

  The following program is submitted:

  

  How many observations are in data set WORK.ALL after submitting the program?

  A. 2
  A. 2

• Question 227:

  The following SAS program is submitted:

  data work.month; date = put('13mar2000'd,ddmmyy10.); run;

  Which one of the following represents the type and length of the variable DATE in the output data set?

  A. numeric, 8 bytes
  B. numeric, 10 bytes
  C. character, 8 bytes
  D. character, 10 bytes
  D. character, 10 bytes

• Question 228:

  Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?

  A. MSOFFICE2K
  B. EXCELXP
  C. CSVALL
  D. WINXP
  D. WINXP

• Question 229:

  Which one of the following SAS procedures displays the data portion of a SAS data set?

  A. PRINT
  B. FSLIST
  C. CONTENTS
  D. DATASETS
  A. PRINT

• Question 230:

  The following SAS program is submitted:

  data work.staff;

  JobCategory = 'FA';

  JobLevel = '1';

  JobCategory = JobCategory || JobLevel;

  run;

  Which one of the following is the value of the variable JOBCATEGORY in the output data set?

  A. FA
  B. FA1
  C. FA 1
  D. ' ' (missing character value)
  A. FA