By admin | December 16, 2009

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

By admin | December 16, 2009

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 
By admin | December 16, 2009

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

By admin | December 16, 2009

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

By admin | December 9, 2009

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

Pages: Prev 1 2 3 4 5 6 ... 55 56 Next