SAS Training

SAS Certified Base Programmer 50 Questions (26)

A SAS report currently flows over two pages because it is too long to fit within the specified display dimension. Which one of the following actions would change the display dimension so that the report fits on one page?

a. Increase the value of the LINENO option.
b. Decrease the value of the PAGENO option.
c. Decrease the value of the LINESIZE option.
d. Increase the value of the PAGESIZE option.

SAS Certified Base Programmer 50 Questions (25)

The following report is generated:

Style
of homes n Asking
Price
----------------------------
CONDO    4 $99,313
RANCH    4 $68,575
SPLIT    3 $77,983
TWOSTORY 4 $83,825

Which of the following steps created the report?
a.

proc freq data=sasuser.houses;
    tables style price /nocum;
    format price dollar10.;
    label style="Style of homes"
        price="Asking price";
run;

b.

proc print data=sasuser.houses;
    class style;
    var price;
    table style,n price*mean*f=dollar10.;
    label style="Style of homes"
        price="Asking price";
run;

c.

proc means data=sasuser.houses n mean;
    class style;
    var price;
    format price dollar10.;
    label style="Style of homes"
        price="Asking price";
run;

d.

proc report data=sasuser.houses nowd headline;
    column style n price;
    define style / group "Style of homes";
    define price / mean format=dollar8.
        "Asking price";
run;

SAS Certified Base Programmer 50 Questions (24)

Which of the following permanently associates a format with a variable?

a. the FORMAT procedure
b. a FORMAT statement in a DATA step
c. an INPUT function with format modifiers
d. an INPUT statement with formatted style input

SAS Certified Base Programmer 50 Questions (23)

The following program is submitted:

data work.test;
    set work.staff (keep=salary1 salary2 salary3);
    <insert ARRAY statement here>
run;

Which ARRAY statement completes the program and creates new variables?

a. array salary{3};
b. array new_salary{3};
c. array salary{3} salary1-salary3;
d. array new_salary{3} salary1-salary3;

SAS Certified Base Programmer 50 Questions (22)

The following SAS program is submitted:

data work.inventory;
    products=7;
    do until (products gt 6);
        products+1;
    end;
run;

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

a. 5
b. 6
c. 7
d. 8