SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 61:

  The following SAS program is submitted:

  %let lib = %upcase(sasuser);

  proc sql;

  select nvar

  from dictionary.tables

  where libname = "andlib";

  quit;

  Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?

  A. no result set
  B. a syntax error in the log
  C. a report showing the names of each table in SASUSER
  D. a report showing the number of columns in each table in SASUSER
  D. a report showing the number of columns in each table in SASUSER

• Question 62:

  The following SAS program is submitted:

  %macro execute;

  proc print data = sasuser.houses;

  run;

  %end;

  %mend;

  Which of the following completes the above program so that it executes on Tuesday?

  A. %if andsysday = Tuesday %then %do;
  B. %if andsysday = 'Tuesday' %then %do;
  C. %if "andsysday" = Tuesday %then %do;
  D. %if 'andsysday' = 'Tuesday' %then %do;
  A. %if andsysday = Tuesday %then %do;

• Question 63:

  Given the following SAS data set ONE:

  ONE COUNTRY CITY VISIT

  USA BOSTON 10

  UK LONDON 5

  USA DALLAS

  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 BOSTON 50 USA DALLAS 20
  B. COUNTRY CITY TOTAL UK LONDON 20 UK MARLOW 10 USA BOSTON 50 USA DALLAS 20
  C. COUNTRY CITY TOTAL USA BOSTON 50 USA DALLAS 20 UK LONDON 20 UK MARLOW 10
  D. 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

• Question 64:

  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 = andnumgrp;

  select distinct status

  into :group1-:groupandnumgrp

  from sasuser.highway;

  quit;

  %do i = 1 %to andnumgrp;

  proc print data = sasuser.highway;

  where status = "andandgroupandi" ;

  run;

  %end;

  %mend;

  %highway

  How many reports are produced by the above program?

  B. 1
  C. 2
  D. 5
  C. 2

• Question 65:

  The following SAS program is submitted:

  proc sql;

  select *

  from dictionary.tables;

  quit;

  Which one of the following is reported?

  A. metadata on all tables in all libraries
  B. metadata on all tables in the WORK library only
  C. metadata on all tables in the SASUSER library only
  D. metadata on all tables in the DICTIONARY library only
  A. metadata on all tables in all libraries

• Question 66:

  The following SAS program is submitted:

  %let first = yourname;

  %let last = first;

  %put andandandlast;

  Which one of the following is the result in the log of the %PUT statement?

  A. first
  B. andfirst
  C. yourname
  D. andyourname
  C. yourname

• Question 67:

  Given the following SAS data set ONE:

  ONE LEVEL AGE

  1 10

  2 20

  3 20

  2 10

  1 10

  2 30

  3 10

  2 20

  3 30

  1 10

  The following SAS program is submitted:

  proc sql;

  select level, max(age) as MAX

  from one

  group by level

  having max(age) > (select avg(age) from one);

  quit;

  Which one of the following reports is generated?

  A. LEVEL AGE 2 20 3 20
  B. LEVEL AGE 2 30 3 30
  C. LEVEL MAX 2 20 3 30
  D. LEVEL MAX 2 30 3 30
  D. LEVEL MAX 2 30 3 30

• Question 68:

  The following SAS program is submitted:

  proc sql;

  select *

  from dictionary.tables;

  quit;

  Which one of the following is reported?

  A. metadata on all tables in all libraries
  B. metadata on all tables in the WORK library only
  C. metadata on all tables in the SASUSER library only
  D. metadata on all tables in the DICTIONARY library only
  A. metadata on all tables in all libraries

• Question 69:

  The DICTIONARY.MACROS table stores information about which of the following?

  A. user defined macro variables only
  B. system defined macro variables only
  C. both user and system defined macro variables
  D. macros stored in the autocall macro library only
  C. both user and system defined macro variables

• Question 70:

  Given the following SAS data set ONE:

  ONE REP AREA COST

  SMITH NORTH 100

  SMITH SOUTH 200

  JONES EAST 100

  SMITH NORTH 300

  JONES WEST 100

  JONES NORTH 200

  JONES NORTH 400

  SMITH NORTH 400

  JONES WEST 100

  JONES WEST 300

  The following SAS program is submitted:

  proc sql;

  select rep, area, count(*) as TOTAL

  from one group by rep, area;

  quit;

  Which one of the following reports is generated?

  A. REP AREA COUNT JONES EAST 100 JONES NORTH 600 JONES WEST 500 SMITH NORTH 800 SMITH SOUTH 200
  B. REP AREA TOTAL JONES EAST 100 JONES NORTH 600 JONES WEST 500 SMITH NORTH 800 SMITH SOUTH 200
  C. REP AREA TOTAL JONES EAST 1 JONES NORTH 2 JONES WEST 3 SMITH NORTH 3 JONES WEST 3 SMITH NORTH 3 SMITH SOUTH 1
  D. REP AREA TOTAL JONES EAST 1 JONES NORTH 2 JONES WEST 3 SMITH NORTH 3 SMITH SOUTH 1 SMITH NORTH 3 SMITH SOUTH 1
  D. REP AREA TOTAL JONES EAST 1 JONES NORTH 2 JONES WEST 3 SMITH NORTH 3 SMITH SOUTH 1 SMITH NORTH 3 SMITH SOUTH 1