SAS Training

SAS Certified Base Programmer 123 Questions (6)

The following SAS program is submitted:

proc print data = sasuser.houses;
run;

<insert OPTIONS statement here>

proc means data = sasuser.shoes;
run;

Which one of the following OPTIONS statements resets the page number to 1 for the second report?

A. option pageno = 1;
B. option pagenum = 1;
C. options reset pageno = 1;
D. options reset pagenum = 1;

SAS Certified Base Programmer 123 Questions (5)

The following SAS program is submitted:

data work.sets;
    do until (prod gt 6);
        prod + 1;
    end;
run;

Which one of the following is the value of the variable PROD in the output data set?

A. 5
B. 6
A. 7
B. 8

SAS Certified Base Programmer 123 Questions (4)

Which one of the following is true of the SUM statement in a SAS DATA step program?

A. It is only valid in conjunction with a SUM function.
B. It is not valid with the SET, MERGE and UPDATE statements.
C. It adds the value of an expression to an accumulator variable and ignores missing values.
D. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.

SAS Certified Base Programmer 123 Questions (3)

The following SAS program is submitted:

data work.new;
    length word $7;
    amount = 7;
    if amount = 5 then word = 'CAT';
    else if amount = 7 then word = 'DOG';
    else work = 'NONE!!!';
    amount = 5;
run;

Which one of the following represents the values of the AMOUNT and WORD variables?

A.

amount word
5      DOG

B.

amount word
5      CAT

C.

amount word
7      DOG

D.

amount word
7      ' ' (missing character value)

SAS Certified Base Programmer 123 Questions (2)

When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:

libnamesastemp 'SAS-data-library';
options obs = 500;

proc print data = sasdata.prdsales (firstobs = 100);
run;

options obs = max;

proc means data = sasdata.prdsales (firstobs = 500);
run;

How many observations are processed by each procedure?

A.
400 for PROC PRINT
4500 for PROC MEANS

B.
401 for PROC PRINT
4501 for PROC MEANS

C.
401 for PROC PRINT
4500 for PROC MEANS

D.
500 for PROC PRINT
5000 for PROC MEANS