SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 91:

  The following SASS program is submitted:

  data work.sales;

  do year = 1 to 5;

  do month = 1 to 12;

  x+ 1;

  end;

  run;

  Which one of the following represents how many observations are written to the WORK SALES data set?

  B. 1
  C. 5
  D. 60
  B. 1

• Question 92:

  On which portion(s) of a SAS data set does the PRINT procedure report?

  A. the data portion only
  B. the descriptor portion only
  C. the descriptor portion and the data portion
  D. neither the data portion nor the descriptor portion
  A. the data portion only

• Question 93:

  The following SAS program is submitted:

  Iibname sasdata `SAS-data-library';

  data test;

  set sasdata.chemists;

  if jobcode = `Chem2'

  then description = `Senior Chemist';

  else description = `Unknown';

  run;

  A value for the variable JOBCODE is listed below:

  JOSCODE

  chem2

  Which one of the following values does the variable DESCRIPTION contain?

  A. Chem2
  B. Unknown
  C. Senior Chemist
  D. ` ` (missing character value)
  B. Unknown

• Question 94:

  A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000. Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?

  A. proc print data = sasuser.houses; where price It 60000; where price gt 100000; run;
  B. proc print data = sasuser.houses; where price It 60000 or price gt 100000; run;
  C. proc print data = sasuser.houses; where price It 60000 and price gt 100000; run;
  D. proc print data = sasuser.houses; where price It 60000 or where price gt 100000; run;
  C. proc print data = sasuser.houses; where price It 60000 and price gt 100000; run;

• Question 95:

  The value 110700 is stored in a numeric variable.

  Which one of the following SAS formats is used to display the value as $110,700.00 in a report?

  A. comma8.2
  B. comma11.2
  C. dollar8.2
  D. dollar11.2
  D. dollar11.2

• Question 96:

  Which one of the following SAS system options prevents the page number from appearing on a report?

  A. NONUM
  B. NOPAGE
  C. NONUMBER
  D. NOPAGENUM
  C. NONUMBER

• Question 97:

  The following SAS program is submitted:

  data stats;

  set revenue;

  array weekly{5} mon tue wed thu fri;

  total = weekly{i} * .25;

  output;

  end;

  run;

  Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?

  do I = 1 to 5;

  do weekly{i) = 1 to 5;

  do i = mon tue wed thu fri;

  A DO loop cannot be used because the variables referenced do not end in a digit.

  A. do I = 1 to 5;
  B. do weekly{i) = 1 to 5;
  C. do i = mon tue wed thu fri;
  D. A DO loop cannot be used because the variables referenced do not end in a digit.
  A. do I = 1 to 5;

• Question 98:

  Which one of the following SAS statements renames two variables?

  A. set work.dept1 work.dept2(rename = Ucode =jobcode) (sal salary));
  B. set work.dept1 workdept2(rename = Ucode =jobcode sal = salary));
  C. set work.dept1 work.dept2(rename =jcode =jobcode sal = salary);
  D. set work.dept1 work.dept2(rename = Ucode jobcode) (sal salary));
  B. set work.dept1 workdept2(rename = Ucode =jobcode sal = salary));

• Question 99:

  The following SAS program is submitted:

  data work.clients;

  calls = 6;

  do while (calls le 6);

  calls + 1;

  end;

  run;

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

  A. 4
  B. 5
  C. 6
  D. 7
  D. 7

• Question 100:

  The SAS data set BANKS is listed below:

  BANKS

  name rate

  FirstCapital 0.0718

  DirectBank 0.0721

  VirtualDirect 0.0728

  The following SAS program is submitted:

  data newbank;

  do year = 1 to 3;

  set banks;

  capital + 5000;

  end;

  run;

  Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?

  A. 0 observations and 0 variables
  B. 1 observations and 4 variables
  C. 3 observations and 3 variables
  D. 9 observations and 2 variables
  B. 1 observations and 4 variables