SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 21:

  The following SAS program is submitted:

  data work.pieces;

  do while (n It 6);

  n + 1; end;

  run;

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

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

• Question 22:

  The following SAS program is submitted:

  data work january;

  set work.allmonths (keep = product month num_sold cost); if month = `Jan' then output work.january;

  sales = cost * num_sold; keep product sales;

  run;

  Which variables does the WORK.JANUARY data set contain?

  A. PRODUCT and SALES only
  B. PRODUCT, MONTH, NUM_SOLD and COST only
  C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only
  D. An incomplete output data set is created due to syntax errors.
  D. An incomplete output data set is created due to syntax errors.

• Question 23:

  The following SAS program is submitted:

  data work.test;

  set work.staff (keep = jansales febsales marsales); array diff_sales{3} difsales1 - ditsales3;

  array monthly{3} jansales febsales marsales;

  run;

  Which one of the following represents the new variables that are created?

  A. JANSALES, FEBSALES and MARSALES
  B. MONTHLY1, MONTHLY2 and MONTHLY3
  C. DIFSALES1, DIFSALES2 and DIFSALES3
  D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3
  C. DIFSALES1, DIFSALES2 and DIFSALES3

• Question 24:

  A raw data record is listed below:

  ----I----10---I----20---I----30 1999/10/25

  The following SAS program is submitted:

  data projectduration; infile `file-specification'; input date$ 1- 10; run;

  Which one of the following statements completes the program above and computes the duration of the project in days as of today's date?

  duration = today( ) - put(date,ddmmyy10.); duration = today( ) - put(date,yymmdd10.); duration = today( ) - input(date,ddmmyy10.); duration = today( ) - input(date,yymmdd10.);

• Question 25:

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

  ----I----10---I----20---I----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

• Question 26:

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

  The following SAS program is submitted:

  data work.company; set work.dept1(keep = jobcode) work.dept2(rename (jcode = jobcode)); run;

  Which one of the following is the result?

  A. The variable JCODE is written to the output data set.
  B. The variable JOBCODE is written to the output data set.
  C. Neither variable JOODE nor JOBCODE is written to the output data set.
  D. The program fails to execute due to errors.
  B. The variable JOBCODE is written to the output data set.

• Question 28:

  The following SAS program is submitted:

  proc format

  value score 1 - 50 = `Fail'

  51 - 100 = `Pass';

  run;

  proc report data = work.courses nowd;

  column exam;

  define exam / display format = score.;

  run;

  The variable EXAM has a value of 50.5.

  How will the EXAM variable value be displayed in the REPORT procedure output?

  A. Fail
  B. Pass
  C. 50.5
  D. .(missing numeric value)
  C. 50.5

• Question 29:

  The following SAS program is submitted:

  data work.month; d ate = input('13mar2000',date9.); 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, 9 bytes
  C. character, 8 bytes
  D. character, 9 bytes
  A. numeric, 8 bytes

• Question 30:

  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