Free SASInstitute A00-202 Exam Dumps Questions & Answers

The variable attributes of SAS data sets ONE and TWO are shown below:
ONE TWO # Variable Type Len Pos # Variable Type Len Pos 2 sales Num 8 8 2 budget Num 8 8 1 year Num 8 0 3 sales Char 8 16
1 year Num 8 0
Data set ONE contains 100 observations. Data set TWO contains 50 observations. Both data sets are sorted by the variable YEAR.
The following SAS program is submitted:
data three; merge one two; by year;
run;
Which one of the following is the result of the program execution?

• A.ERROR and WARNING messages are written to the SAS log.
• B.Data set THREE is created with two variables and 50 observations.
• C.No messages are written to the SAS log.
• D.Data set THREE is created with three variables and 100 observations.

Which one of the following is an advantage of creating and using a SAS DATA step view?

• A.It works quickly through multiple passes of the data.
• B.It always accesses the most current data.
• C.It is useful when the underlying data file structure changes.
• D.It can store an index.

Given the following SAS data set ONE:
ONE
CATEGORY AGE SALARY BONUS
M 28 200 .
M 25 100 10
F 18 100 50
F 25 200 10
The following SAS program is submitted:
proc sql;
create table two as
select category, salary + bonus as EARNINGS from one; quit;
Which one of the following represents the data values stored in the data set TWO?

• A.CATEGORY EARNINGS
  M . M 110 F 150 F 210
• B.CATEGORY SALARY BONUS EARNINGS
  M 200 . . M 100 10 110 M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210
• C.CATEGORY EARNINGS
  M 200 M 110 F 150 F 210
• D.CATEGORY SALARY BONUS EARNINGS
  M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210

Which one of the following is the purpose of the IDXNAME= data set option?

• A.It instructs SAS to use a specific index for WHERE processing.
• B.It instructs SAS to use any available index for WHERE processing.
• C.It instructs SAS to store an index in a particular location.
• D.It instructs SAS to name and store a specific index.

The following are values of the variable STYLE from the SAS data set SASUSER.HOUSES:
SASUSERS.HOUSES OBS STYLE
1 RANCH 2 SPLIT 3 CONDO 4 TWOSTORY 5 RANCH 6 SPLIT 7 SPLIT
The following SAS program is submitted:
proc sql noprint; select distinct style into :styles separated by ' ' from sasuser.houses order by style;
quit;
Which one of the following is the value of the resulting macro variable?

• A.CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY
• B.RANCH SPLIT CONDO TWOSTORY
• C.CONDO RANCH SPLIT TWOSTORY
• D.RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT