SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 121:

  Given the following SAS data set WORK.EMPDATA:

  

  Which WERE statement would display observations wit Job_Title containing the word "Manager"? `))='MANAGER';

  A. where upcase(scan(Job_Title,-1,'
  B. where Job_Title like `Manager%';
  C. where substr(Job_Title, (length(Job_Title)-6))='Manager';
  D. where Job_Title='% Manager `;
  D. where Job_Title='% Manager `;

• Question 122:

  Given the SAS data set WORK.THREE:

  

  The following SAS program is submitted:

  

  What is the result?

  

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

• Question 123:

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

  EAST WEST NORTH SOUTH

  The following program is submitted: libname MYXLS 'regions.xls';

  Which PROC PRINT step correctly displays the NORTH worksheet?

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

• Question 124:

  The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:

  WORK.EMPLOYEE WORK.SALARY fname age name salary Bruce 30 Bruce 25000 Dan 40 Bruce 35000 Dan 25000 The following SAS program is submitted: data work.empdata;

  by fname; totsal + salary; run;

  Which one of the following statements completes the merge of the two data sets by the FNAME variable?

  A. merge work.employee work.salary (fname = name);
  B. merge work.employee work.salary (name = fname);
  C. merge work.employee work.salary (rename = (fname = name));
  D. merge work.employee work.salary (rename = (name = fname));
  D. merge work.employee work.salary (rename = (name = fname));

• Question 125:

  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 126:

  The following SAS program is submitted:

  data work.test;

  Author = 'Agatha Christie';

  First = substr(scan(author,1,' ,'),1,1);

  run;

  Which one of the following is the length of the variable FIRST in the output data set?

  A. 1
  B. 6
  C. 15
  D. 200
  D. 200

• Question 127:

  A raw data file is listed below:

  RANCH,1250,2,1,Sheppard Avenue,"$64,000"

  SPLIT,1190,1,1,Rand Street,"$65,850"

  CONDO,1400,2,1.5,Market Street,"80,050"

  TWOSTORY,1810,4,3,Garris Street,"$107,250"

  RANCH,1500,3,3,Kemble Avenue,"$86,650"

  SPLIT,1615,4,3,West Drive,"94,450"

  SPLIT,1305,3,1.5,Graham Avenue,"$73,650"

  The following SAS program is submitted using the raw data file as input:

  data work.condo_ranch;

  infile 'file-specification' dsd;

  input style $ @;

  if style = 'CONDO' or style = 'RANCH' then

  input sqfeet bedrooms baths street $ price : dollar10.;

  run;

  How many observations does the WORK.CONDO_RANCH data set contain?

  B. 3
  C. 5
  D. 7
  D. 7

• Question 128:

  The following SAS program is submitted:

  

  What new variables are created?

  A. Difcount1, Difcount2 and Difcount3
  B. Diff1, Diff2 and Diff3
  C. Janpt, Febpt, and Marpt
  D. Patients1, Patients2 and Patients3
  A. Difcount1, Difcount2 and Difcount3

• Question 129:

  The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable

  COUNTRYFEE with a format or 7.;

  The following SAS program is submitted:

  data history;

  format local fee country fee percent6.;

  set realestate;

  local fee = local fee / 100; country fee = country fee / 100; run;

  What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

  A. LOCALFEE has format of 9. and COUNTRYFEE has a format of 7.
  B. LOCALFEE has format of 9. and COUNTRYFEE has a format of percent6.
  C. LOCALFEE has format of percent6. and COUNTRYFEE has a format of percent6.
  D. The data step fails execution; there is no format for LOCALFEE
  C. LOCALFEE has format of percent6. and COUNTRYFEE has a format of percent6.

• Question 130:

  The following SAS program is submitted:

  

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

  A. Gender
  B. Department
  C. Gender Department
  D. Department Gender
  A. Gender