SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 81:

  A raw data file is listed below:

  RANCH,1250,2,1,Sheppard Avenue,"$64,000" SPLIT,1190,1,1,Rand Street,"$65,850" CONDO,1400,2,1.5,Market Street,"80,050" TWOSTORY,1810,4,3,Garris Street,"$107,250" RANCH,1500,3,3,Kemble Avenue,"$86,650" SPLIT,1615,4,3,West Drive,"94,450" SPLIT,1305,3,1.5,Graham Avenue,"$73,650"

  The following SAS program is submitted using the raw data file as input:

  data work.condo_ranch;

  infile 'file-specification' dsd;

  input style $ @;

  if style = 'CONDO' or style = 'RANCH';

  input sqfeet bedrooms baths street $ price : dollar10.;

  run;

  How many observations will the output data set contain?

  A. 0

  B. 3

  C. 5

  D. 7

  Correct Answer: B

• Question 82:

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

  The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:

  WORK.EMPLOYEE WORK.SALARY

  fname age fname salary

  Bruce 30 Bruce 25000

  Dan 40 Bruce 35000

  Dan 25000

  The following SAS program is submitted:

  data work.empdata;

  merge work.employee

  work.salary;

  by fname;

  totsal + salary;

  run;

  How many variables are output to the WORK.EMPDATA data set?

  A. 3

  B. 4

  C. 5

  D. No variables are output to the data set as the program fails to execute due to errors

  Correct Answer: B

• Question 84:

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

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

  Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

  A. libname sasdata 'SAS-data-library'; data sasdata.mydata; copy mydata;

  run;

  B. libname sasdata 'SAS-data-library'; data sasdata.mydata; keep mydata; run;

  C. libname sasdata 'SAS-data-library'; data sasdata.mydata; save mydata; run;

  D. libname sasdata 'SAS-data-library'; data sasdata.mydata; set mydata; run;

  Correct Answer: D

• Question 87:

  The following SAS DATA step is submitted:

  data sasdata.atlanta

  sasdata.boston

  work.portland

  work.phoenix;

  set company.prdsales;

  if region = 'NE' then output boston;

  if region = 'SE' then output atlanta;

  if region = 'SW' then output phoenix;

  if region = 'NW' then output portland;

  run;

  Which one of the following is true regarding the output data sets?

  A. No library references are required.

  B. The data sets listed on all the IF statements require a library reference.

  C. The data sets listed in the last two IF statements require a library reference.

  D. The data sets listed in the first two IF statements require a library reference.

  Correct Answer: D

• Question 88:

  The following SAS DATA step executes on Monday, April 25, 2000:

  data newstaff;

  set staff;

  start_date = today();

  run;

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

  A. a character string with the value '04/25/2000'

  B. a character string with the value 'Monday, April 25, 2000'

  C. the numeric value 14725, representing the SAS date for April 25, 2000

  D. the numeric value 04252000, representing the SAS date for April 25, 2000

  Correct Answer: C

• Question 89:

  The following SAS program is submitted:

  data work.new;

  mon = 3;

  day = 23;

  year = 2000;

  date = mdy(mon,day,year);

  run;

  Which one of the following is the value of the DATE variable?

  A. a character string with the value '23mar2000'

  B. a character string with the value '03/23/2000'

  C. a numeric value of 14692, which represents the SAS date value for March 23, 2000

  D. a numeric value of 3232000, which represents the SAS date value for March 23, 2000

  Correct Answer: C

• Question 90:

  The following SAS program is submitted:

  data revenue; set year_1; var1 = mdy(1,15,1960); run;

  Which one of the following values does the variable named VAR1 contain?

  A. 14

  B. 15

  C. 1151960

  D. '1/15/1960'

  Correct Answer: A