최신 SAS Institute Systems Certification A00-202 무료샘플문제:

1. The following SAS program is submitted: %let lib = %upcase(sasuser);
proc sql; select nvar from dictionary.tables where libname = "&lib";
quit;
Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?

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

2. 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 SPLIT TWOSTORY
B) RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT
C) CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY
D) RANCH SPLIT CONDO TWOSTORY

3. The SAS data set ONE contains the variables X, Y, Z, and W.
The following SAS program is submitted:
proc transpose data = one
out = trans
name = new;
by x;
var y;
run;
Which one of the following contains all the names of the columns created by the TRANSPOSE procedure?

A) new, X, and COL1
B) _NAME_, X, and Y
C) new, X, Y, and _COL1_
D) X, Y, Z, and W

4. 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 left join two on one.year = two.year;
quit;
Which one of the following reports is generated?

A) YEAR QTR BUDGET SALES
2001 3 500 .
2001 4 400 300 2002 1 700 600
B) YEAR QTR BUDGET SALES
2001 3 500 300 2001 4 400 300 2002 1 700 600
C) YEAR QTR BUDGET SALES 2001 3 500 .
D) YEAR QTR BUDGET SALES
2001 4 400 300 2002 1 700 600

5. Given the following SAS data sets ONE and TWO:
ONE TWO NUM CHAR1 NUM CHAR2
1 A 2 X 2 B 3 Y 4 D 5 V
The following SAS program is submitted creating the output table THREE:
data three; set one two; run;
THREE
NUM CHAR1 CHAR2
1 A
2 B
4 D
2 X
3 Y
5 V
Which one of the following SQL programs creates an equivalent SAS data set THREE?

A) proc sql;C.proc sql;
create table three as
select *
from one
union
select *
from two;
quit;
B) proc sql;
create table three as
select *
from one
outer union corr
select *
from two;
quit;
C) proc sql;D.proc sql;
create table three as
select *
from one
union corr
select *
from two;
quit;
D) proc sql;
create table three as
select *
from one
outer union
select *
from two;
quit;

질문과 대답: