SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 131:

  Which one of the following SAS statements correctly computes the average of four numerical values?

  A. average = mean(num1 - num4);
  B. average = mean(of num1 - num4)
  C. average = mean(of num1 to num4);
  D. average = mean(num1 num2 num3 num4);
  B. average = mean(of num1 - num4)

• Question 132:

  The following SAS program is submitted:

  libname rawdata1 `location of SAS data library'; filename rawdata2 `location of raw data file';

  data work.testdata; infile ; input sales 1 sales2; run;

  Which one of the following is needed to complete the program correctly?

  A. rawdata1
  B. rawdata2
  C. `rawdata1'
  D. `rawdata2'
  D. `rawdata2'

• Question 133:

  Which one of the following ODS statement options terminates output being written to an HTML file?

  A. END
  B. QUIT
  C. STOP
  D. CLOSE
  D. CLOSE

• Question 134:

  The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY.

  The following SAS program is submitted:

  proc sort data = work.test out = work.testsorted;

  by name;

  run;

  Which one of the following is the result of the SAS program?

  A. The data set WORKTEST is stored in ascending order by values of the NAME variable.
  B. The data set WORKTEST is stored in descending order by values of the NAME variable.
  C. The data set WORKTESTSORTED is stored in ascending order by values of the NAME variable.
  D. The data set WORKTESTSORTED is stored in descending order by values of the NAME variable.
  C. The data set WORKTESTSORTED is stored in ascending order by values of the NAME variable.

• Question 135:

  The following SAS program is submitted:

  proc means data = sasuser.houses std mean max; var sqfeet run;

  Which one of the following is needed to display the standard deviation with only two decimal places?

  A. Add the option MAXDEC = 2 to the MEANS procedure statement.
  B. Add the statement MAXDEC = 7.2; in the MEANS procedure step.
  C. Add the statement FORMAT STD 7.2; in the MEANS procedure step.
  D. Add the option FORMAT = 7.2 option to the MEANS procedure statement.
  A. Add the option MAXDEC = 2 to the MEANS procedure statement.

• Question 136:

  The contents of the raw data file NAMENUM are listed below: ----I----10---I----20---I----30 Joe xx

  The following SAS program is submitted:

  data test; infile `namenum'; input name $ number; run;

  Which one of the following is the value of the NUMBER variable?

  A. xx
  B. Joe
  C. (missing numeric value)
  D. The value can not be determined as the program fails to execute due to errors.
  C. (missing numeric value)

• Question 137:

  The following SAS program is submitted:

  data work.new;

  length word $7;

  amount = 4;

  if amount = 4 then word = `FOUR';

  else if amount = 7 then word = `SEVEN';

  else word = `NONE!!!';

  amount = 7;

  run;

  Which one of the following represents the values of the AMOUNT and WORD variables?

  A. amount

  word

  7

  FOUR

  B. amount

  word

  7

  FOUR

  C. amount

  word

  4

  FOUR

  D. amount

  word

  4

  " "

  Correct Answer. A
  A

• Question 138:

  The contents of the raw data file PRODUCT are listed below:

  ----I----10---I----20---I----30 24613 $25.31

  The following SAS program is submitted:

  data inventory; infile `product; input idnum 5. @10 price; run;

  Which one of the following is the value of the PRICE variable?

  A. 25.31
  B. $25.31
  C. . (missing numeric value)
  D. No value is stored as the program fails to execute due to errors.
  C. . (missing numeric value)

• Question 139:

  The contents of the raw data file TYPECOLOR are listed below:

  ----|----10----|----20----|----30

  Daisyyellow

  The following SAS program is submitted:

  data flowers; infile typecolor'; input type $ 1-5 +1 color$; run;

  Which one of the following represents the values of the variables TYPE and COLOR?

  A. type color daisy yellow
  B. type color daisy ellow
  C. type color daisyyellow (missing character value)
  D. No values are stored as the program fails to execute fails to execute due to syntax errors.
  D. No values are stored as the program fails to execute fails to execute due to syntax errors.

• Question 140:

  The SAS data set QTR 1_REVENUE is listed below:

  The following SAS program is submitted:

  proc sort data = qtrl_revenue;

  by destination descending revenue;

  run;

  Which one of the following represents the first observation in the output data set?

  destination revenue

  YYZ 53634

  FRA 62129

  FRA 75962

  RDU 76254

  YYZ 82174

  A. destination revenue YYZ 82174
  B. destination revenue YYZ 53634
  C. destination revenue FRA 62129
  D. destination revenue FRA 75962
  D. destination revenue FRA 75962