SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 201:

  Given the contents of the raw data file TYPECOLOR:

  ----I----10---I----20---I----30

  Daisyyellow

  The following SAS program is submitted:

  data flowers;

  infile `typecolor';

  input type$ 1-5+1 color$;

  run;

  What are the values of the variables TYPE and COLOR?

  A. type color daisygreen
  B. type color daisy ellow
  C. type color daisyyellow" "(missing character value)
  D. No values are stored for the TYPE and COLOR variables.
  B. type color daisy ellow

• Question 202:

  Which one of the following SAS statements renames two variables?

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

• Question 203:

  The following program is submitted:

  proc contents data=_all_;

  run;

  Which statement best describes the output from the submitted program?

  A. The output contains only a list of the SAS data sets that are contained in the WORK library.
  B. The output displays only the contents of the SAS data sets that are contained in the WORK library.
  C. The output displays only the variables in the SAS data sets that are contained in the WORK library.
  D. The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.
  D. The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.

• Question 204:

  The following SAS program is submitted:

  

  What will the data set WORK.TEST contain?

  

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

• Question 205:

  Which program will create a comma delimited raw data file (CSV)?

  

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

• Question 206:

  Consider the following data step:

  data WORK.NEW;

  set WORK.OLD;

  Count+1;

  run;

  The varaible Count is created using a sum statement. Which statement regarding this variable is true?

  A. It is assigned a value 0 when the data step begins execution.
  B. It is assigned a value of missing when the data step begins execution.
  C. It is assigned a value 0 at compile time.
  D. It is assigned a value of missing at compile time.
  C. It is assigned a value 0 at compile time.

• Question 207:

  Which statement correctly computes the average of four numerical values?

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

• Question 208:

  Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?

  A. infile 'customer.txt' 1-10;
  B. input 'customer.txt' stop@10;
  C. infile 'customer.txt' obs=10;
  D. input 'customer.txt' stop=10;
  C. infile 'customer.txt' obs=10;

• Question 209:

  This question will ask you to provide a line of missing code. Given the following data set WORK.SALES:

  

  The following program is submitted:

  

  Which statement should be inserted to produce the following output?

  

  A. Qtr1 = sum(of month {*});
  B. Qtr1 = sum(of month {3});
  C. Qtr1 = month{1} + month{2} + month {3};
  D. Qtr1 = sum(of month{_ALL_});
  A. Qtr1 = sum(of month {*});

• Question 210:

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

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

  Janice 10

  Henri 11

  Michael 11

  Susan 12

  The following SAS program is submitted:

  data group;

  infile 'team';

  input name $15. age 2.;

  file 'file-specification';

  put name $15. +5 age 2.;

  run;

  Which one of the following describes the output created?

  A. a raw data file only
  B. a SAS data set named GROUP only
  C. a SAS data set named GROUP and a raw data file
  D. No output is generated as the program fails to execute due to errors.
  C. a SAS data set named GROUP and a raw data file