SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 181:

  Given the following IF/THEN statement:

  If Age NE 16 and Age NE 15 then Group-1;

  Which assignment statement for variable Group is functionally equivalent to the original statement used in the above data step?

  A. if (Age NE 16) or (Age NE 15) then Group=1;
  B. where Age not between (15 and 16) then Group=1;
  C. where Age not between 15 and 16 then Group=1;
  D. if Age not in(15,16) then Group=1;
  A. if (Age NE 16) or (Age NE 15) then Group=1;

• Question 182:

  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
  C. the numeric value 14725, representing the SAS date for April 25, 2000

• Question 183:

  The following SAS program is submitted:

  data work.retail; cost = '20000'; total = .10 * cost; run;

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

  A. 2000
  B. '2000'
  C. . (missing numeric value)
  D. ' ' (missing character value)
  A. 2000

• Question 184:

  This question will ask you to provide lines of missing code. The following SAS program is submitted:

  

  Which statement inserted, respectively, in the two locations indicated above create a report stored in a PDF file?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

• Question 185:

  Given the SAS data set WORKAWARDS:

  WORK.AWARDS FNAME POINTS MONTH

  Amy 2 4 Amy 1 7 Gerard 3 3 Wang 3 3 Wang 1 12 Wang 1 8

  The following SAS program is submitted:

  proc sort data = work.awards; by descending fname points; run;

  How are the observations sorted?

  A. ENAME POINTS MONTH Wang 3 3 Wang 1 12 Wang 1 8 Gerard 3 3 Amy 2 4 Amy 1 7
  B. ENAME POINTS MONTH Amy 2 4 Amy 1 7 Gerard 3 3 Wang 3 3 Wang 1 8 Wang 1 12
  C. ENAME POINTS MONTH Wang 3 3 Wang 1 8 Wang 1 12 Gerard 3 3 Amy 2 4 Amy 1 7
  D. ENAME POINTS MONTH Wang 1 12 Wang 1 8 Wang 3 3 Gerard 3 3 Amy 1 7 Amy 2 4
  A. ENAME POINTS MONTH Wang 3 3 Wang 1 12 Wang 1 8 Gerard 3 3 Amy 2 4 Amy 1 7

• Question 186:

  The Excel workbook REGIONS.XLSX contains the following four worksheets:

  EAST WEST NORTH SOUTH

  The following program is submitted:

  libname MYXLS XLSX `c:\ data\ regions.xlsx';

  Which PROC PRINT step correctly displays the NORTH worksheet?

  A. proc print data=MYXLS.`NORTH'e; run;
  B. proc print data=MYXLS.NORTH.XLSX; run;
  C. proc print data=MYXLS.NORTH; run;
  D. proc print data=MYXLS.`NORTH$'n; run;
  D. proc print data=MYXLS.`NORTH$'n; run;

• Question 187:

  The following SAS program is submitted:

  

  How many observations are written to the WORK.VOLUME data set?

  A. 1
  A. 1

• Question 188:

  Given the following SAS data set WORK.SALES:

  

  The following SAS program is submitted:

  

  Which output is produced?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 189:

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

  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.
  D. The data sets listed in the first two IF statements require a library reference.