SAS Certified Adv Programmer 130 Questions (33)
Which one of the following SAS SORT procedure options eliminates identical consecutive observations?
A. NODUP
B. UNIQUE
C. DISTINCT
D. NODUPKEY
SAS Certified Adv Programmer 130 Questions (32)
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
SAS Certified Adv Programmer 130 Questions (31)
Text is sent to the SAS compiler as a result of macro execution.
Which one of the following SAS System options writes that text to the log?
A. MPRINT
B. MLOGIC
C. MSOURCE
D. SOURCE2
SAS Certified Adv Programmer 130 Questions (30)
Given the following SAS data set SASUSER.HIGHWAY:
SASUSER.HIGHWAY STEERING SEATBELT SPEED STATUS COUNT absent no 0-29 serious 31 absent no 0-29 not 1419 absent no 30-49 serious 191 absent no 30-49 not 2004 absent no 50+ serious 216
The following SAS program is submitted:
%macro highway;
proc sql noprint;
select count(distinct status) into:
numgrp from sasuser.highway;
%let numgrp = &numgrp;
select distinct status into:
group 1- :group&numgrp from sasuser.highway;
quit;
%do i = 1 %to &numgrp;
proc print data = sasuser.highway;
where status = "&&group&i";
run;
%end;
%mend;
%highway
How many reports are produced by the above program?
A. 0
B. 1
C. 2
D. 5
SAS Certified Adv Programmer 130 Questions (29)
Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?
A. MODIFY
B. FORMAT
C. CONTENTS
D. DATASETS