SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 1:

  The contents of the SAS data set named PEPM.STUDENTS are listed below:

  name age Alfred 14 Alice 13 Barbaba 13 Carol 14

  The following SAS program is submitted using the PERM STUDENTS data set as input libname perm `SAS-data-library'; data students; set perm.students; file `file-specification'; put name $15. @5 age 2.; run;

  Which one of the following represents the values written to the output raw data file?

  A. ----I----10---I----20---I----30 Alfred 14 Alice 13 Barbara 13 Carol 14
  B. ----I----10---I----20---I----30 AIfr14 Alicl3 Barb 13a Carol 4
  C. ----I----10---I----20---I----30 Alfr14ed Alicl3e Barb l3ara Carol4l
  D. ----I----10---I----20---I----30----I----10---I----20---I----30 Alfred 14 Alice 13 Barbara 13 Carol 14
  B. ----I----10---I----20---I----30 AIfr14 Alicl3 Barb 13a Carol 4

• Question 2:

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

  ----I----10---I----20---I----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 yellow
  C. type color daisy yellow (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 3:

  A SAS PRINT procedure output of the WORKLEVLLS data set is listed below:

  Obs name level

  1 Frank 1

  2 Joan 2

  3 Sui 2

  4 Jose 3

  5 Burt 4

  6 Kelly .

  7 Juan 1

  The following SAS program is submitted:

  data work.expertise;

  set work.levels;

  if level = then

  expertise `Unknown';

  else if level = 1 then

  expertise = `Low';

  else if level = 2 or 3 then

  expertise = `Medium';

  else

  expertise = `High';

  run;

  Which of the following values does the variable EXPERTISE contain?

  A. Low, Medium, and High only
  B. Low, Medium, and Unknown only
  C. Low, Medium, High, and Unknown only
  D. Low, Medium, High, Unknown, and ``(missing character value)
  B. Low, Medium, and Unknown only

• Question 4:

  Which one of the following is true of the SUM statement in a SAS DATA step program?

  A. It is only valid in conjunction with a SUM function.
  B. It is not valid with the SET, MERGE and UPDATE statements.
  C. It adds the value of an expression to an accumulator variable and ignores missing values.
  D. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.
  C. It adds the value of an expression to an accumulator variable and ignores missing values.

• Question 5:

  Which one or the following SAS system options displays the time on a report?

  A. TIME
  B. DATE
  C. TODAY
  D. DATETIME
  B. DATE

• Question 6:

  The following SAS DATA step is submitted:

  libname temp `SAS-data-library';

  data temp.report;

  set sasuser.houses;

  newvar = price * 1.04;

  run;

  Which one of the following statements is true regarding the program above?

  A. The program is reading from a temporary data set and writing to a temporary data set.
  B. The program is reading from a temporary data set and writing to a permanent data set.
  C. The program is reading from a permanent data set and writing to a temporary data set.
  D. The program is reading from a permanent data set and writing to a permanent data set.
  D. The program is reading from a permanent data set and writing to a permanent data set.

• Question 7:

  The following SAS program is submitted:

  proc sort data = sasuser.houses out = houses;

  by style;

  run;

  proc print data = houses;

  run;

  Click on the Exhibit button to view the report produced.

  

  Which of the following SAS statement(s) create(s) the report?

  A. id style;
  B. id style; var style bedrooms baths price;
  C. id style; by style; var bedrooms baths price;
  D. id style; by style; var style bedrooms baths price;
  C. id style; by style; var bedrooms baths price;

• Question 8:

  The following SAS program is submitted:

  libname sasdata `SAS-data-library';

  data test;

  set sasdata.chemists (keep = job_code);

  if job_code `chem3'

  then description = `Senior Chemist';

  run;

  The variable JOB_CODE is a character variable with a length of 6 bytes.

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

  A. 6 bytes
  B. 8 bytes
  C. 14bytes
  D. 200 bytes
  C. 14bytes

• Question 9:

  The following SAS program is submitted:

  proc means data = sasuser.shoes;

  where product in (`Sandal' , `Slipper' , `Boot');

  run;

  Which one of the following ODS statements completes the program and sends the report to an HTML file?

  A. ods html = `sales.html';
  B. ods file = `sales.html';
  C. ods file html = `sales.html';
  D. ods html file = `sales.html';
  D. ods html file = `sales.html';

• Question 10:

  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 sales1 sales2; run;

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

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