SASInstitute SAS Institute Systems Certification A00-201 Questions & Answers

• Question 121:

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

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

  chair,,table

  chair,couch,table

  The following SAS program is submitted:

  data stock;

  infile `furniture' dsd;

  input item 1 $ item2 $ item3 $;

  run;

  Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?

  A. table

  B. table

  C. (missing numeric value)

  D. ``(missing character value)

  Correct Answer: D

• Question 122:

  The contents of two SAS data sets named EMPLOYEE and SALARY are listed below.

  EMPLOYEE SALARY

  name age name salary

  Bruce 30 Bruce 40000

  Dan 35 Bruce 35000

  Dan 37000

  Dan

  The following SAS program is submitted:

  data work.empsalary

  merge work.employee (in = inemp)

  work.salary (in = insal);

  by name;

  if inemp and insal;

  run;

  How many observations will the data set WORK.EMPSALARY contain?

  A. 2

  B. 4

  C. 5

  D. 6

  Correct Answer: B

• Question 123:

  A raw data record is listed below:

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

  Printing 750

  The following SAS program is submitted:

  data bonus;

  infile `file-specification';

  input dept $ 1-11 number 13-15;

  run;

  Which one of the following SAS statements completes the program and results in a value of `Printing 750' for the DEPARTMENT variable?

  A. department = trim(dept) II number;

  B. department = dept II input(number,3.);

  C. department = trim(dept) II put(number,3.);

  D. department = input(dept,11.) II input(number,3.);

  Correct Answer: C

• Question 124:

  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.

  Correct Answer: D

• Question 125:

  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'

  Correct Answer: B

• Question 126:

  The following SAS SORT procedure step generates an output data set:

  proc sort data = sasuser.houses out = report; by style; run;

  In which library is the output data set stored?

  A. WORK

  B. REPORT

  C. HOUSES

  D. SASUSER

  Correct Answer: A

• Question 127:

  A raw data record is shown below:

  07Jan2002

  Which one of the following in formats would read this value and store it as a SAS date value?

  A. date9.

  B. dmonyy9.

  C. ddMMMyy9.

  D. ddmmmyyyy9.

  Correct Answer: A

• Question 128:

  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)

  Correct Answer: A

• Question 129:

  The SAS data set named WORK.TEST is listed below:

  capacity airplanetype staff 150 Large 10

  Which one of the following SAS programs created this data set?

  A. data work.test capacity = 150; 1100 le capacity le 200 then airplanetype = `Large' and staff = 10; else airplanetype = `Small' and staff = 5; run;

  B. data work.test; capacity = 150; if 100 le capacity le 200 then do; airplanetype = `Large'; staff= 10; end; else do; airplanetype = `Small'; staff = 5; end; run;

  C. data work.test; capacity = 150; if 100 le capacity le 200 then do; airplanetype = `Large'; staff = 10; else do; airplanetype = `Small'; airplanetype = `Small'; staff = 5; end; run;

  D. data work.test;D.data work.test; capacity = 150; if 100 le capacity le 200 then; airplanetype = `Small'; airplanetype = `Small'; staff = 5; else; airplanetype = `Large'; airplanetype = `Large'; staff = 10; run;

  Correct Answer: B

• Question 130:

  Click the Exhibit button to view a listing of the SASUSER.HOUSES data set.

  style price

  CONDO $79,700

  RANCH $68,575

  SPLIT $77,983

  TWOSTORY $62,550

  The following SAS program is submitted:

  proc report data = sasuser.houses nowd headline;

  column style price;

  where price It 100000;

  define price / mean width = 9;

  title;

  run;

  The following output is created by the REPORT procedure:

  

  Which one of the following DEFINE statements completes the above program and produces the above output?

  A. define style / order width = 9;

  B. define style / group width = 9;

  C. define style / across width = 9;

  D. define style / display width = 9;

  Correct Answer: B