The following SAS program is submitted:
data one;
do i = 1 to 10;
ptobs = ceil(ranuni(0) * totobs);
set temp point = ptobs
nobs = totobs;
output;
end;
stop;
run;
The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?
Answer : C
Which one of the following programs contains a syntax error?
Answer : D
The following SAS code is submitted:
%macro houses(dsn = houses,sub = RANCH);
data &dsn;
set sasuser.houses;
if style = "¬";
run;
%mend;
%houses(sub = SPLIT)
%houses(dsn = ranch)
%houses(sub = TWOSTORY)
Which one of the following is the value of the automatic macro variable SYSLAST?
Answer : D
Given the following SAS data sets ONE and TWO:
ONE TWO -
NUM COUNTRY NUM CITY -
1 CANADA 3 BERLIN
2 FRANCE 5 TOKYO
3 GERMANY 4 BELGIUM
5 JAPAN
The following SAS program is submitted:
proc sql;
select country
from one
where not exists
(select *
from two
where one.num = two.num);
quit;
Which one of the following reports is generated?
Answer : C
Which one of the following statements is true?
Answer : B
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?
Answer : B
Given the following SAS statement:
%let idcode = Prod567;
Which one of the following statements stores the value 567 in the macro variable CODENUM?
Answer : C
The following SAS program is submitted:
data new (bufsize = 6144 bufno = 4);
set old;
run;
Which one of the following describes the difference between the usage of BUFSIZE= and BUFNO= options?
Answer : B
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.
234
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?
Answer : D
Which one of the following is an advantage of creating and using a SAS DATA step view?
Answer : B
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;
quit;
Which one of the following reports is generated?
Answer : D
Given the following SAS data set ONE:
ONE -
NUM VAR -
1 A
2 B
3 C
Which one of the following SQL programs deletes the SAS data set ONE?
Answer : C
The SAS data set TEMP has the following distribution of values for variable A:
A Frequency -
1 500,000
2 500,000
6 7,000,000
8 3,000
Which one of the following SAS programs requires the least CPU time to be processed?
Answer : C
The following SAS program is submitted:
%let value = 9;
%let value2 = 5;
%let newval = %eval(&value / &value2);
Which one of the following is the resulting value of the macro variable NEWVAL?
Answer : A
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?
Answer : D