NEW QUESTION NO: 8
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, Y, and _COL1_
B. _NAME_, X, and Y
C. new, X, and COL1
D. X, Y, Z, and W
Answer: C

NEW QUESTION NO: 9
In which one of the following SAS programs is the SAS data set index named CHAR1 always used?
A. data three;
set one;
if char1 in ('new york' 'los angeles');
run;
B. proc sql;
create table three as
select *
from one, two
where one.char1 > two.char1;
quit;
C. data three;
set one;
where char1 in ('new york' 'los angeles');
run;
D. data three;
set one;
set two key = char1;
run;
Answer: D

NEW QUESTION NO: 10
The following SAS program is submitted:

How will the variable be listed?
A. Weight Height
B. Weight Height Name Age
C. Name Age Weight Height
D. Height Weight Name Age
Answer: C

NEW QUESTION NO: 11
What is generated as a result of submitting the RANUNI function with a seed of 123?
A. A different sequence of random numbers with each program execution
B. A random number between 0 and 123
C. A consistent sequence of random numbers with each program execution
D. A missing value because 123 is an invalid argument for the RANUNI function
Answer: C

NEW QUESTION NO: 12
The following SAS program is submitted:
data temp;
array points{2,3} (10,15,20,25,30,35);
run;
What impact does the ARRAY statement have in the Program Data Vector(PDV)?
A. The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV
B. No variable are created in the PDV
C. The variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in the PDV
D. The variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5, POINTS6 are created in the PDV
Answer: D

NEW QUESTION NO: 13
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?
A. SASUSER.CONDO is a stored DATA step program.
B. The view SASUSER.RANCH must be processed before SASUSER.CONDO is created.
C. A second VIEW=SASUSER.CONDO option was omitted on the DATA statement.
D. A SAS data file and SAS data view cannot be created in the same DATA step.
Answer: B

NEW QUESTION NO: 14
Given the following SAS data set named WORK.INTERNAT:
WORK.INTERNAT
LOCATION SUM
USA 30
EUR 40
The following SAS program is submitted:
%let LOC = Usa;
proc sql;
select *
from internat
where location = "&Loc";
quit;
Which one of the following is the result when the above code is executed on the above data set?
A. No report is generated as the case of the macro variable name is different.
B. A report is generated with one destination.
C. A report is generated with the two original observations as the where clause does not work.
D. No report is generated as the case of the compared values is different.
Answer: D

NEW QUESTION NO: 15
Given the SAS data set ONE:
ONE
DIVISION SALES
A 1234
A 3654
B 5678
The following SAS program is submitted:
Data_null_;
Set one;
By divition;
If first.division then
Do;
%let mfirst=sales;
end;
run;
What is the value of the macro variable MFRIST when the program finishes execution?
A. 1234
B. 5678
C. null
D. sales
Answer: D

NEW QUESTION NO: 16
The SAS data set ONE consists of five million observations and has 25 variables.
Which one of the following SAS programs successfully creates three new variables TOTREV, TOTCOST, and PROFIT and requires the least CPU time to be processed?
A. data two;
set one;
totrev = sum(price * quantity);
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
if totrev > 1000;
run;
B. data two;
set one;
where totrev > 1000;
totrev = sum(price * quantity);
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;
C. data two;
set one;
totrev = sum(price * quantity);
where totrev > 1000;
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;
D. data two;
set one;
totrev = sum(price * quantity);
if totrev > 1000;
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;
Answer: D

NEW QUESTION NO: 17
SIMULATION
The question will ask you to provide a segment of missing code.
The following SAS program is submitted:

The text box above, complete the %PUT statement to produce the following log output:

Case is ignored and standard SAS syntax rules apply.
Answer: 
_sample_

NEW QUESTION NO: 18
Which one of the following SAS programs uses the most amount of memory resources for output buffers?
A. data new(bufsize = 1000 bufno = 5);
set temp;
run;
B. data new(bufsize = 4000 bufno = 1);
set temp;
run;
C. data new(bufsize = 1000 bufno = 2);
set temp;
run;
D. data new(bufsize = 2000 bufno = 3);
set temp;
run;
Answer: D