SAS Training

SAS Certified Base Programmer 123 Questions (61)

The following SAS program is submitted:

data work.passengers;
    if OrigPassengers = . then
        OrigPassengers=100;
    TransPassengers= 100;
    OrigPassengers= .;
    NonPaying= 10;
    TotalPassengers= sum (OrigPassengers, TransPassengers);
run;

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

A. 100
B. 110
C. 200
D. . (missing numeric value)

SAS Certified Base Programmer 123 Questions (60)

The following SAS program is submitted:

data work.passengers;
    if OrigPassengers = . then
        OrigPassengers=100;
    TransPassengers= 100;
    OrigPassengers= .;
    NonPaying= 10;
    TotalPassengers= OrigPassengers + TransPassengers;
run;

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

A. 100
B. 110
C. 200
D. . (missing numeric value)

SAS Certified Base Programmer 123 Questions (59)

The following SAS program is submitted:

data work.staff;
    JobCategory= 'FA';
    JobLevel= '1';
    jobCategory= JobCategory || JobLevel;
run;

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

A. FA
B. FA1
C. FA 1
D. ‘ ‘ (missing character value)

SAS Certified Base Programmer 123 Questions (58)

The following SAS program is submitted:

data work.one;
    x = 3;
    y = 2;
    z = x ** y;
run;

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

A. 6
B. 9
C. . (missing numeric value)
D. The program fails to execute due to errors.

SAS Certified Base Programmer 123 Questions (57)

The SAS data set named WORK.TEST is listed below:

capacity airplanetype staff
150      Large        10

Which one of the following SAS programs created this data set?

A.

data work.test;
    capacity = 150;
    if 100 le capacity le 200 then
        airplanetype = 'Large' and staff = 10;
    else airplanetype = 'Small' and staff = 5;
run;

B.

data work.test;
    capacity = 150;
    if 100 le capacity le 200 then
        do;
            airplanetype = 'Large';
            staff = 10;
        end;
    else
        do;
            airplanetype = 'Small';
            staff = 5;
        end;
run;

C.

data work.test;
    capacity = 150;
    if 100 le capacity le 200 then
        do;
            airplanetype = 'Large';
            staff = 10;
    else
        do;
            airplanetype = 'Small';
            staff = 5;
    end;
run;

D.

data work.test;
    capacity = 150;
    if 100 le capacity le 200 then;
        airplanetype = 'Small';
        staff = 5;
    else;
        airplanetype = 'Large';
        staff = 10;
run;