Online Access Free A00-212 Practice Test

Which one of the following statements about compressed SAS data sets is always true?

• A.An updated observation is stored in its original location.
• B.New observations are added to the end of the SAS data set.
• C.Each observation is treated as a single string of bytes.
• D.Each observation occupies the same number of bytes.

In which one of the following SAS programs is the SAS data set index named CHAR1 always used?

• A.data three;
  set one;
  if char1 in ('new york' 'los angeles');
  run;
• B.data three;
  set one;
  where char1 in ('new york' 'los angeles');
  run;
• C.proc sql;
  create table three as
  select *
  from one, two
  where one.char1 > two.char1;
  quit;
• D.data three;
  set one;
  set two key = char1;
  run;

The following SAS program is submitted:
% macro loop;
data one;
% do I=1 %to 3;
var&I=&I;%
end
run;
% mend;
% loop
After this program executes; the following is written to the SAS log:
(LOOP): Beginning execution
(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1
(LOOP): %DO loop index variable l is now 2; loop will iterate again
(LOOP): %DO loop index variable l is no 3; loop will iterate again
(LOOP): %DO loop index variable l is no 4; loop will iterate again
(LOOP): Ending execution
Which SAS system option displays the notes in the SAS log?

• A.SYMBOLGEN
• B.MACRO
• C.MPRINT
• D.MLOGIC

Given the SAS data set WORK.ONE:

The following SAS program is submitted;

Which result set would be generated?

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

Which SET statements option names a variable that contains the number of the observation to read during the
current iteration of the DATA step?

• A.NOBS=pointobs
• B.POINT=pointobs
• C.OBS=pointobs
• D.KEY=pointobs