Exact of A00-212 real exam materials and bible for SAS Institute certification for IT specialist, Real Success Guaranteed with Updated A00-212 pdf dumps vce Materials. 100% PASS SAS Advanced Programming Exam for SAS 9 exam Today!
Q25. Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?
A. CHECK
B. UNIQUE
C. FORMAT
D. DISTINCT
Answer: A
Q26. Given the SAS data set ONE:
ONE
NUM VAR
1 A
2 B
3 C
Which SQL procedure program deletes the data set ONE?
A. proc sql; Drop table one; Quit;
B. proc sql; Remove table one; Quit;
C. proc sql; Delete table one; Quit;
D. proc sql; Delete from one; Quit;
Answer: A
Q27. The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X.
Which one of the following SAS programs uses the index to select observations from the data set ONE?
A. data two;
set three;
set one key = X;
run;
B. data two;
set three key = X;
set one;
run;
C. data two;
set one;
set three key = X;
run;
D. data two;
set three;
set one (key = X);
run;
Answer: A
Q28. The following SAS program is submitted:
data temp;
set sasuser.history(kep=date);
format date qtr
<insert BY statement here>
if first.date then total=0;
total+1;
if last.date;
run;
proc print data=temp;
run
SASUSER.HISTORY is sorted by the SAS date variable DATE.
The following output is required:
Date Total
1 13
3 15
4 25
Which By statement completes the data step and successfully generates the required output?
A. by groupformat date;
B. by formateed date;
C. by notsorted date;
D. by date qtr
Answer: A
Q29. Which SAS procedure changes the name of a permanent format for a variable stored in a
SAS data set?
A. DATASETS
B. MODIFY
C. FORMAT
D. REGISTRY
Answer: A
Q30. 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. No messages are written to the SAS log.
B. ERROR and WARNING messages are written to the SAS log.
C. Data set THREE is created with two variables and 50 observations.
D. Data set THREE is created with three variables and 100 observations.
Answer: B
Q31. 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
C. CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY
D. RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT
Answer: A
Q32. At the start of a new SAS session; the following program is submitted:
%macro one;
data _null_;
call symput('proc','measn);
run;
proc &proc data=sashelp.class;
run;
%mend;
%one()
What is the result?
A. The marco variable PRCO is stored in the SAS catalog WORK.SASMACR
B. The program fails to execute because PROC is a reserved word
C. The macro variable PROC is stored in the local symbol table
D. The macro variable PROC is stored in the global symbol table
Answer: D