A00-202 Online Practice Questions and Answers
Consider the following SAS log:
229 data sasuser.ranch sasuser.condo / view = sasuser.ranch; 230 set sasuser.houses;
231 if style = 'RANCH' then output sasuser.ranch; 232 else if style = 'CONDO' then output sasuser.condo; 233 run;
NOTE: DATA STEP view saved on file SASUSER.RANCH. NOTE: A stored DATA STEP view cannot run under a different operating system.
235 proc print data = sasuser.condo;
ERROR: File SASUSER.CONDO.DATA does not exist.
236 run;
NOTE: The SAS System stopped processing this step because of errors.
Which one of the following explains why the PRINT procedure fails?
A. SASUSER.CONDO is a stored DATA step program.
B. A SAS data file and SAS data view cannot be created in the same DATA step.
C. A second VIEW=SASUSER.CONDO option was omitted on the DATA statement.
D. The view SASUSER.RANCH must be processed before SASUSER.CONDO is created.
Given the following SAS data sets ONE and TWO:
ONE TWO
YEAR QTR BUDGET YEAR QTR SALES
------------------------------- --------------------------------- 2001 3 500 2001 4 300
2001 4 400 2002 1 600
2002 1 700
The following SAS program is submitted:
proc sql;
select one.*, sales
from one, two
where one.year = two.year;
quit;
Which one of the following reports is generated?
A. YEAR QTR BUDGET SALES --------------------------------------------------------- 2001 4 400 300 2002 1 700 600
B. YEAR QTR BUDGET SALES ---------------------------------------------------------- 2001 3 500 . 2001 4 400 300 2002 1 700 600
C. YEAR QTR BUDGET SALES ------------------------------------------------------------ 2001 3 500 300 2001 4 400 300 2002 1 700 600
D. YEAR QTR BUDGET SALES ------------------------------------------------------------ 2001 3 500 300 2001 4 400 300 2002 1 700 300 2001 3 500 600 2001 4 400 600 2002 1 700 600
Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?
A. MODIFY
B. FORMAT
C. CONTENTS
D. DATASETS
The following SAS program is submitted:
%let a = cat;
%macro animal(a = frog);
%let a = bird;
%mend;
%animal(a = pig)
%put a is anda;
Which one of the following is written to the SAS log?
A. a is anda
B. a is cat
C. a is pig
D. a is bird
Given the following SAS data sets ONE and TWO:
ONE TWO
OBS COMMON X OBS COMMON Y
---------------------------- ------------------------------ 1 A 10 1 A 1
2 A 13 2 A 3
3 A 14 3 B 4
4 B 9 4 B 2
5 C 8 5 C 5
6 C 14
The following SAS DATA step is submitted:
data combine;
set one;
set two;
run;
Which one of the following represents the data values stored in data set COMBINE?
A. OBS COMMON X Y
1 A 10 1
2 A 13 3
3 A 14 3
4 B 9 4
5 B 9 2
6 C 8 5
7 C 14 5
B. OBS COMMON X Y
1 A 10 1
2 A 13 3
3 B 9 4
4 C 8 5
C. OBS COMMON X Y
1 A 10 1
2 A 13 3
3 B 14 4
4 B 9 2
5 C 8 5
D. OBS COMMON X Y
1 A 10 1
2 A 13 1
3 A 14 1
4 A 10 3
5 A 13 3
6 A 14 3
7 B 9 4
8 B 9 2
9 C 8 5
10 C 14 5
The following SAS program is submitted:
%macro test(var);
proc print data = sasuser.class;
where age > andvar;
run;
%mend;
Which type of parameter is the macro variable VAR?
A. default
B. keyword
C. positional
D. command
The following SAS program is submitted:
proc datasets lib = testdata;
modify one;
label num = 'Number';
format num 4.;
quit;
Which one of the following SQL programs produces the same results as the above DATASETS procedure?
A. proc sql; modify table testdata.one num format = 4. label = 'Number'; quit;
B. proc sql;
alter table testdata.one
modify num format = 4.
label = 'Number';
quit;
C. proc sql; modify table testdata.one alter num format = 4. label = 'Number'; quit;
D. proc sql; alter table testdata.one modify num (format = 4. label = 'Number'); quit;
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
Which one of the following techniques concatenates data in SAS?
A. the APPEND procedure
B. the DATA step with a MERGE statement
C. the DATA step with a COMBINE statement
D. the INTERSECT operator in the SQL procedure
The following SAS ARRAY statement is submitted: array score{*} a4 - a10, a25 ;
Which one of the following is the maximum number of elements stored?
A. 3
B. 7
C. 8
D. 11