SAS Training

SAS Certified Base Programmer 123 Questions (16)

The following SAS program is submitted:

data work.empsalary;
    set work.people (in = inemp)
        work.money(in = insal);
    if insal and inemp;
run;

The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain?

A. 0
B. 5
C. 7
D. 12

SAS Certified Base Programmer 123 Questions (15)

The following SAS program is submitted:

data numrecords;
    infile 'file-specification';
    input @1 patient $15.
        relative $ 16-26 @;
    if relative = 'children' then
        input @54 diagnosis $15. @;
    else if relative = 'parents' then
        input @28 doctor $15.
            clinic $ 44-53
            @54 diagnosis $15. @;
        input age;
run;

How many raw data records are read during each iteration of the DATA step during execution?

A. 1
B. 2
C. 3
D. 4

SAS Certified Base Programmer 123 Questions (14)

A raw data file is listed below:

RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"

The following SAS program is submitted using the raw data file as input:

data work.condo_ranch;
    infile'file-specification' dsd;
    input style $ @;
    if style = 'CONDO' or style = 'RANCH';
        input sqfeet bedrooms baths street $ price : dollar10.;
run;

How many observations will the output data set contain?

A. 0
B. 3
C. 5
D. 7

SAS Certified Base Programmer 123 Questions (13)

A raw data file is listed below:

RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"

The following SAS program is submitted using the raw data file as input:

data work.condo_ranch;
    infile'file-specification' dsd;
    input style $ @;
    if style = 'CONDO' or style = 'RANCH' then
        input sqfeet bedrooms baths street $ price : dollar10.;
run;

How many observations does the WORK.CONDO_RANCH data set contain?

A. 0
B. 3
C. 5
D. 7

SAS Certified Base Programmer 123 Questions (12)

The contents of the raw data file FURNITURE are listed below:

----|----10---|----20---|----30
chair,,table
chair,couch,table

The following SAS program is submitted:
data stock;
    infile 'furniture' dsd;
    input item1 $ item2 $ item3 $;
run;

Which one of the following is the value of the variable named ITEM2 in the first observation of the output data set?

A. table
B. ,table
C. . (missing numeric value)
D. ‘ ‘ (missing character value)