SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 101:

  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;
  C. proc print data = sasuser.houses label; label price = "Sale Price"; run;

• Question 102:

  The following SAS program is submitted:

  libname sasdata 'SAS-data-library';

  data test;

  set sasdata.chemists;

  if jobcode = 'chem3'

  then description = 'Senior Chemist';

  else description = 'Unknown';

  run;

  A value for the variable JOBCODE is listed below:

  JOBCODE

  CHEM3

  Which one of the following values does the variable DESCRIPTION contain?

  A. chem3
  B. Unknown
  C. Senior Chemist
  D. ' ' (missing character value)
  B. Unknown

• Question 103:

  When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:

  libname sasdata 'SAS-data-library';

  options obs = 500;

  proc print data = sasdata.prdsales (firstobs = 100);

  run;

  options obs = max;

  proc means data = sasdata.prdsales (firstobs = 500);

  run;

  How many observations are processed by each procedure?

  A. 400 for PROC PRINT 4500 for PROC MEANS
  B. 401 for PROC PRINT 4501 for PROC MEANS
  C. 401 for PROC PRINT 4500 for PROC MEANS
  D. 500 for PROC PRINT 5000 for PROC MEANS
  B. 401 for PROC PRINT 4501 for PROC MEANS

• Question 104:

  The following SAS program is submitted: data WORK.DATE_INFO;

  Day="01" ; Yr=1960 ; X=mdy(Day,01,Yr) ; run;

  What is the value of the variable X?

  A. the numeric value 0
  B. the character value "01011960"
  C. a missing value due to syntax errors
  D. the step will not compile because of the character argument in the mdy function.
  A. the numeric value 0

• Question 105:

  The following SAS program is submitted:

  data work.flights;

  destination = `cph';

  select(destination);

  when('LHR') city = `London';

  when('CPH') city = `Copenhagen';

  otherwise city = `Other';

  end;

  run;

  What is the value of the CITY variable?

  A. Other
  B. Copenh
  C. Copenhagen
  D. ``(missing character value)
  A. Other

• Question 106:

  A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000. Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?

  A. proc print data = sasuser.houses; where price lt 60000; where price gt 100000; run;
  B. proc print data = sasuser.houses; where price lt 60000 or price gt 100000; run;
  C. proc print data = sasuser.houses; where price lt 60000 and price gt 100000; run;
  D. proc print data = sasuser.houses; where price lt 60000 or where price gt 100000; run;
  B. proc print data = sasuser.houses; where price lt 60000 or price gt 100000; run;

• Question 107:

  The following SAS program is submitted:

  

  What types of variables are DayOfMonth, MonthOfYear, and Year?

  A. DayOfMonth, Year, and MonthOfYear are character.
  B. DayOfMonth, Year, and MonthOfYear are numeric.
  C. DayOfMonth and Year are numeric. MonthOfYear is character.
  D. DayOfMonth, Year, and MonthOfYear are date values.
  B. DayOfMonth, Year, and MonthOfYear are numeric.

• Question 108:

  Given the SAS data set WORK.PRODUCTS:

  

  How many variables does the WORK.REVENUE data set contain?

  A. 2
  B. 3
  C. 4
  D. 6
  A. 2

• Question 109:

  Given the data set WORK.EMPDATA:

  

  Which one of the following where statements would display observations with job titles containing the word 'Manager'?

  A. where substr(Job_Title,(length(Job_Title)-6))='Manager';
  B. where upcase(scan(Job_Title,-1,' '))='MANAGER';
  C. where Job_Title='% Manager ';
  D. where Job_Title like '%Manager%';
  D. where Job_Title like '%Manager%';

• Question 110:

  Given the SAS data set ONE:

  ONE

  Obs Dte

  1 09JAN2005

  2 12JAN2005

  The following SAS program is submitted:

  data two;

  set one;

  day = ;

  format dte date9.;

  run;

  The data set TWO is created:

  TWO

  Obs Dte Day

  1 09JAN2005 1

  12 JAN2005 4

  Which expression successfully completed the program and created the variable DAY?

  A. day(dte)
  B. weekday(dte)
  C. dayofweek(dte)
  D. datdif(dte,'01jan2005'd,'act/act')
  B. weekday(dte)