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.
Which one of the following SAS SORT procedure options eliminates identical consecutive observations?
A. NODUP
B. UNIQUE
C. DISTINCT
D. NODUPKEY
The following SAS program is submitted:
options mprint;
%macro test(parm);
proc andparm data = sashelp.prdsale;
run;
%mend;
%test(print)
What is the result of the MPRINT options?
A. It has no effect in this example
B. It writes the original program code inside the marco definition to the SAS log
C. It writes macro execution messages to the SAS.log
D. It echoes the text sent to the SAS compiler as a result of macro execution in the SAS log
Given the following SAS program:
What will be the output from the PRINT Procedure?
A. Option A
B. Option B
C. Option C
D. Option D
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. No variable are created in the PDV
B. The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV
C. The variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5, POINTS6 are created in the PDV
D. The variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in the PDV
The following SAS program is submitted: % let product = merchandise;
And the following message is written to the SAS log: The value is "merchandise"
Which macro statement wrote this message?
A. % put the value is "andproduct.";
B. % put the value is ""andproduct."";
C. % put the value is "%quote(andproduct).";
D. % put the value is ` " `andproduct. ` " ` ;
The following SAS program is submitted:
data two;
y = '2';
run;
%let x = 10;
%let var = y;
data one;
set two (keep = andvar);
z = andvar * andx;
run;
Which one of the following is the value of the variable Z when the program finishes execution?
A. _ERROR_
B. 20 (as a numeric)
C. 20 (as a character)
D. . (missing numeric)
Given the SAS data sets: The following SAS program is submitted:
What output is produced?
A. Name
Charlie
Omar
B. Name
Omar
Nguyen
C. Name
Charlie
Nguyen
Nguyen
D. Name
Charlie
Omar
Nguyen
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 200 M 110 F 150 F 210
B. CATEGORY EARNINGS
M .
M 110
F 150
F 210
C. CATEGORY SALARY BONUS EARNINGS M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210
D. 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
The following SAS program is submitted:
The purpose of FILEVAR = option on the INFILE statement is to name the variable next, whose value:
A. Points to a new input file
B. Points to an aggregate storage location
C. Is output to the SAS data set WORK.NEW
D. Is an input SAS data set reference
