SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 261:

  Which program displays a listing of all data sets in the SASUSER library?

  A. proc contents lib = sasuser.all; run;

  B. proc contents data = sasuser.all; run;

  C. proc contents lib = sasuser._alI_; run;

  D. proc contents data = sasuser._all_; run;

  Correct Answer: D

• Question 262:

  The following SAS program is submitted:

  proc sort data = work.employee;

  by descending fname;

  proc sort data = work.salary;

  by descending fname;

  data work.empdata;

  merge work.employee

  work.salary;

  by fname;

  run;

  Why does the program rail to execute?

  A. The SORT procedures contain invalid syntax.

  B. The merged data sets are not permanent SAS data sets.

  C. The RUN statement was omitted alter each or the SORT procedures.

  D. The data sets were not merged in the order by which they were sorted.

  Correct Answer: D

• Question 263:

  The following SAS program is submittad:

  data work.sales;

  do year = 1 to 5;

  do month=1 to 12;

  x+1;

  output

  end;

  end;

  run;

  How many observations are written the WORK SALES data set?

  A. 0

  B. 1

  C. 5

  D. 60

  Correct Answer: D

• Question 264:

  Given the following raw data record:

  ----I----10---I----20---I----30 son Travis, The following output is desired: Obs relation firstname 1 son Travis

  Which SAS program correctly reads in the raw data?

  A. data family ( dIm = `,'); infile `tile specification'; input relation $ firstname $; run;

  B. options dIm = `,'; data family; infile `file specification'; input relation $ firstname $; run;

  C. data family; infile `file specification' dIm = `,'; input relation $ firstname $; run;

  D. data family; infile `file specification'; input relation $ firstname $ / dim = `,'; run;

  Correct Answer: C

• Question 265:

  Given the SAS data set AGES:

  AGES AGE

  The variable AGE contains character values. The following SAS program is submitted:

  data subset;

  set ages;

  where age> 12;

  run;

  How many observations are written out to the data set SUBSET?

  A. 0

  B. 1

  C. 2

  D. 3

  Correct Answer: A

• Question 266:

  Given the SAS data set PRICES:

  PRICES

  prodid price

  K12S 5.10 producttype

  NETWORK sales

  15 returns

  B132S 2.34 HARDWARE 300 10

  R18KY21.29 SOFTWARE 25 5

  3KL8BY 6.37 HARDWARE 125 15

  DY65DW 5.60 HARDWARE 45 5

  DGTY23 4.55 HARDWARE 67 2

  The following SAS program is submitted:

  data hware inter soft;

  set prices (keep = producttype price);

  if price le 5.00;

  if producttype = `HARDWARE' then output HWARE;

  else if producttype = `NETWORK' then output INTER;

  else if producttype = `SOFTWARE' then output SOFT;

  run;

  How many observations does the HWARE data set contain?

  A. 0

  B. 2

  C. 3

  D. 4

  Correct Answer: B

• Question 267:

  The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price". Which SAS program temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?

  A. proc print data = sasuser.houses; label price = "Sale Price"; run;

  B. proc print data = sasuser.houses label; label price "Sale Price"; run;

  C. proc print data = sasuser.houses label; label price = "Sale Price"; run;

  D. proc print data = sasuser.houses; price = "Sale Price"; run;

  Correct Answer: C

• Question 268:

  The following SAS program is submitted:

  data work.empsalary;

  set work.people (in = inemp)

  work.money (in = insal);

  if insal and inemp;

  run;

  The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7

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

  A. 0

  B. 5

  C. 7

  D. 12

  Correct Answer: A

• Question 269:

  The following SAS program is submitted:

  data work.accounting;

  set work.dept1 work.dept2;

  jobcode = `FA1';

  length jobcode $ 8;

  run;

  A character variable named JOBCODE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS

  data sets. The variable JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the

  WORK.DEPT2 data set.

  What is the length of the variable JOBCODE in the output data set?

  A. 3

  B. 5

  C. 7

  D. 8

  Correct Answer: B

• Question 270:

  Given the SAS data set SASDATA TWO:

  SASDATA TWO X Y

  5 2

  3 1

  5 6

  The following SAS program is submitted:

  data sasuser.one two sasdata.three;

  set sasdata two;

  if x = 5 then output sasuser.one;

  else output sasdata two;

  run;

  What is the result?

  A. data set SASUSER.ONE has 5 observations data set SASUSER.TWO has 5 observations data set WORK.OTHER has 3 observations

  B. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 1 observations

  C. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 5 observations

  D. No data sets are output. The DATA step fails execution due to syntax errors.

  Correct Answer: D