A00-212 무료 덤프문제 온라인 액세스

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

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

Given the following SAS data set SASUSER.HIGHWAY:
SASUSER.HIGHWAY
STEERING SEATBELT SPEED STATUS COUNT
absent no 0-29 serious 31
absent no 0-29 not 1419
absent no 30-49 serious 191
absent no 30-49 not 2004
absent no 50+ serious 216
The following SAS program is submitted:
% macro highway;
proc sql noprint;
select count(distinct status)
into :numgrp
from sasuser.highway;
% let numgrp = &numgrp;
select distinct status
into :group1-:group&numgrp
from sasuser.highway;
quit;
% do i = 1 %to &numgrp;
proc print data = sasuser.highway;
where status = "&&group&i" ;
run;
% end;
% mend;
% highway
How many reports are produced by the above program?

• A.1
• B.2
• C.5
• D.0

The SAS data set TEMP has the following distribution of values for variable A:
A Frequency
1 500,000
2 500,000
6 7,000,000
8 3,000
Which one of the following SAS programs requires the least CPU time to be processed?

• A.data new;
  set temp;
  if a = 8 then
  b = 'Small ';
  else if a in(1, 2) then
  b = 'Medium';
  else if a = 6 then
  b = 'Large';
  run;
• B.data new;
  set temp;
  if a = 6 then
  b = 'Large ';
  else if a in (1, 2) then
  b = 'Medium';
  else if a = 8 then
  b = 'Small';
• C.data new;
  set temp;
  if a = 6 then
  b = 'Large ';
  if a in (1, 2) then
  b = 'Small';
  run;
• D.data new;
  set temp;
  if a in (1, 2) then
  b = 'Medium';
  else if a = 8 then
  b = 'Small';
  else if a = 6 then
  b = 'Large';
  run;

Given the following SAS data set ONE:
ONE
COUNTRY CITY VISIT
USA BOSTON 10
UK LONDON 5
USA DALLAS 10
UK MARLOW 10
USA BOSTON 20
UK LONDON 15
USA DALLAS 10
The following SAS program is submitted:
proc sql;
select country, city, sum(visit) as TOTAL
from one
group by country, city
order by country, total desc;
quit;
Which one of the following reports is generated?

• A.COUNTRY CITY TOTAL
  UK MARLOW 10
  UK LONDON 20
  USA DALLAS 20
  USA BOSTON 50
• B.COUNTRY CITY TOTAL
  UK LONDON 20
  UK MARLOW 10
  USA BOSTON 50
  USA DALLAS 20
• C.COUNTRY CITY TOTAL
  UK MARLOW 10
  UK LONDON 20
  USA BOSTON 50
  USA DALLAS 20
• D.COUNTRY CITY TOTAL
  USA BOSTON 50

The following SAS program is submitted:
% let value = 9;
% let value2 = 5;
% let newval = %eval(&value / &value2);
Which one of the following is the resulting value of the macro variable NEWVAL?

• A.1
• B.2
• C.null
• D.1.8