SAS Training

SAS Certified Adv Programmer 50 Questions (1)

Given the following SAS data sets One and Two:

One

Two

The following SAS program is submitted:

proc sql;
    select one.*, sales
        from one, two
        where one.year=two.year and
              one.qtr=two.qtr;
quit;

Which of the following reports is generated?

a.

b.

c.

d.

SAS Certified Base Programmer 50 Questions (50)

The following SAS program is submitted:

data test;
    input country $8. date mmddyy10.;
cards;
Germany 12/31/2000
France 01/32/2001
;
run;

Which one of the following is the value of the variable _ERROR_ when the variable _N_ has a value of 2?

a. 0
b. 1
c. true
d. false

SAS Certified Base Programmer 50 Questions (49)

Which one of the following statements is true when SAS encounters a data error?

a. The execution phase is stopped, and a system abend occurs.
b. A missing value is assigned to the appropriate variable, and execution continues.
c. The execution phase is stopped, and a SAS data set is created with zero observations.
d. A missing value is assigned to the appropriate variable, and execution stops at that point.

SAS Certified Base Programmer 50 Questions (48)

The following SAS program is submitted:

proc report data=survey nowd;
    column age choice1;
    <insert DEFINE statement here>
    define choice1/display;
run;

Which one of the following DEFINE statements completes the program and displays values of the variable Age in ascending order?

a. define age/sort;
b. define age/order;
c. define age/sort by age;
d. define age/order by age;

SAS Certified Base Programmer 50 Questions (47)

The following SAS program is submitted:

data work.travel;
    do i=1 to 6 by 2;
        trip + i;
    end;
run;

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

a. 2
b. 3
c. 9
d. 10